ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Role-level user filter value

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

[quote][i]Originally posted by dbooth[/i]
[br]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
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
dbooth	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
3 L A T E S T R E P L I E S (Newest First)
admin	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.
dbooth	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	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.

ReportPortal