Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Moving data from Parent to Child with alternate hierarchies

edited May 29, 2019 2:14PM in Planning 2 comments

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!