Workbook for users to lock data (version and year)

[James_BW]

Hello everyone,

I'm in the process of implementing/creating a workbook to enable users to lock data based on the version and year. I've based my test implementation on this post although we're on SAP BW on HANA with standard BPC. I don't quite achieve the same results. I'm also unsure whether this is the correct approach or not. The idéa is to use a workbook to manage this process.

My implementation so far is to create a new aDSO to store the information with the relevant InfoObjects:

- ZLOCK (key-figure to put in 1 or 0 for lock/unlock)
- ZPYEAR (to choose the year)
- 0VERSION (to choose the version)

An aggregation level is then created on top of the new aDSO, where a query is the created on top of the aggregation level. I've also created a filter, two planning functions and two sequences for locking and unlocking.

Planning function 0 = unlock 1 = lock:

I've created a new class (based on CL_*_DS_EXIT) and changed the IS_PROCTECTED:

I then activate the dataslice in the relevant aDSO.

The idéa is that the user opens a workbook and chooses the year in the prompt. It will then show all the versions for that year and a button will be created to run a lock and unlock planning sequence.

E.g. For the year 2024, the version P1 should be locked. The user would then click on the "Lock" button, where it will put a "1" in the highlighted cell.

My problem right now is that the planning function executes with no error, but I can save to the aDSO, but the query returns an error.

1. Is there a guide somewhere which goes into details on how to proceed or implement such a workbook?
2. Am I missing something more in the code?
3. The workbook should be able to handle multiple locks, so let's say the user wants to lock version P1, P3 and P4 for 2020, but I'm unsure on how to do this? I'm assuming I need to created the cell ranges with those information, but I can't seem to find out where to find information.

Any help is greatly appreciated or direction to a similar posts. I've searched the web, but unable to find something which is as "simple" as the one I linked above, althought I still can't succesfully implement it

[James_BW · Accepted solution]

I got around to it for the simple version.

Also, wy is it not possible to delete your own posts, seems weird.