Will running multiple Business Rules (in BSO cubes) with an Aggregation component at the same time s
Content
Will running multiple Business Rules with an Aggregation component at the same time slow down performance significantly? What about where multiple rules are run in separate cubes (BSO)?
When each rule is run on its own, then performance is acceptible. However, when multiple rules (not the same rule) are run, then performance slows down significantly to the point where each rule takes longer than if they were run one by one in succession.
Also, in this situation, will the use of CALCPARALLEL cause significant slow down too?
End users wanted the ability to check their respective divisional P&L and workforce models when making forecast/plan changes, which is why they require an aggregations to be run on an ad-hoc basis. We have given them the ability to launch these business rules from a tasklist so they are not reliant on us to run this calculation for them. The business rules they are running are restricted to only their respective division, and have tried to limit the number of dimensions that the AGG is performed on as much as possible.