08-27-2024 05:24 PM
Hello,
What are the factors one should consider while deciding between whether to create new cube vs using new scenario type in existing cube for different processes like Forecast/Budgeting etc.
Will creating new scenario type would put any performance issues on existing processes (say for Actuals)?
We don't use any extensibility currently in application, and only using Consolidation (Actuals) with Account recs.
Thanks,
Gaurav
08-27-2024 06:50 PM
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).
08-28-2024 10:45 AM
Hi Gaurav,
I agree with Teresa that Entity is the most common driving factor.
A few other reasons:
Hope it helps. I'm a big proponent of having purpose-driven cubes instead of separate cubes for every process where there's only 1 scenario type active in each.
Nick