Moving data from Parent to Child with alternate hierarchies

@RELATIVE(&quot

Summary

Cannot move data from parent to child in alternate hierarchy

Content

Hi All,

 

I am building a script in a BSO cube where I need to move data from a parent to the children of the member. I have created that below.

 

FIX("Account",@RELATIVE("Entity",0),Version,Scenario,Year)

     Jan (

          IF(@ISMBR(@RELATIVE("Entity",0)))

               Jan=@PARENT(@CURRMBR("Site"));

          ENDIF

     )

ENDFIX

 

 

This script is working, however, it will only move data from the primary hierarchy. I need this script to function on an alternate hierarchy.

 

I.e.

     Primary Hierarchy                                    Alternate Hierarchy

               Node A                                                      Node AA (store)

                         Child 1                                                  Child 1 (shared)