How can I improve Aggregation Rule running very long?
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?
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.