Forum Discussion
A big driving factor pushing you to a new cube or not is often, and primarily, the entity dimension. If the forecasting and budgeting process use a different entity dimension than the one currently used for Actuals (for example, if Actuals follows legal entity and budget and forecast want to have department or cost center as their entity dim), that will automatically drive you to a new cube.
I think entity is the primary driver.
If Budget and Forecast share the same entity dimension as Actuals, then IMHO there is not a reason to put them in their own cube. Scenario is part of the data unit so Budget and Forecast will naturally be in their own data unit.
And resources are shared across an entire environment, not app or cube, so that is not a reason to need to separate them out.
You can also apply varying security by scenario, so security is not a reason in and of itself to go to a different cube.
Plus data movement and reporting will be far easier if Budget and Forecast are in the same cube. Meaning your cube views can pull in Actuals, Budget and Forecast columns without having to move data between cubes.
I am curious what others think but I believe entity is the primary driver for cube(s).
Related Content
- 11 months ago
- 11 months ago
- 9 months ago
- 10 months ago