SAP HANA Graphic Calculation View Currency Conversion does not work

[dario_balice]

Hi Gurus,

I'm developing in SAP HANA (Eclipse Neon) a Graphic Calculation View that has to convert some amounts from a currency to another one at a particular date; all data are in the view datasource (source currency, target currency, date used for currency conversion), and their semantic is correctly populated.

I created new calculated columns, the Expression is "original amount figure" * 1, and in the semantic tab I indicated all needed parameters (schema, client, columns for source and target currency, exchange rate type, conversion date).

There is a field named "Exchange Rate", this is not mandatory and I left it blank (I think its meaning is the same of "READ_TCURR" parameter of SAP CONVERT_TO_FOREIGN_CURRENCY Function Module).

I tried also to mark also 'Generate result currency column', but nothing changed.

The basis tables are present in schema used as default in Calculation View, the Calculation View seems correct but the amounts generated are the same of the source ones, so if the original amount is 100, the converted amount is 100, no conversion occurs but also no error occurs.

I don't know the reason of this strange behavior.

Any idea? Thanks in advance.

Dario

[dario_balice]

The Calculation View was correct.

It seems solved with some SAPNote installation...thanks for the answer!

Dario

[dgallegog]

Hello,

I have the same problem in currency conversion in HANA Calc View.

Could you please indicate SAP Note installed?

Thanks and reregards.

David

[laurens_cleyman]

Hi,

You can uncheck the 'Generate result currency column', it will only generate a column to store the result currency conversion values.

Maybe it is a conversion failure? Set the 'Upon Conversion Failure' to 'Set to NULL' to find the values where it failes and find out why.

If you select 'Ignore' the modeler displays the unconverted value for the corresponding records. And that is probably the case with you 🙂

For finding the error: try a fixed type for the source and target currency, maybe something is wrong with the contents of those columns? You can also do that for the conversion date btw.

You are correct by leaving the 'Exchange Rate' empty, you only need to fill this in if you do not want to use the exchange rate from the TCUR-tables but an alternative one.

More info here: https://help.sap.com/viewer/57a523b496cc4531a3676f5d94644899/2.0.02/en-US/3da1c6b9d735423ba248e30a9b...

Btw, out of curosity, why do you multiply the original amount by one?