Planning: When adding a list of custom dimension members to the calculation it take long time
Hello,
We have a problem with performance for our rules, when ever we add custom dimension to the calculations, it take longer time:
Ex: this script is taking 1:30 minutes to push down drivers using the Target version:
FIX(
@RELATIVE("YearTotal", 0),&SecondYear,
@REMOVE(@RELATIVE({RBBSP_Entity}, 0), @LIST(@UDA("Entity", "notactive"))),
"Budget","Target",
@REMOVE(@RELATIVE({RBBSP_COA}, 0), @LIST(@UDA("Chart of Account", "notactivecoa"))),
"No Attribute Value","SAR",
"1_ST", "0_CS1", "0_CS2")
"F700" = "YearTotal"->&SecondYear->{RBBSP_Entity}->"Budget"->"Target"->{RBBSP_COA}->"No Attribute Value"->"SAR"->{RBBSP_Strategy}->{RBBSP_Custom1}->{RBBSP_Custom2};
ENDFIX;
But when i define Relative Level0 members of custom1 dimension (