Forum Discussion

Beeswing77's avatar
Beeswing77
New Contributor III
10 months ago

How to prevent Consolidations in specific year and scenario

Hi,

I want to block Consolidations in prior year Forecasts and Budgets, as these should always be static.  I've already locked all Workflows,  but I'm still worried that Admins can run consolidations from Cube Views, etc.

I've tried using Data Access in the Cube,  but none of that seems to actually do anything.  For example, I tried adding a Data Cell Conditional Input rule that makes the prior year and Forecast scenario Read Only,  but this doesn't prevent Consolidations from running.

Any ideas?

Consolidation
  • Krishna's avatar
    Krishna
    Valued Contributor
    10 months ago

    Beeswing77  -  My 2 Cents As far I know you can control it but not prevent.

    1. You can restrict the consolidation running from CV. In the Scenario settings but it cannot be set it by year. 

    2. Try the DM Event Handler if there is an option to control the consolidation because you can execute the consolidation through DM.