Consolidation Rule taking Too much time on Writing Netting of Rule which checks AllCustomTop members
Hi
I want to Write netting off logic in FCCS Consolidation insertion rule 10. Rule checks the two accounts data at total level combination and Passes net off entry if total level one account value is less than other account.
But on Specifying Custom dimension top member in IF condition it takes too much time then expected.
Below is the script is someone can help in this.
-----------------------------------------------------------------------------------
FIX("Entity Input","Entity Currency","FCCS_Periodic",@LEVMBRS("Total Business Line", 0), @LEVMBRS("Total Department", 0)
@LEVMBRS("ProjectNAdj", 0 ), @LEVMBRS("Total Region", 0 )/*,@LEVMBRS("FCCS_Mvmts_Subtotal", 0 )*/,"FCCS_ClosingBalance_Input")
FIX (
"12047011","12047021","11071011","11081011","11082011","11083011","12051011","12052011","12053011","22701111","22106111","22702111",
"21051011","21041011","21042011","21043011","22501111","22502111","22503111","11063011","11061011","22401111","12031011","21021011",
"21022011","22402111")
"FCCS_Managed Data" (
@CALCMODE(BOTTOMUP);
IF (@ISMBR("FY22") AND @ISMBR("Sep"))