Converting Currency and Unit Values
As you bring data together from various sources, you will encounter values in different currencies and units. These values will need to be converted and harmonized to allow accurate and meaningful comparisons. SAP Datasphere uses the standard SAP TCUR* and T006* tables and SAP HANA functions to perform these conversions.
Converting Currency Values
-
Graphical views - See Create a Currency Conversion Column in a Graphical View.
-
SQL views - See Example: Converting Currency Values with CONVERT_CURRENCY.
-
Analytic models - See Create a Conversion Measure for Currencies.
-
Business Builder objects - See Use Currency Conversion.
-
SAP Analytics Cloud planning models - See Reuse SAP Datasphere Currency Rate Views in Seamless Planning Models in the SAP Analytics Cloud documentation.
-
Amount with Currency - for the measure containing the values.
-
Currency Code - for the attribute containing the codes.
Converting Unit Values
-
Graphical views - see Create a Unit Conversion Column in a Graphical View.
-
SQL views - use the CONVERT_UNIT function.
-
Analytic models - see Create a Conversion Measure for Units.
-
Quantity with Unit - for the measure containing the values.
-
Unit of Measure - for the attribute containing the codes.