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

@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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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