IT Analytics Permission issue with SEP cubes.

Article:TECH202595  |  Created: 2013-02-07  |  Updated: 2013-02-08  |  Article URL
Article Type
Technical Solution



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.


No errors.


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:

{Filter( [EP Group].[Group].[Group].AllMembers, instr( [EP Group].[Group]'Member_Caption'), '<group name string') >0 )}

Article URL

Terms of use for this information are found in Legal Notices