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?
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 |
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?