on 03-31-2014 12:33 PM
Hi guys!
I am having two different workbooks, including two different queries.
One workbook and query is for planning data of current year and current year + 1
the other workbook and query is for planning data of current year + 2 and current year + 3.
I can open both workbooks simultaneously without any locking issue, because the lock is set over different years.
In ervery button of these workbooks, the first planning function is of type exit and reads a DSO... This planning function however creates a locking issue because its trying to set a lock for overlapping years...
e. g. in query 1 I am showing actuals data of 2014 and planning data of 2014, in query 2 I am showing actuals data of 2014 and planning data of 2015.
When starting the queries, lock is set as follows:
When running the planning function of type exit in query 2, system tries to lock 2014 and 2015 which creates a locking collision.
What I see is, that for some reason, the system is not able to set the lock according to my restricted key figures, it is only able to set the lock according to the selections in the global filter plus all values for the infoobjects in my restricted key figures.
Is there any OSS note which may solve this issue:
Thanks and regards
Marco
Hi marco,
I would run planning functions only in a sequence, where i have a filter available.
In the filter I would select the data in a way, that it does not lock.
Otherwise, depending on the function type you use, you can try to define the overlapping data as reference data, so that it will not be locked by the system.
regards
Cornelia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
try to explicitly bind the variables for the planning function, check the document below (page 13)
hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.