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)

Show all

Languages

Show all

Problem

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 )}