Hi,
I have created some dimension level security in my OLAP which restricts the sales channels which are displayed, however it also keeps the overall company position.
Can anyone advise me on how to remove the "All" tier from my dimension when the user is a member of this specific role, as we don't want certain people to be able to see the overall position
Thanks
Ian.
SSAS 2005 Dimension Level Security
ClydeCoulter
Hi Ian,
What you might be better off doing is ticking the Visual Totals box at the bottom of the advanced tab of the dimension security tab; this will ensure that the All Member only displays the aggregated values of the members on your Sales Channel attribute which you've allowed your users to see. Take a look at the following links for more details:
http://www.sqlserveranalysisservices.com/OLAPPapers/IntroductiontoDimensionSecurityinAnalysisServices2005.htm
http://msdn2.microsoft.com/en-us/library/ms175366.aspx
HTH,
Chris
zerovelocity
Thanks,
Exactly what I wanted.
Regards,
Ian.