Forum Discussion

Hatim_Elhaouma's avatar
Hatim_Elhaouma
New Contributor II
17 hours ago

Same Scenario Across Two Cubes vs Separate Scenarios — Pros & Cons?

Hello everyone,

I’m looking for feedback on the pros and cons of using a single Actual scenario across two cubes (e.g., Consolidation and FP&A) versus defining separate scenarios for each cube.

For example:

      Option 1 (shared):

                     Consolidation Cube : Actual (Scenario Type = Actual)

                     FP&A Cube : Actual (Scenario Type = Actual)

     Option 2 (separate):

                     Consolidation Cube : Actual (Scenario Type = Actual)

                     FP&A Cube : Monthly (Scenario Type = Control)

From your experience, how do these approaches compare in terms of data governance, maintenance, performance, flexibility for planning/reporting, and potential risks (e.g., unintended impacts between cubes)?

Any best practices or lessons learned would be greatly appreciated.

Thanks in advance!

No RepliesBe the first to reply