Newcomer

Multiple Scenario reporting

2 replies
13 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!

Cube View

I

IftaqarAhmed

Member

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