Performance issues with Essbase Calc Script using @CALCMODE(BOTTOMUP);

Summary:

We hare facing performance issues while executing the following ODR, basically for a single entity takes 22 minutes to complete.

There are scenarios in which business users needed to run the rule for 45 entities.

Kindly request your advice.

Content (please ensure you mask any confidential information):

Original Rule

Old>

SET HYBRIDBSOINCALCSCRIPT FULL;
SET IGNORECONSTANTS True;
SET EMPTYMEMBERSETS ON;
FIX ("FCCS_Periodic")
/Controls PH1/
FIX ("no Custom1", "no Custom2", "no Custom4", "FCCS_No Movement", "FCCS_Data Input", Ecart)
FIX ("no Custom3")

"FCCS_no Intercompany" (
"Ecart" = #missing;
"Ecart" = @ABS("FCCS_Total Balance Sheet"->"120"->"FCCS_Managed Data"->"FCCS_Intercompany Top"->"Total Custom1"->"Total Custom2"->"Total Custom3"->"Total Custom4"->"FCCS_Entity Input"->"FCCS_YTD");