Need to Improve Aggregation Run Time
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):