Data Integration Clear Region and Security
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?
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.