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

How do I speed up an aggregation rule

edited Apr 1, 2026 7:53PM in Planning 18 comments

Summary:


Content (please ensure you mask any confidential information):

We recently changed our subsidiary storage type to store. This has decreased refresh time in Smart View, but increased aggregation time. How can I write the rule to decrease the run time? I have included an example of one agg rule below.

If I change "@RELATIVE ("Income Statement",0)" to just "Income Statement", will is aggregate all accounts below or only that?


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

FIX( @RELATIVE ("Capex Total",0), @RELATIVE ("Headcount Metrics",0), @RELATIVE ("Income Statement",0), @RELATIVE ("Gross_Wages_Accts",0), @RELATIVE ("Allocation_Accounts",0), @RELATIVE ("YearTotal",0), &FcstYr1:&FcstYr3, @RELATIVE ("Tot_Topside",0), &CurrentScenario, @RELATIVE ("Total Location",0),@RELATIVE ("Total Class",0), @RELATIVE ("Amount",0))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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