You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Integration Clear Region and Security

Received Response
21
Views
3
Comments
edited Sep 28, 2023 7:59PM in Planning 3 comments

Summary:

Clear Region in Data Integration seems not to reflect Dimension Member Security, Scenario Security (Start/End Period/Year) or other Security like Valid Intersection/ Cell Level Security when importing data into planning- are there plans to enhance this?

Content (required):

We set up Data Integration to let user perform file based loads for all Scenarios (Forecast, Budget) for multiple periods including Actual Data. Planning Security is active - also for Administrators - they cannot load to closed periods. (Even Valid Intersection and Cell level security is considered).

For cases of multiple reloads and data corrections, we used the Clear Region feature in Data Integration- which deletes the data before importing new data (in case the load with replace function is selected). The PoV is automatically identified by the seleted Time Period Range (Year, Periods) and Category/Entity. In addition we added more dimensions with function "derive from data" like Version, View - by this we control, which part is deleted. From the clear region definition, Data Integration creates a clear data scripts running against the Essbase bso cube shortly before the data load takes place.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!