Hana2 sp7 - A calculation view has different behavior if used alone or in another view

[itluca]

We have graphical calculation view which exposes the currency data but, in our production environment only, if we use this view in another calculation view in a projection node as in the following image (view "_SYS_BIC"."WFP.SCOPE/CA_CO_DIST_LIST_COPY_HAP_NEW"):

we have a different behavior if we check the data into the original currency view CA_EXCHANGE_RATES_NEW (UN_EXCHANGE_RATE = 12.500 and FROM_RATIO = 10 for Currency = SYP)

Or if we display the data into the projection_node named Exchange_rate which contains the view CA_EXCHANGE_RATES_NEW (UN_EXCHANGE_RATE = 1.250 and FROM_RATIO = 1 for Currency = SYP):

Into the projection node there is only a filter which excludes some records:

This issue doesn’t involves all the currency but only 3 CURRENCY out of the over 100 in our system, but the strangest thing is that in the data preview of the node Exchange_rate if we insert also other currencies as a filter the result becomes correct again (UN_EXCHANGE_RATE = 12.500 and FROM_RATIO = 10 for Currency = SYP if we display also another currency for example the currency IRR in this case):

But if we perform a select on the node of the view the result for UN_EXCHANGE_RATE is always wrong (1.250 instead of 12.500):

And if we perform a select on the final view "_SYS_BIC"."WFP.SCOPE/CA_CO_DIST_LIST_COPY_HAP_NEW" we have a wrong result 25.977.194,4 for TRANSFER_CASH_VALUE_IN_USD (which is obtained from the formula 32.471.493.000 / 1.250 instead of 32.471.493.000 / 12.500):

when is the correct value from Dev. System 2.597.719,44:

We have this issue only on prod. environment, we have the same calculation view on our Dev. system that works correctly. Both Hana dev. and Hana prod have the same Version 2 SP 7

Any Advice?

Regards

Luca

[HakanHaslaman]

Did you check if the data in both environments is consistent? There might be some differences in the data that are causing this issue. Also, are the calculation view in both environments the same? There might be some differences in the calculation view that are causing this issue.

[itluca]

Hi,

Thanks for your reply.

We have the exact same data in both systems and and all the calculation views involved are also identical (the problem occurred after the transport). Btw we have found a workaround: The view CA_EXCHANGE_RATES_NEW contains another Hana view (from another schema) let's say the view XXX, if we load data from he view XXX into an hana table 'Table_A' and then we create a copy of the CA_EXCHANGE_RATES_NEW view (named CA_EXCHANGE_RATES_NEW_BIS) which uses 'Table_A', this new view works works perfectly also if we use this view in another calculation view.

Regards