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

Need to Improve Aggregation Run Time

Accepted answer
163
Views
22
Comments
in Planning 22 comments

Summary: Want to decrease time it takes to run an agg.

Content (required): Currently takes about 40 minutes to agg one period, one scenario, income statement only. Would like to run an agg for a full year that doesn't take hours.

Dense: Accounts - 1350; Period - 34

Sparse: Class - 13; Subsidiary - 76; Location - 3; Department - 992; Tracker - 110; Item - 150; Relationship - 24909; Version - 2; Scenario - 64; Currency - 8; Years - 15

Note, for Relationship, we only need to agg those with data, approx 19000 members. we have these broken out into separate active/inactive rollups.

Tracker in rule = Amount. Only 2 members under Amount

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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