Forum Discussion

Brooks's avatar
Brooks
New Contributor III
24 days ago

Load to Multiple Scenarios?

Is there a way to load to multiple scenarios from one Workflow?


Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario.

I don't want to create a new workflow for forecast because I want to use the values from People Planning that have been calculated for Actual_PP to populate both scenarios.  I don't what to load the People Planning register twice and calculate it twice.

2 Replies

  • MarcusH's avatar
    MarcusH
    Valued Contributor

    The only thing I can think of is to use a Derivative Transformation Rule to duplicate the source data and then update the Scenario dimension member on the Derivative rule. Then update your actual Transformation Rules to post the duplicated lines to Forecast. You might have to change the Scenario definition on the Data Source to Text. I haven't tried it. I don't know if there is any restriction on loading to another Scenario as there is for Entities.

    • Brooks's avatar
      Brooks
      New Contributor III

      Thanks!  I will read up on this.  It sounds interesting and may very well do the trick.  And perhaps I'm going about this the wrong way.  What I'm trying to do is "extend" Actuals.  In other words, if we are in M3, I want to load M1 Actuals in M1, M2 Actuals in M2, M3 Actuals in M3 and M3 Actuals in M4-M12.  I would prefer to not do this in the Actuals cube as I'd like to keep it pure.  I can do it in a biViewer, but then I lose the FX functionality that is built into cube views.  As far as I can tell, my option are what you suggest, or giving up and manipulating my load to Actuals as mentioned above.