Forum Discussion

STDN's avatar
STDN
New Contributor III
2 years ago

Dimension Hierarchy

Hi All,   I need a same base member in different parent members in Account dimension and it should aggregate to their respective parents, do i need to create multiple base members or I can use th...
Metadata
AdamB's avatar
AdamB
New Contributor II
2 years ago

Hi there,

You can use the relation. A simple way is to select the base member and then right click on on it and select "Copy Selected Members." From there, click on the new parent you would like to add it to and then right click and select "Paste Relationships (Add)." This will add the base account to the new respective parent and every instance that respective parent member is shared throughout the hierarchies. 

As Manasa stated, keep in mind that any changes to the base member will be reflected in all shared relationships.

Thanks,

Adam

  • STDN's avatar
    STDN
    New Contributor III
    2 years ago

    Thanks for your response, I have tried the same thing but I am getting same base values in the different parent members, It shouldn't be the case, I need to respective values from the base members to the different parent members, can you please help me with that.

     

    Thanks in Advance.