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.

This topic contains the following sections:

Converting Currency Values

To prepare for currency conversion, use the wizard to import or create the necessary TCUR* objects in your space (see Enabling Currency Conversion with TCUR* Tables and Views).
Once the TCUR* views are available in your space, you can use them to do currency conversion in:
You should always identify columns containing currency values and codes with the following semantic types:
  • Amount with Currency - for the measure containing the values.

  • Currency Code - for the attribute containing the codes.

For more information, see Specify Semantic Types for Measures and Attributes.

Converting Unit Values

To prepare for unit conversion, you must import the T006 and T006D tables to your space from your SAP system (or have these tables shared to your space from another space).
Once the T006* views are available in your space, you can use them to do currency conversion in:
You should always identify columns containing unit values and codes with the following semantic types:
  • Quantity with Unit - for the measure containing the values.

  • Unit of Measure - for the attribute containing the codes.

For more information, see Specify Semantic Types for Measures and Attributes.