Multiple Scenario reporting

[Michael_Laroche]

Hi,

Is there a way through cube views member formulas or any other means to combine two scenarios? For example when reporting Actuals vs. Plan we now have a Plan_1.0 and Plan_2.0.  Rather than creating a new scenario to combine the two - is there a way to report on Actuals vs. (Plan_1.0+Plan_2.0)? 

Thank you!

[IftaqarAhmed]

You could use other dimensions, such as UD8 or Flow, to achieve this, and then apply a CV formula or create a calculated member to compute the variance.

I hope this helps!

[KarlT]

You could create a member (say in UD8) that dynamically calculates this variance, and then reference this in your cube views/reports.