I have just finished an FCCS project where consolidations were running very slowly. Someone suggested using @CALCMODE(BOTTOMUP) as shown in the following example. This improved the consolidation time by a couple of orders of magnitude!

/* Checks Balance Sheet balances */
FIX ("MvmtLoaded", "FCCS_Managed Data")
    CLEARDATA ValBalanceSheet;
    ValBalanceSheet(
        @CALCMODE(BOTTOMUP);
        IF(@ISMBR("ActualPhase1"))
            IF("ValPhase1Override" + 0 == 0)
                IF(@ABS("FCCS_Total Balance Sheet-Traditional Approach"->"FCCS_ClosingBalance") > 10)
                    "ValBalanceSheet"->"MvmtLoaded" = "FCCS_Total Balance Sheet-Traditional Approach"->"FCCS_ClosingBalance";
                ENDIF;
            ENDIF;
        ENDIF;
    )
ENDFIX

I should really have thought of this as I have previously used SET FRMLBOTTOMUP in PBCS rules. Since I did not find this tip in any of the best practice guidance I have read, I hope this post will be useful to someone.

In case your were wondering, the plane in the photograph is the Vickers Vimy in which Alcock and Brown made the first non-stop crossing of the Atlantic Ocean 100 years ago in June 1919. The crossing took 15 hours but when the plane landed in Ireland it still had 10 hour of fuel left and could easily have flown to London! It is thought that they landed in Ireland because they had won the prize for the first non-stop crossing and so had no need to fly any further. The aircraft is preserved in the London Science Museum.

How to make Oracle Financial Consolidation and Close (FCCS) consolidations faster using @CALCMODE