I'll try asking this again since I'm still not able to access my data cube.
I've developed a BI solution with SSIS, SSRS and SSAS. The account I've used for development has had Domain Administrator permissions and I've never had a problem running an SSRS report that reads the cube. When I use an account with less than
Domain Admin permissions and try to run a SSRS report that runs a query against a SSAS cube the query fails.
I've set up a Domain User group and given it read access to the data sources in Report Manager. I've given the group datareader role in ReportServer and ReportServerTempDB as well as the DataReader role in the SSAS cube.
Why can't I read any data from the cube???
View Complete Post