Filter SSRS report based on Cube Role

Hi to all,

AS I am new to BI world (AS, RS) I would like to know if this can be acheived. I have build a cube with roles that enables users to access only their data. Right now, this data can be viewed in a sample report in RS (full data display).

My question is is it possible to use a cube role to filter data in SSRS report ?, my plan is to have a user use his login name and password to access the main report already filtered properly, for now, there will be only 1 filter to be use per username, meaning , the user will have full data access for their division only. The role I have created in my cube work perfectly and I would like to know If I can use this role to filter data.

Is ther any sample, tutorial or good documentation on how to acheive this ? SSRS is completly new to me

Thanks

April 27th, 2015 3:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics