Prompts and Security Filters

Security filters in MicroStrategy restrict a user’s ability to access or view certain objects within a given MicroStrategy project. As a result, a security filter can limit the data a user sees on a report, even if the report is designed to display a broader set of data. For example, a report shows revenue data for all geographical regions of the U.S., but a set of users may have a security filter assigned to their MicroStrategy user accounts that limits the display of data to only the Northeast region.

For prompts, this means that users who have a security filter assigned to them may only see certain prompt answers to choose from when they execute a prompted report, even when the prompt creator has explicitly defined a broader set of prompt answers to be available to users of that report.

When describing what prompt answers will be available to users, this manual assumes that no security filter restricts an individual user’s access to certain objects or object elements. However, most environments use security filters, so it is important to be aware of the potential impact of a security filter on a user’s experience when answering a prompt. Consider this possibility when designing a specific prompt for your users’ reporting needs.