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

How can I improve Aggregation Rule running very long?

Summary:

The business rule I have right now aggregating All Entity, all currencies, all months (Jan-Dec), all accounts

and taking around 45 minutes.

Can this be improved?

Content (required):

I have this business rule which is aggregating for All Entity which has around 3500+ and constantly growing with number very fast, it is a sparse dimension.

Now a large number of Entities are Inactive, which would be great if we could not include them in the aggregation, but as I understand we can't limit the Agg("Entity") to lower-level Entity Parent where it only has Active ones.

For example, below is the sample structure.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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