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

customized global CTA calc performance issue

in Financial Consolidation and Close 3 comments

We have customized Rule 30 to calculate the global CTA for the client due to complex business requirements. However, this rule is currently affecting performance, as it takes too long to consolidate all entities. We are seeking support to develop an effective rule that will have less impact on performance.

Below is the code for the rule:

SET HYBRIDBSOINCALCSCRIPT NONE;
SET IGNORECONSTANTS TRUE;

FIX ("FCCS_Periodic", @Relative("Intercompany", 0),"Parent Currency", @Relative("Total Custom1", 0), @Relative("Total Custom2", 0), @Relative("Total Custom3", 0), @Relative("Total Custom4", 0), @Relative("MvmtTot", 0),"FCCS_Managed Data")
"FCCS_Entity Input" (
@CALCMODE(BOTTOMUP);
IF ("BalanceSheet" <> 0)
"CTA3052000" -> "Parent Currency" = "TotalAssets" -> "Parent Currency"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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