Hi,
We have two dimensions: User and Employee. Employees are recursive - each Employee can have several Employees that report to him/her and each Employee as a (or no) boss.
If a User has the right to access a specific employee he/she also has the rights to access his/her staff.
The following query returns all Employees a specific user has rights for.
select
filter([Employee].[Employee].members,[Measures].[UserEmployeeLink] > 0 ) on 0
from
[REPL]
where
([Measures].[UserEmployeeLink], StrToTuple("[User].[Login].&[XYZ]") )
How to modify this query that also all (directly and indirectly) subordinated employees of the queried employees are returned ?
There might exist cases, where a user has rights for employees at different levels, for instance for A and D.
+ B
|
A --| C
|
+ D
In this case, the query should return all, A, B, C and D.
Whishes,
Manfred
If I understand your question correctly, I think your looking for the DESCENDANTS function with the LEAVES parameter.
B.
