I have a question: I have two reports in ssrs report server sourcing a SSAS cube which is on a same server. Now i want the ssrs manager portal to connect by some user over the internet and i want to have roles in cube to that public user in the cube.
The public user will not be the part of the domain user where the SQL Server instance is installed. The user is some external user. I am ol with building a custom asp.net portal for this also but the roles in the cube must be applied to public user. So when
public user connect to portal and executes a SSRS report he should see the data for which he will be reposible. We can maintaina mapping table if required for the public users.
Please let me know how to move forward on this
View Complete Post