SSAS Error: Error loading Metadata: No cubes were found

  • Article

Applies to:  SQL Server Analysis Services (all supported versions)

This error can occur if you deliberately or accidentally set a cube's Visible property to False.  When developing a cube, you might have occasion to hide a dimension. If the dimension is not selected, you can inadvertently hide the cube instead.

Use SQL Server Data Tools, or Business Intelligence Development Studio (BIDS), depending on which version of SQL Server you are using, to check the property.  Double-click the cube to open it in cube designer. The Dimensions pane will be on the bottom left corner. Right-click the cube in the Dimensions pane, click Properties, and find the Visible property in the list. It should be set to True for the cube object.

To view the original post, see http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0d404944-ea14-4e1f-89d6-069900eb9b92/cube-not-showing-up-in-metadata-browser