IT Analytics Permission issue with SEP cubes.
|Article:TECH202595|||||Created: 2013-02-07|||||Updated: 2013-02-08|||||Article URL http://www.symantec.com/docs/TECH202595|
After Groups are disabled in SQL and users are added in a custom security role to allow minimum access to ITA SEP reports, the user is still able to see all of the options in the SEP reports.
IT Analytics 7.1 SP2
Tested on SEP 11 and SEP 12
This seems to be a Microsoft limitation.
There is not much that can be done because this is a limitation of Microsoft. However, an alternative option is still be investigated.
However, a possible workaround could to use the Dimension Data Advanced page and a MDX filter to accomplish this. The MDX filter may look something like this:
Article URL http://www.symantec.com/docs/TECH202595