Skip to main content
M
Michael_Laroche
August 21, 2024

Multiple Scenario reporting

  • August 21, 2024
  • 2 replies
  • 0 views

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!

2 replies

I
IftaqarAhmed
August 21, 2024

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!

K
KarlT
August 23, 2024

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

Terms & ConditionsAccessibility statement