Hi Experts
I have a situation where different accounts in the Balance Sheet is translated at different exchange rates. For example, my hierarchy on P_ACCT:
Cash and cash equivalents Z0031011000
...More nodes and accounts
Net Receivables Z0031012000
...More nodes and accounts
The customer wants to translate Z0031011000 at a rate e.g. 1.05 and Z0031012000 at a rate of 1.075.
I have 2 questions regarding this:
- Since you can only plan on base-members, I cannot store a rate against a hierarchy node, or is there a way or workaroud?
- Is it possible to translate all the accounts below the node at the stored rate and how would the MDX look like?
Any help would be appreciated.
Thanks
L.