| Author |
 Topic  |
|
|
dbooth
United Kingdom
69 Posts |
 Posted - 05/14/2014 : 02:09:54
|
If a user filter value is set at Role level and a User is a member of that Role, and has no User-level user filter value set, the Role level filter restriction doesn't apply.
Example on Demo server : User 'FM2000-CA' has View access to role 'FM2000-CA' which has a User Filter Value for the 'FM2000-Store' filter of [Store].[All Stores].[USA].[CA], and the User Filter is set to 'Apply to all reports and hide filter'. User 'FM2000-CA' does not have a User Filter Value set at User level.
Report 'test CA role filter' in the My Reports folder for user 'FM2000-CA', when expanded down to region level, shows not just CA but also OR and WA. So the role-level filter is not applied.
The workaround is to ensure user filter values are defined at user level; but it would be immensely useful to define them at Role level, and assign users to roles.
As an aside, when this feature is functional, would it inherit user filter values from multiple roles in the same Cube and Dimension? So to use the above scenario, a user who had view access to the FM2000-OR and FM2000-WA roles, would be able to see data for those Stores, but not the CA store.
Regards
Dave Booth |
Edited by - dbooth on 05/14/2014 02:12:34 |
|
|
admin
1635 Posts |
Posted - 05/14/2014 : 03:09:53
|
| On the demo server, Hidden User Filter Value “FM2000-Store”’s cube is set to [Warehouse]. Report “test CA role filter” points to [Sales] cube. |
 |
|
|
dbooth
United Kingdom
69 Posts |
Posted - 05/14/2014 : 03:37:29
|
Thanks for the info, explains it.
Do multiple roles inherit for a given Cube & Dimension? See 'FM2000-CA and OR' user, which is in two roles that share the same Dimension but the filter value differs for each role. |
|
|
|
admin
1635 Posts |
Posted - 05/14/2014 : 03:57:50
|
No, if the User filter value is applied on both roles only the User filter value with the highest importance will be used.
http://www.reportportal.com/help/admin/filterDef.htm
A future build should provide an application option to use multiple roles instead of using the one with the highest importance. |
|
|
| |
Topic |
|
|
|
Report Portal
Role-level user filter value
