Integrated Planning – locking records by navigation attributes
IP (Integrated Planning) allows users to enter new data or update existing data in real-time cubes. This fact requires IP to manage locking mechanism for avoiding simultaneous update of the same characteristics combination.
There is a locking mechanism in IP (tc RSPLSE) that allows developer to customize which characteristics will be relevant for locking.
By default RSPLSE does not allow NAVIGATION ATTRIBUTE to be relevant for locking.
This blog describes how to customize locking mechanism in IP for setting navigation attributes as relevant for locking.
Let us consider a scenario where we have a simple real-time cube with one characteristic ZGC_PORT (this characteristic has one navigation attribute ZGC_PORT__ZGC_AREA). We created simple aggregation level, filter with restriction of characteristic and his navigation attribute by any variables, input-ready query and WAD for entering and updating data.
Let’s assume that users want to restrict data only by ZGC_AREA (navigation attribute of this characteristic).
After we have restricted data by navigation attribute in selection screen and executed the query, we will see strange thing – although we restricted data only for ONE value of navigation attribute, ALL DATA IS LOCKED.
The following print screen shows locking parameters after query execution (note that we restricted query by navigation attribute, but it is not being realized in locking mechanism).
This caused by missing customization in RSPLSE.
If you follow the tab “Lock Characteristics”, enter info provider technical name and press enter, you will be surprised that navigation attributes are not shown in “Selection of Lock Characteristics”, opposite to characteristics themselves.
To turn on locking by navigation attributes (and also some of nice features) type EXPERT in transaction code command line and press enter.
Then navigate to another tab (lets say to tab “Lock Table”) and back to the tab “Lock Characteristics”. It should refresh the screen ad get in expert mode.
Now you can see in the left side all navigation attributes in the selected info provider.
Press CTRL+F1, select needed navigation attribute, add it with arrow to “Lock Characteristics” section and press save button (CTRL+S).
Now execute the query and ensure that there is locking by added navigation attributes.