@CALCMODE (BOTTOMUP) and @CALCMODE(BLOCK) issue in FCCS insertion rules leads to performance issue
Summary:
Hi Team,
I ran the "Recommendations" feature in FCCS and saw the following:
Showing 1 warning out of 1. Line 9: Use @CALCMODE(BLOCK) for member block "Entity Currency"
Using the @CALCMODE(BLOCK) instead of @CALCMODE(BOTTOMUP) creates an issue like the consolidation rule never gets completed.
Content (please ensure you mask any confidential information):
Below is the full rule for your reference:
SET HYBRIDBSOINCALCSCRIPT NONE; |
---|
FIX (@LEVMBRS("Custom1" |
FIX ("FCCS_OpeningBalance" |
FIX ("FCCS_Entity Input" |
"Entity Currency" ( |
@CALCMODE(BOTTOMUP); |
IF ("FCCS_Percent Consol Change"->"S_Parent Source"->"FCCS_Entity Input"->"No Custom4"->"No Custom3"->"No Custom2"->"No Custom1"->"FCCS_No Intercompany"->"FCCS_No Movement"->"No Currency"->"FCCS_Periodic" == 1) |