Show 3 different currencies in the Report

[Former Member]

Hi Experts,

In my query I have three key figures which are shown in local currency. Now i have a new requirement wherein they would like to see the key figures in local, document and group currency based on selection.

How do I go about it?

Should I create three different columns for each of these key figures and then do conversion but this would look very messy and ugly.

Is there another way wherein in the selection screen I can ask the user to select his local currency, target currency and then exe

[former_member102099]

Hello,

I am not sure what you mean by ugly..does it mean more number of records??

As other have suggested you have the identifier currency type to identify the currencies but if not present then you will have to go for currency conversion.

If you want to give selections at the screen then you will have to do currency conversion at the query level.

There are a lot of documents which explains currency conversion at query level.

If you do currency conversion at query level then you will not to create any extra column...the user will have to just select the target currency while running the query and you will have to use the currency conversion in the key figure properties...this will give you the values in the currency you require.

you will have to create a input enabled variable on 0currency and use it in the query as restriction. search the SDN for documents as you will find a lot ofdocument on how to do it.

Regards

Ajeet

[emjay]

How is the data target built. Do you have an identifier (like 0CURTYPE) to tell the different type of currencies or are they different key figures in the cube. If they are identified based on a char like curtype then you can create a variable on that char and can ask the user the type of report he wants to see. if its based on keyfigures then create 3 columns and then hide them and then create a formula based on if then condition and then display to the user only 1 key figure but the internal formula would pick the right key figure and display.

Hope this helps.

[Former Member]

Hi,

I don't have 0CURTYPE in my DSO or Cube. I have 3 key figures say PO Price, Avg Contract Price and Avg Invoice Price. These objects have the currecny mapped to 0LOC_CURRCY.

Can you tell me how do I then accomplish the requirement of showing the required currency based on the user's selection.

Thanks

[Former Member]

Hello again,

as you see 0LOC_CURRCY means local currency, so you only have the local currency in your cube.

You should extract the values for the 3 key figures in the other 2 currencies.

Diogo.

[former_member102099]

Hello,

check this

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/bi/currency%2btranslation%2bin%2bbex

/people/rasim.manavoglu/blog/2007/04/30/currency-currency-currency

Regards

Ajeet

[Former Member]

Hi Diogo,

In the cube under the unit dimension I do have the 0DOC_CURRCY. Now say I have the PO Value in Loc_Currcy and I need to convert this value in Doc_Currcy, how do i go about it. But yes the user would like to select the target and source currencies and this applies to three key figures.

Thanks

[Former Member]

Ok,

That depends on your data, and how you can tell the system what will be the target currency.

I mean, you have your PO value as for example in local currency, let's say for example that it is CZK (Check Republic currency).

Now, if you know by default that your document currency is EUR, you can do the currency conversion on the query after executing.

Diogo.

[Former Member]

Hi,

I am a little lost since it's my first shot at showing thee different currencies in the report.

I have 3 key figures say PO Price, Avg Contract Price and Avg Invoice Price. These objects have the currecny mapped to 0LOC_CURRCY.

So if i want to show say PO Price in Loc, Doc and Group Currency, then I need to have the following:

1. PO Price should exist in Loc, Doc and Group Currency in the Datasource or R3 table.

2. In transformation I should have 0Curtype

3. But how do I match what value to Curtype from the DS in the transformation?

Thanks

[Former Member]

Hi,

I am a little lost since it's my first shot at showing thee different currencies in the report.

I have 3 key figures say PO Price, Avg Contract Price and Avg Invoice Price. These objects have the currecny mapped to 0LOC_CURRCY.

So if i want to show say PO Price in Loc, Doc and Group Currency, then I need to have the following:

1. PO Price should exist in Loc, Doc and Group Currency in the Datasource or R3 table.

2. In transformation I should have 0Curtype

3. But how do I match what value to Curtype from the DS in the transformation?

Thanks

[Former Member]

Hi there,

Yes you can do that.

Normally that should be stored in the object 0CURTYPE

And normally you have your data in the DataProvider with 0CURTYPE = 0, 10 and 20, or 0, 10, 30 (representing values for local, document and group).

And you can insert 0CURTYPE in the filter of the query and restrict it by a variable where the user enters the type of currency he/she wants to see.

Diogo.