Can this be optimized further? — Cloud Customer Connect
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

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))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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