"User Filter Value" provides the ability to pass a value to a report filter based on a user or a role. "User Filter Value" can be setup in three steps:
To define User Filter Value go to: Admin > "User Filter Value"
To set a value for user or role for the User Filter Value go to: Admin > User > User Filter Value tab or Admin > Role > User Filter Value tab.
It is possible to have User Filter Value vary based on application or Windows user info. Following security tokens can be used:
To set the report to use the User Filter Value, in the report design mode go to: Options > Dimensions tab.
Alternatively, this can be done via the Subscriptions dialog:
OLAP based reports have an option called: "Apply to all reports and hide filter". This option provides Application field level security and is an alternative to using SSAS Windows security. Applying this option will affect all reports that are using the defined cube. When this option is used the third step (Set the report to use the User Filter Value) can be omitted.
