01-14-2022 12:57 PM - last edited a week ago by JackLacava
How do you handle preventing users from accidentally loading data via an excel XFSetCell or QV submission to O#Forms/O#BeforeAdj on a scenario that’s locked on the workflow in OS? I’ve submitted this via OS support and there’s an enhancement request for “Requesting option to prevent users from submitting data in Excel via XFsetcell or QuickView” but there’s no workaround that they can provide.
Our FP&A users load all data via excel and they’re generally educated enough to know what dimensions to change, but sometimes the communication doesn’t go out timely enough from corporate FP&A to stop loading adjustments (though the scenario is locked promptly on the workflow) and so we run into this issue. Any thoughts or feedback would be welcomed!
01-14-2022 12:57 PM
If possible, I would change the Read and Write Data Group on the scenario as the first option to Administrators or a group which the FP&A does not have access to and provide access to the FP&A team with the Read Data Group which I assume is not an option. If my assumption is correct, Data Cell Access Security can be applied to the Scenario.
01-14-2022 12:57 PM
My users are not able to use a FXSet when the WF is locked or Certified. We assign Entities to each workflow and once locked or Certified, no changes can be made to those Entities. Just double checked with my Admin user and not able to FXSet to Forms.
01-14-2022 12:58 PM
Thanks for the suggestions!
Unfortunately the way our security structure is nested, updating security would be possible but would require testing to unravel first and of course, approval every time it’s changed.
After OS support’s initial reply, I did more testing in dev on my side and found that 2 out of 3 workflows get errors when the workflow is locked but one loads fine. It’s the oddest thing.
01-15-2022 03:29 AM
Hi Nicole, There is a way via channels however for this option, we need to know the WF design, if you have a separate CubeRoot WFP for forecasting or planning this can be easily implemented, however if same CubeRoot WFP if being used then this may or may not be easy..., if you want to discuss on this, pls suggest
01-15-2022 04:01 AM
Steps would be as follows,
1) Create a new workflow channel e.g, 'Forecast_Forms'
2) In the Workflow profiles where entities (for forecast loads) are assigned, deactivate other forms for Forecast scenario and create a new form which should have channel assigned as new one 'Forecast_Forms' (cleaner way - however you can use an active Form as well )
3) With this setup as soon as these forms, with new channel, in Forecast / Entity WFPs are locked - none of the users can load data by Quick view Grid or setvalue for those entities (assigned on the WFP)
Hope this helps (may be you can test this for one wfp first )