Skip to Content
avatar image
Former Member

Importing DSO with Key Figures having Data Type Currency on an Hana Calculation view

Hi Experts ,

I have problems using Calculation View based on a BW DSO when I read Key Figures with data type currency. Hana cannot manage "Currency Data Type" and turn the KF in Decimal.

The currency with different decimal place in the TCURX table (like CLP, COP ) are recorded on BW differently from the visualized value (e.g. CLP 10.000 is recorded as CLP 100 for ). In the view I acquire the value CLP 100. the view is the source for a BW Composite Provider that convert the value in CLP 1 !!!! I think the composite consider that the passed value is the visualized value and manage the special currency.

How can manage correctly the Key Figures having Data Type Currency? There is some setting on Calculation View or Composite Providers or other? There is a standard mode to manage this case without customizing the view with custom multiplication based on currency?

Note: On top of the Composite Provider there are BEX reports very complicated , I would not modify the logic of this BEXs.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers