Environment: SharePoint 2010 on Windows 2008 R2 Standard + SQL Server 2008 R2, Dashboard Designer
I was successfully able to add a standard SQL Table as a data source and create a Scorecard Dashboard out of it. That works fine. My next attempt was to create a Pie Chart. For this, a multidimensional Analysis Services data source is required. I tried to setup a cube on the same SQL server from where I got the plain table. This is the article I followed: http://www.packtpub.com/article/creating-analysis-services-cube-visual-studio-2008-part2
Looks like the cube was setup fine! However, when trying to connect to this Analysis Services data source from the Dashboard Designer, the dropdown list for Database field is empty. Could it be because of the missing permission? But then it is the same user ... Do I need to do anything to "publish" the cube?
Any troubleshooting hints, either for the SQL Server or the SharePoint server ?