MicroStrategy ONE

Limiting Which Attribute Elements a User can See

You can limit the attribute elements that a user can see to only the elements allowed by their security filter. For example, if a user's security filter allows them to see only the Northeast Region and they run a report that prompts for cities, only those cities in the Northeast are displayed.

This functionality can be enabled for a project and limits the element cache sharing to only those users with the same security filter. This can also be set for attributes. That is, if you do not limit attribute elements with security filters for a project, you can enable it for certain attributes. For example, if you have Item information in the data warehouse available to external suppliers, you could limit the attributes in the Product hierarchy with a security filter. This is done by editing each attribute. This way, suppliers can see their products, but not other suppliers' products. Element caches not related to the Product hierarchy, such as Time and Geography, are still shared among users.

For more information on security filters, see Restricting Access to Data: Security Filters.

To Limit Which Attribute Elements Users can See Per Project

  1. In Developer, log into a project. You must log in with a user account that has administrative privileges.
  2. From the Administration menu, point to Projects, and then select Project Configuration.
  3. Expand Project definition, then select Advanced.
  4. Select the Apply security filters to element browsing check box.

To Limit Which Attribute Elements Users can See Per Attribute

  1. Edit the attribute, and click the Display tab.
  2. Select the Apply security filters to element browsing check box.

You must update the schema before changes to this setting take affect (from the Schema menu, select Update Schema).