Skip to Content
0
Former Member
Jan 13, 2011 at 06:52 AM

Planning on non-base members.

32 Views

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.