Need an update to an aggregation rule
Summary:
Content (please ensure you mask any confidential information):
We recently shanged our subsidiary storage type to store. This has decrease refresh time, but increased aggregation time. Is there somthing I can do to the business rule to decreae the run time?
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 ("Amount",0))