I have case like this: I have defined cube which has one dimension defined as person responsible for income/outcome.
I would like to give access to this cube to every person (who can generate income/outcome) to analyze facts but only those assigned to that person.
Standard role privileges does not allow to do that (when such user use time dimension will see totals for whole company instead of only his part). So - what I look for i something like this:
<Filter>[Responsible Person][All Persons][John Doe]</Filter>
and that filter applied to EVERY data query without possibility to override with jpivot interface...
Is there any way I can do that, or do I have to define it as separate cubes pointing to simple sql view with applied filter as facts table?