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 ...
Forum Discussion
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.
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.