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

FCCS Essbase script is not working

Accepted answer
92
Views
11
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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