FCCS Essbase script is not working
Hi Team,
We have defined below script to aggregate the data appearing at the child member to its respective parent member for Amount override and GBP, but it seems not working. What could be the workaround or function that can be used here?
FIX (@Relative("SH_Segment", 0),
@Relative("Total Custom 2", 0),
@Relative("Total Analysis", 0),
@Relative("FCCS_Intercompany Top", 0),
"Mvmts_ProceedsFrmSaleOfInvestments",
@Relative("IFRS_FINAL", 0),
"FCCS_Periodic",
@REMOVE(@Relative("FCCS_Amount Override Accounts", 0), "FCCS_AmountOverride_Placeholder_Account"))
"DS_SDIV" (
@CALCMODE(BOTTOMUP);
IF (@ISMBR(@PARENT("Entity")))
"DS_SDIV" = @SUM(@CHILDREN(@CURRMBR("Entity"))->"DS_SDIV");
ENDIF
)
ENDFIX
Regards
Jyoti Sharma