Hello Everyone,
In this document, I tried to explain "Currency Conversion" functionality. Through this, I am trying to provide the general functionality and idea about the Currency translation in SAP HANA.
Note:
While using this option you need to replicate the standard table into SAP HANA that are TCURR, TCURC, TCURX, TCURF, TCURT, TCURV . If these standard tables are not available then you will not be able to perform Currency Conversion.
Procedure:
1. Create an Analytical view
2. Enter “AN_TEST” for the name of the view
3. Select Table and click finish.
4. Select the measures and attributes to be included in the analytical view.
5. Now, Right click on Calculated Measures and choose New.
6. Create the Calculated Measure, "Profit".
7. Create second Calculated Measure, "Profit_IN_USD".
Note: you can select either attribute or fixed Currency according to the requirement.
In this example, I am using “USD” that is fixed currency and “Currency” that is an attribute.
8. Save and Activate Analytical View.
9. Display the data in your Analytical View.
Hope it is helpful. :smile:
Thanks for reading the document.
Regards,
Neha Singla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
6 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 | |
2 |