11-30-2021 10:19 AM
One of the new features in the 6.6 release is the introduction of Hybrid Source Scenarios. I've watched the 6.6 release and read through the abbreviated examples in the admin guide. Both have good high level content, but they seem to be missing details around the Options section within the Hybrid Source Data of Scenario properties.
Does anyone have any additional details around what options are available and a description of each? Or more content around Hybrid Source scenarios in general?
Thanks,
Added screenshot to provide context.
Solved! Go to Solution.
12-01-2021 08:49 AM
Hello - I am going to ask that more documentation around the Options are added to the documentation. Below is more detail on the Options:
12-01-2021 08:49 AM
Hello - I am going to ask that more documentation around the Options are added to the documentation. Below is more detail on the Options:
02-28-2022 01:26 PM
Hey Eric - thanks for the above, and additional questions:
I was experimenting with Hybrid Copies, and I'd like to only pull over some data from upper level Entities from some Actual months into a Forecast.
In regard to the Entity dimension, it only seemed to pull over data when I had Base Entities as part of my calculation filter. When I tried to pull upper levels alone it would not bring over the data (this is certainly consistent with the setting name of 'Copy Input Data...').
Also I tried to limit the T# Time Periods with a Member Filter (only some for a Year) and it seemed like this was ignored.
Thank you!
02-28-2022 01:30 PM
That is correct - the member filters on Hybrid Source data are only Account-level dimensions. Data Unit dimensions are invalid. DU dimensions would be supplied when a calc/trans/cons is ran.
02-28-2022 01:31 PM
(thank you very much Eric!)
05-05-2022 03:00 PM
Hi Eric, thanks for the additional information. Very helpful!
Do you know if it's possible to copy the last month's data from the source scenario into future years of a target scenario? Our source scenario is monthly and forecast through 2024. The target scenario is for long range planning and we want to have the data from 2024M12 populate the target scenario from 2025M1 - 2032M12.
05-05-2022 03:04 PM
That cannot be done with Hybrid Scenarios. There is no Time (or any Data Unit) filtering/conditional logic unless you did "Using Business Rule" as the Data Binding Type. But I would argue you should just write a Custom Calc BR at that point. One of the main benefits of Hybrid is the performance and that is mainly achieved by copying all periods in a year simultaneous (and why there is no time element at this moment).
03-23-2023 05:24 PM
Does the Copy Input Data from Source Scenario option copy all data cell storage types or just input?
03-23-2023 06:00 PM
It will copy all storage types.
06-14-2023 02:54 PM
Hi Eric, when you say that it will copy all storage types, you mean that it will copy them all but when it pastes or writes to the target scenario as calculation or durable calculation right? There is not a way to have it copy the input data as input data, the calculated data as calculated and the durable calculated data as durable calculated to the target scenario right?
Thx,
Mike
06-14-2023 03:14 PM
That's correct Mike.
06-14-2023 04:11 PM
Thx Eric. One more question while I have your ear. If I want to do a very simple 'Pointer' scenario like 'Current Forecast' that just points at a regular Forecast scenario like FC3+9, can I just use the 'Share Data From Source Scenario' binding type and then provide the Source Scenario Name (FC3+9) and just leave all of the other settings blank? It looks like it worked for me on base and parent entities. Am I missing anything or is this valid use case? This is very handy and saves having to write some logic. Feels very Essbase-y (that's a compliment in this case).
Mike
06-15-2023 07:38 AM
That is a valid use case and would work great.
Another use case is to share the data to a new scenario where you can filter out dimensionality not required for certain reporting so you can reduce the data unit and improve reporting performance.
06-15-2023 08:38 AM
ok got it thx so much. much appreciated