Forum Discussion

Michael_Laroche's avatar
Michael_Laroche
New Contributor II
4 months ago

Multiple Scenario reporting

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
  • IftaqarAhmed's avatar
    IftaqarAhmed
    New Contributor III
    4 months ago

    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's avatar
    KarlT
    Contributor III
    4 months ago

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