Skip to main content
April 24, 2026
Question

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

  • April 24, 2026
  • 0 replies
  • 1 view

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!