05-12-2022 10:02 AM - last edited on 05-02-2023 10:24 AM by JackLacava
We would like the ability to auto consolidate 2 other constant ex rate scenarios once we have consolidated the main Actual scenario. We want to retain the ability to consolidate the main Actual scenario in isolation also i.e. we don't want to consol all 3 scenarios every time. What would be the best way to do this?
05-12-2022 03:48 PM
Hello!
You could set up a data management job to consolidate whatever intersections you want then attach that to a task scheduler job set to run whenever you specify.
Here's a screenshot sample of the data management step:
Which would then be added to a data management sequence which is what's pulled by the task scheduler. Hopefully that makes sense.
-Nicole
05-13-2022 08:08 AM
Thank you Nicole, very helpful.
Is there a way to initiate this DM seq from the main Actual WF using Calc Definitions? i.e. to run the consol on the constant fx scenarios from the Actual scenario WFP?
05-13-2022 11:18 AM
Hi,
Off of the top of my head, you could probably change the WF channel to include a dashboard step where you could add a customized button to trigger the DM step (which could have substitution variables referencing the WF settings). Someone else might be able to come up with something more elegant.
05-16-2022 05:43 AM
Thanks Nicole! I'll look into that solution.
06-14-2022 04:58 PM
What we do often, is use the nocalculate option. If you then in the data quality event handler put in a rule for
BREventOperationType.DataQuality.ProcessCube.NoCalculate
you can define what to do in this case. So for example, you could choose to execute a DM sequence with
BRApi.Utilities.ExecuteDataMgmtSequence(si, calcInfo.FilterValue, dmParams)