Skip to Content
0
Former Member
Jan 25, 2011 at 02:58 PM

Currency Conversion based on condition in BW

226 Views

Hello,

I have gone through the cople weblogs/links/doc whatever information I found on currency conversion. However I am not able to figure out what could be done in below scenario. Please guide.

Scenario -->

I have STATUS and POSTING_DATE in my Cube. Key Figure in this cube is AMOUNT. Transactions are created in source system in local currency. When data is extracted to BW, I get AMOUNT in local currency and with right clicking on this column in Bex, I can convert it in Fix Target currency or I can permanently create one new column in my report which will always shows fixed target currency for AMOUNT. So far so good.

Now the problem is I wanted to use the conversison rate maintained in TCURR table based on some condition.

Ex: IF STATUS=CLOSED, then use Conversion rate as of POSTING_DATE,

ELSE, use current date exchange rate.

Standard currency conversion always use curent date for calculating exchange rate, but can I use conversion rate as of POSTING_DATE?

Please advice.

Regards

Pankaj