Dear experts 😉
We are having problems creating locks in IP. We would like planners not to lock each other if they are planning in different Company Codes but we are not able to create this type of lock.
We put Company Code in the Lock Characteristic Tab Page in the Lock Characteristics column for the real time infocube and the aggregation levels for which we have workbooks saved and want users not to lock each other.
Once we execute a workbook, for one company code, that has been saved from a query under an aggregation level it locks everything. If we try to execute another workbook (from a different or same aggregation level) for a different Company Code it doesn't let us plan over the second one. The first one locks everything.
When this happens we have a look in the Lock and Lock Conflict Tab pages and we don't see what we expected, but we see:
As Characteristic "__EMPTY_SELECTION__"
Internal Char Value: NO RESTRICTION
We have Shared Object Memory of Server with Lock Type Enqueue and SP11
Could anybody help us in this. We are quite stuck on this......
Thanks in advance for any help!!!!