Lock in BI-IP

[Former Member]

Hi,

I have an input ready query, which contains a planning filter.

There are two variables contained within the filter:

Product

Person ID

Users need to be able to run the report by either product or person.

If the report is being ran by product by all of the users, everything is fine and there are no locks, but if someone then runs by person id, it creates a lock of all the data.

Similarly if all users are running by person id, it is fine, until someone tries to run by product.

Person ID is an attribute of Product, so one person id could have many products attached to it, but one product will only have one person id.

What I wanted to check is why this approach does not seem to work?

Thanks

DJL

[Former Member]

Fixed by using a replacement path variable to populate the other attributes.

Thanks

Daniel

[Former Member]

Hi Matthais,

Thanks, thats what I thought the issue was.

Basically I am going to have to make sure that both variables are populated, as the users want the option to run by either product or person id.

I will create a user exit to read from the master data and populate the empty variable to avoid the locking scenario.

Thanks

DJL

[Former Member]

Hi Dan,

according to my understanding you have the following problem.

A user is starting the report for Product ID = A and Person ID = no restriction.

In this case the systems locks the following combination:

Product ID = A and ALL Person IDs.

If another user now starts the report for Product ID = no restriction and Person ID = 1

the systems tries to lock the following selection:

Person ID = 1 and ALL product ID.

In your case you are now running in a lock situation, because the two selections overlap

for Person ID = 1 and Product ID = A.

For more information please refer to [http://help.sap.com/saphelp_nw70/helpdata/en/44/588168ce8c08fae10000000a422035/frameset.htm]

BTW do you know the expert mode of transaction RSPLSE? Check note 928044

Hope this helps.

Regards Matthias Nutt

SAP Consulting Switzerland