Currency conversion issue

[Former Member]

Hi,

I created analytic view for the table MSEG which has the measure "DMBTR" and currency "WAERS" as a attribute.

Then created a calculated measure as follow

In variable pop up screen , for the currency i gave as "INR".

And excuting the analytic view got the following error message : 

"Error Executing Query: SAP DBTech JDBC: [339]: invalid number: inr at function __constructor__()".

When checking the TCURR table , the field GDATU has in inverted date format.

For eg. 07/09/2012 in the TCURR table for the field it has 79879092.

Whther we need to convert that date into normal date?

Can you please guide me how to resolve.

Thanks in advance!!!

[former_member191765]

I think while replicating the transformation has to be carried

[Former Member]

Hi,

1. I dont have the acces for replication. Could please check and let me know normally how the format will be in the TCURR table?

2. When im pass the Fixed value for currency conversion im getting the output but when i passed the dynamic value for currency conversion im getting the error "Error Executing Query: SAP DBTech JDBC: [339]: invalid number: inr at function __constructor__()" is coming?