Hi Experts,
In a project that implement both Planning and Consolidation modules, what would be the performance consideration in BPC Design? To narrow it down, I'm focusing on the modelling (number of environments, models, dimensions).
I'm between 2 options:
- Separate consolidation and planning module to their own environment
- Keep both consolidation and planning module in 1 environment
Option one was presented to me was because this reason: "Number of models and dimensions of each environment should be kept minimal for performance reason". I'm not sure if this is a true case, since I don't think each environment has allocated number of threads in BPC engine. Please correct me if I'm wrong or if there are any other pros in this design
Option two are in my preference because some obvious reasons:
- We are going to have a heavy data traffic between planning modules and consolidation model. Data transfers are much easier done within 1 environment
- Dimensions maybe shared between planning and consolidation modules, which will make master data maintenance more efficient
However, option two comes with some cons as well:
- Functions such as security, work status, global definitions for business rules are hard to maintain as they are shared between all models in the same environment
- Environment maintenance such as setting it offline/online will impact both consolidation and planning users
Please share your thoughts on this matter.
Regards,
Hendry
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.