Essbase Filters - what order do they apply when using multiple filters?
Hi,
Here is a simplified version of what we are trying to do. We have a user that belongs to 3 different groups. Each group has a filter with one line only and here are the filters for each group:
1. Read access to idesc of a member in the Cost Center dimension
2. Read access to idesc of a member in the Entity dimension
3. Read access to one member in the Scenario dimension
What we would expect is that the user would only be able to see their Cost Center (and desc), their Entity (and desc) for just the one scenario. But, what is happening is they can see all entities, all cost centers for the one scenario and they can also see their cost center for all entities, all scenarios. I know if I just create one filter and put all of this into one line, it will achieve what we are trying to do, but that is not practical for us and would multiply our filter maintenance to hundreds of filters.