Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can the Allocation object be used in the designer of a calc manager for multi dim?

User_5PKGBSep 7 2021

How can the Allocation object be used in the designer of a calc manager for multi dimension? The allocation range will only allow one dimension unlike ERP where it allows multiple dimension. I need something to use as a mdallocate. so it would give option in the exclude multiple dimensions something along the lines of this.
"Account1" = @MDALLOCATE(("Account2"->"Group1_DIM1"->"All_DIM_3"->"All_DIM_4"*(100/100)) , 2, @remove(@Relative("Group1_DIM_3", 0),@LIST("DIM_3_EXCLUDING_LIST")) ,
@remove(@Relative("Group1_DIM_4", 0),@LIST("DIM_4_EXCLUDING_LIST")) , "Driver_Account"->"DIM_1_VAL" , , share , noRound );
Capture.PNG

Comments