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!