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