0COOM_C02 cube to have 2 different currency types

[Former Member]

Dear all,

i have activated 0COOM_C02 cube, what i need is to get data in two different currency types (both in eur and usd). Is it possible with that? or should i modify that?

Thanks

[Former Member · Accepted solution]

Hi Ravi,

I need to extract data from R3 in 2 different currency, as far as i know, in 0COOM_C02 there are 0amount and fixed amount fields, which both have 0currency field.

That means i should modify my cube to get cost data in two different currency?

thanks

[Former Member · Accepted solution]

Hi John,

If you want to fix the Local Currency to any Fixed amount you can directly map to them.

And you can keep 0amount for the Global Currency amounts.

By this way you can maintain both currencies.

Hope you got ..

Regards,

Ravi Kanth

[Former Member]

So that means i should modify 0amountfx to have, lets say fix currency EURO?

then with 0amount and 0 currency i keep global values, and 0amountfx i can keep EURO value?

Thanks

[Former Member]

Hi John,

Sorry for later Reply.

Yeah just make it Fixed for the fixed one and Global to others ...

That can help you.

Regards,

Ravi Kanth

[Former Member]

Hi John,

Where you need to see the Data; in the query result or in the Cube??

Please be clear.

Regards,

Ravi Kanth