Lock in BI-IP
I have an input ready query, which contains a planning filter.
There are two variables contained within the filter:
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?