Forum Stats

  • 3,752,192 Users
  • 2,250,468 Discussions
  • 7,867,747 Comments

Discussions

How to get ancestors parent member name for allocation calculation if rates not available

User_Z6AT1
User_Z6AT1 Member Posts: 38 Red Ribbon

Hi all,

I have a ragged hierarchy like below and have rates stored "_Dummy" member. I want to use rates from first parent member (CCC_Dummy) if its available, else take the rates from second parent member (BBB_Dummy), else next parent AAA_Dummy. Does essbase has any function to check and traverse multiple parents ?

I thought of using to below functions to get rates from _Dummy member, but I am not sure how to get ancestors and evaluate the condition from first parent, second parent and so on

(@MEMBER(@CONCATENATE(@NAME(@PARENT(@CURRMBR("Product"))), "_Dummy"))




Tagged: