Hi all,
I have been reading this on Technet (Roles (SSAS Tabular):
http://technet.microsoft.com/en-us/library/hh213165.aspx
I would love to implement a cube some day soon, but i have question.
This security sounds perfect but I wondered if i could implement it slightly differently - well actually twice.
Lets say you have sales people. They are able to only view there own sales - so that would be quite easy to implement.
Then you have product managers - who can only view the products that they manage being sold, but for all sales people.
So effectively two sets of dynamic security that cross over. Is this possible? How would you go about it?
Many thanks
Daniel