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

Will running multiple Business Rules (in BSO cubes) with an Aggregation component at the same time s

Received Response
23
Views
3
Comments
edited Jan 28, 2021 1:14AM in Planning 3 comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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