Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Consolidation Rule taking Too much time on Writing Netting of Rule which checks AllCustomTop members — Cloud Customer Connect
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

Consolidation Rule taking Too much time on Writing Netting of Rule which checks AllCustomTop members

Received Response
25
Views
1
Comments

Hi

I want to Write netting off logic in FCCS Consolidation insertion rule 10. Rule checks the two accounts data at total level combination and Passes net off entry if total level one account value is less than other account.

But on Specifying Custom dimension top member in IF condition it takes too much time then expected.

Below is the script is someone can help in this.

-----------------------------------------------------------------------------------

FIX("Entity Input","Entity Currency","FCCS_Periodic",@LEVMBRS("Total Business Line", 0), @LEVMBRS("Total Department", 0)

@LEVMBRS("ProjectNAdj", 0 ), @LEVMBRS("Total Region", 0 )/*,@LEVMBRS("FCCS_Mvmts_Subtotal", 0 )*/,"FCCS_ClosingBalance_Input")


FIX (

"12047011","12047021","11071011","11081011","11082011","11083011","12051011","12052011","12053011","22701111","22106111","22702111",

"21051011","21041011","21042011","21043011","22501111","22502111","22503111","11063011","11061011","22401111","12031011","21021011",

"21022011","22402111")

"FCCS_Managed Data" (

@CALCMODE(BOTTOMUP);

IF (@ISMBR("FY22") AND @ISMBR("Sep"))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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