Skip to Content
0
Former Member
Feb 25, 2009 at 08:39 AM

Currency translation using replacement path variable

129 Views

Hello Gurus,

Current scenario -

the user plans in group currency keyfigure in say EUR & it is then converted to other currencies using planning functions.

but the prob is everything is hard coded . like for swedish companies, there is separate planning function for EUR --> SWK which writes into a local currency keyfigure using a different Currency translation type, likewise for all other countries.

So whenever we have a new company coming in or changes in currency for existing company , maintenances becomes hectic.

so we want to remove such hard coded rules & automate stuffs

my proposed solution -

I was reading in lot of sdn forums, & based on that i was able to think a solution.

the Currency is an attribute of Company Code.

Hence i would define a authorization variable CCA on company code. then again a replacement path variable RPB on Currency deriving it from the Company code var CCA. I can define a new currency conversion type with target currency from this replacement path variable RPB.

Then in Query designer , in the local currency keyfigure i would select currency conversion using the defined currency conversion type.

Do you think the above will fulfill my requirements -

the user plans in group currency , & this is converted to all local currencies & saved in the cube at the sametime when user saves his input values.

am i missing any steps ?

any help , appreciable .

Thanks

ramesh