Skip to Content
avatar image
Former Member

Data Slice Error in Locking Workbook in BW IP

Hi,

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.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 16 at 11:48 AM

    Hi Aditya,

    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.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Cornelia,

      Thanks for the reply.

      We are calling a planning function from a AO WB ,the planning function modifies the data slice of the Info Provider. So when a user executes the planning function from WB and it tries to modify the data slice of the info provider,it throws an error.

      The error vanishes when for the same user, we a create a TR and lock the concerning Info Provider`s Data Slice into it. Similarly upon testing more we came to the conclusion that unless user locks data slice of the info provider into a TR,then only he is able to execute the planning function otherwise it doesn't work.

      We tried incorporating this planning function into a planning sequence and ran it in the back end thorugh rsplan tcode and it still asked for a TR before executing it.

      so the question is, is it standard behavior that if you want to modify a data slice,you have to lock it into a TR first?

      Thanks

  • Jan 16 at 03:21 PM

    Hi Aditya,

    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.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded