Can this be optimized further?
Summary: Hey All, just wondering if this can still be optimized without changing some of the parents to Dynamic Calc?. My Aggregation rule for actual data is taking approximately 10-15mins. I tried to use fixparallel and It reduced the run time by a few minutes but the Subsidiary dimension did not aggregate to parent level. Thanks in advanced!
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
10mins runtime
SET AGGMISSG ON;
SET UPDATECALC OFF;
SET EMPTYMEMBERSETS ON;
FIX(&PriorYr:&LastClosedYr, "Actual", "Base",@Relative("Amount",0))