FCCS Custom CTA Calculation Rule running for ever
Summary
FCCS Custom CTA Calculation RuleContent
Hi,
I created a custom calculation for CTA Calculation with all tops in source POV like below. The calculation runs for hours together.
Below is my formula.
FIX (
/*DIM:Consolidation*/
"Entity Input",
/*DIM:Currency*/
"Parent Currency", "FCCS_No Movement", "Managed Data", "FCCS_No Intercompany", "[Total Cost_Center].[No Cost_Center]", "[Total Project].[No Project]", "[Total Distribution].[No Distribution]", "[Total Brand].[No Brand]")
"CTACalc" (
@CALCMODE(BOTTOMUP);
/*STARTCOMPONENT:FORMULA*/
"CTACalc"->"FCCS_Periodic" = "FCCS_YTD"->"FCCS_Total Assets"->"Managed Data"->"FCCS_Intercompany Top"->"Total Cost_Center"->"Total Project"->"Total Distribution" - "FCCS_YTD"->"FCCS_Total Liabilities and Equity"->"Managed Data"->"FCCS_Intercompany Top"->"Total Cost_Center"->"Total Project"->"Total Distribution";