cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation View Currency conversion with decimal shift not working

jbreznar
Participant
0 Kudos
260

Hi,

I am trying to combine VBRK and VBRP tables for billing in a calculation view.

Bellow is the diagram:

jbreznar_0-1728476163743.png

I want to have both fields: net value in document currency and in statistical currency. So I created a calculated column "NETWR_S" in the join node with just a reference "= NETWR".

jbreznar_2-1728476178251.png

 

The original column NETWR has the Decimal shift turned on, so that the values for currency HUF appear correctly (multiplied by 100).

jbreznar_6-1728476712973.png

 

In the Semantic layer, I set this new column NETWR_S as Amount with Currency.

jbreznar_5-1728476629102.png

For this new column, I have the Decimal shift and Conversion on.

jbreznar_4-1728476345016.png

 

The result of the Raw data shows, that the NETWR is taking the decimal shift into account when displaying the result. The NETWR_S hower was converted but the decimal shift did not occur prior to the conversion.

So instead of 0,18 EUR I would expect 18,81 EUR.

jbreznar_3-1728476278102.png

 

Any ideas on what I am doing wrong?

Thank you!

 

 

Accepted Solutions (0)

Answers (3)

Answers (3)

nachtaktiv
Participant
0 Kudos

Check if the currency-customising in your BW system is correct (TCUR... tables)
and if the data has been loaded correctly from the source

jbreznar
Participant
0 Kudos
I checked TCURX and it has data. Otherwise the NETWR column would be wrong for the HUF currency. And this is the table with the important data for the decimal shift. HUF has the CURRDEC value of 0 in the table.
nachtaktiv
Participant
0 Kudos

did you try to let HANA create the target with "Generate result currency column" ?

jbreznar
Participant
0 Kudos
I tried it out now but it's still the same:
nachtaktiv
Participant
0 Kudos

perhaps a double decimal shift is not necessary

jbreznar
Participant
0 Kudos
Hi, the original from which this is referenced, does not have the decimal shift yet (it's seperated in the join). I did try it without and it made no difference. I tried it with also decimal shift back and it didn't work.