Currency conversion for SAP BI data

Tue, 20 Oct 2015 05:47:57 GMT

Hi Experts,

I am new to Qlik , and I need to convert some currencies coming from SAP BI Extractors(Cubes).

In SAP we have three tables TCURX(Non Decimal Currency) , TCURF(Factor Table), TCURR(Exchange rate table) and these are multiplied to get the desired currency.

We cannot directly multiply these records to Exchange rate and get the desired currency.

As Qlik has created these standard connectors for SAP BI, do we have something in Qlik using which we can convert the currencies directly something like Sub routine or method.

I checked currency translation as in SAP link, this may help get a simple scenario , but not with the complex scenario where TCURX(Non Decimal Currency) , TCURF(Factor Table) table are involved.

Please help.

Regards,

Abhishek Bhattacharya

topic Currency conversion for SAP BI data in QlikView

Currency conversion for SAP BI data