Moving data from Parent to Child with alternate hierarchies
Summary
Cannot move data from parent to child in alternate hierarchyContent
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)