Skip to Content
avatar image
Dario Balice

SAP HANA Graphic Calculation View Currency Conversion does not work

Dec 18, 2017 at 04:37 PM | 184 Views

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

BW SAP HANA Modeling Tools (Eclipse)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Laurens Cleyman
    4 days ago

    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/3da1c6b9d735423ba248e30a9bcfeee4.html

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

    Add comment
    10|10000 characters needed characters exceeded