01-16-2023 06:37 AM
Hi all
Does someone know if there is a script / rule which we could use to Copy data from one scenario to the Historical scenario at aprent level?
At the moment we only see the option to copy Input data but not the option to copy all level data.
The problem is if we only copy the Input data and the hierarchy changes, then the data consolidated to the parent will change and we do not want this for a historical scenario.
Any suggestions?
Thanks
Nouria
01-18-2023 09:11 AM
Extra note: We also do not want to run the consolidation on historical data, so we want to copy data from all level to avoid that step. Is this possible at all?
Thank you
Nouria
03-12-2023 08:28 PM
Hi Nou, I've used a DM Step linked to a business rule to do this. I consider it "Cold Storage." it copies every consolidation dimension member for every entity, base and parent. It is a replica of every entity in the hierarchy and does not require consolidation, in fact it was designed to avoid consolidation. The historical scenario is not in workflow, does not allow calc from grids, and DM access was returned to the nobody group to protect its data.
Hope you've already solved but if not I can help.
Steve
03-16-2023 04:52 AM
Hi Steesdale
Thank you for your information, which we will review and get back to you if we need further details
Nou