Search code examples
drop-down-menussrs-2008ssas

Empty drop down lists in ssrs report

Ok, I am a bit stumped here. I am using an ssas cube as a data source for numerous reports. The reports all have a start and end week or month parameter. When I run the reports as me, they run fine. However, when I log in as another user on the system, the drop down lists are empty. So, I can't run the reports because there is nothing to choose from in the week or month drop down list. Note that I have tried with embedded and shared datasets. Is that a dataset security setting that I am missing? This is very odd.

Thanks!

Solution

  • Have you defined any security on your cube?

    Also, check the impersonation information of the data source defined in your analysis services project.

    http://msdn.microsoft.com/en-us/library/ms187597.aspx