Issue with TCURX specific currencies published from BW into HANA and brought back into BW .

[wounky]

Hi,

Experiencing some strange behavior of the ‘no decimal places currencies’. Could you please share your view on the topic?

Scenario:

1. Publish Composite Provider to HANA
2. Create Calculation Views on top not using any decimal places shift
3. Amounts using custom currencies like JPY are displayed correctly in HANA Views
4. Calculation View from Hana is published to oODS view
5. No amount InfoObject is assigned for the oODS View
6. The amount is displayed correctly in oODS view
7. The oODS view is added to the Composite Provider
8. An amount field is associated with an amount that has already been in in the Composite Provider
9. Values for currencies with custom decimal places are calculated once again.

e.g.

The amount is OK in the open ODS view.

Once the ODS Amount is linked to the Composite Provider, it displays ‘custom decimal currencies’ (TCURX) as e.g. on JPY multiplied by a hundred.

• 1.DB value = 4,00 YEN OK

• 2.ODS value = 400,00 YEN OK

• 3.ODS value in Composite Provider = 400 00,00 YEN – NOK

2 zeroes are being added even though they have already been added before.

I have tried to un-assign the GM1AMOUNT InfoObject from GM1AMOUNT did not help.

Could you please tell where is the issue?

Thanks in advance &

Kind regards,

[wounky]

Update:

As soon as the AMOUNT InfoObject is assigned to the oODS View amount, It also doubles the conversion.

[wounky · Accepted solution]

Workaround: Create CV directly on an HDB view instead of the projection created by BW in _SYS_BIC.

[mustafa_cicek]

https://wiki.scn.sap.com/wiki/display/BI/Decimal+Setting+in+HCPR+on+HANA+View+for+Amount+Values

here gives the solution by adjusting the semantics. Reason of the issue in my understanding: calc view gets the external format of the values,so you need associae again inside the calc view semantics with currency field.