Hi All,
My requirement is CEO can able to see all data(Managers and Sales person)
Managers can see sales persons information for particular zone(He can see only his zone only)
Sales person can see data in his information only
How to provide this type of visibility in SSAS ?
Can any one help me....
Thanks in advance..
Is the sales organization hierarchy only 3 levels?
CEO-->SalesManager-->SalesPerson
or is it a parent-child hierarchy?
Either way, this can be accomplished using dynamic row-level security.
BI Developer and lover of data (Blog | Twitter)
