We have created locking mechanism of BW IP through a Workbook by calling a planning function/planning sequence.
Problem we are facing is unless you a User locks the planning function/sequence in a TR in BW then only he is able to execute from Workbook otherwise it throws an error.
So if I want to execute that workbook then I will have to save the embedded planning function of Workbook into a TR in BW and then I can execute the Workbook to call planning function.
if I don't lock the planning function in a TR,it throws a class error.
Anyone has any solution to this problem.
what di you mean by TR? Transport request? or Transaction?
Both does not make sense.
If your data slice is type exit, you can create a function module for opening = de-activating the data slice.
And then run a function, that calls this function module and de-activates the data slice.
But I am not a programmer, so I can´t tell exactly what to do for this.
sorry, but becasue of strange english your question is hardly understandable.
What kind of error do you get? Do you get a locking error on the data?
Because a "locking of planning function" forme does not make any sense.
Locks (for data) on the lock server are created per planning application.
The query within a workbook creates a lock for the data it is reading when it is entry enabeled.
The function creates locks according to the data read - that depends on the filter you use for the function.
when you start the function from the workbook, the locks for the function and the query are treated within the same application, so that query and function can use the same data.
Hope this helps, otherwise please make it more clear, what kind of error you get.