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
Article Type
Technical Solution

Product(s)

Issue



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.


Error



No errors.


Environment



IT Analytics 7.1 SP2

Tested on SEP 11 and SEP 12


Cause



This seems to be a Microsoft limitation.


Solution



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].currentmember.properties('Member_Caption'), '<group name string') >0 )}



Article URL http://www.symantec.com/docs/TECH202595


Terms of use for this information are found in Legal Notices