Today I had a problem that I have already came across some time ago. In Visual Studio 2008 (BIDS) I created a SQL Server Reporting Services (SSRS 2008 R2) report and connected this report to an Analysis Services Olap Cube (SSAS 2008 R2). Then I created a new dataset and when I started the Query Designer, the following error message appears: "No cubes can be found".
After looking at the cube properties, I noticed that the "Visible" property of the cube was set to "False". This property should be set to "True" to enable connectivity in client applications.
Hopefully I can help someone with this!
i had the same problem! and yes, THAT WAS THE SOLUTION1
ReplyDeleteDietmar Hoffmann, hoffmadi@hotmail.com