SAP BPC 10.1 Optimized / BI-IP architecture - How to avoid locking?

[Former Member]

Hi,

I have seen a feature in BW-BPS which helps in getting rid of all lockings. (Since BPC users are used to the concept of last input wins / or last change is updated).

I tried to find the option like the one in BW-BPS called UPC_DARK2 which helps in disabling locks.

Do we have any similar settings for BI-IP or BPC Embedded / Optimized framework. I could not find one.

Can someone having any information on this? That will be of great help.

Best Regards

Rakesh

[gregor_dieckmann · Accepted solution]

Hi Rakesh,

you should be careful to switch off lock in BW-BPS or BW-IP: both solutions protect data to be changed (the pre-image) using locks; all changes are collected as delta records in the planning buffers, to save the data just means to store the delta records. To switch off the locks means that different users may work on the same data records, so the same pre-image might be changed and delta records are saved. This is not (!) a last one wins logic.

Example:

Pre-image is 100 EUR, user U1 changes to 200 EUR and user U2 changes to 300 EUR; in this case U1 would save a delta of 100 EUR, U2 would save a delta of 200 EUR, so the result after save is 100 EUR + 100 EUR + 200 EUR = 400 EUR.

To switch off lock only makes sense in a customizing phase but never in production; read note 928044 for more details, locks can be switched off in transaction RSPLSE.

The BPC Standard approach is also described in note 928044. So in BW-BPS, BW-IP, BPC Embedded if you open data in change mode you can be sure that the 100 EUR you see is really 100 EUR on DB, nobody else can change the data. In BPC Standard you cannot be sure that the 100 EUR you see are really 100 EUR (no locks), but you can be sure that if you save you changes to 200 EUR that after save 200 EUR is on DB (as long as no other user changes the data). BPC Standard only sets exclusive locks for the time interval needed to read the pre-image for the changed records, tcompute the delta records and to save the delta records.

Regards,

Gregor

[Former Member · Accepted solution]

Thanks for your perspective Gregor !! I understand the design of BW-IP or embedded BPC should always factor in the locking concept as part of design and this option to disable locks will be helpful in Dev / QA systems where we perform our development / testing / training. There is no escaping it 🙂