none
Cube not showing up in Metadata Browser

    Question

  • I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios:

    • Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube.
    • Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down.
    • Proclarity 6.1: same problem: cube shows as not processed or unavailable and I can't connect to it.

    The cube works great with the Excel Cube Analysis Add-in, so I'm suspecting it is one of the new features of AS 2005 that is causing the problem. I am using Many-to-Many dimension relationships in the cube, and mutiple measure groups. Other than that, the cube is pretty straight-forward.

    Any ideas on what would make this happen?  I've tried deleting the cube from the server and completely redeploying the project, changing the cube name to not have a space in the name and a few other simple things. 

    Regards,

    Clayton

     

    Wednesday, February 15, 2006 12:27 AM

Answers

  • This has to fall into the "bonehead" category.

    The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".

     

    Thursday, February 23, 2006 4:35 PM

All replies

  • This has to fall into the "bonehead" category.

    The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".

     

    Thursday, February 23, 2006 4:35 PM
  • I don't know about "bonehead."  I spent 4 hours with this exact same problem.  Not until I found this post did I think to view the cubes XML and change <visible>false</visble> to <visible>true</visible>.  I mean, is there even a way to change this property though the designer?  I just about went crazy.  Thanks.
    Wednesday, October 11, 2006 7:50 PM
  • hello,

    yes, if you open your project in BIDS, and open cube designer, look in the properties panel - it should show the cube and one of the properties listed in there is Visible (in the Advanced category).

    hope this helps,

    Wednesday, October 11, 2006 8:25 PM
  • I did the same thing.  I think what we all have accidentally done was select a dimension that we wanted to hide then went to the properties window to set the Visible property.  What I just noticed is that if you click on on one of the dimensions while on the Cube Structure tab the properties window does not change to the dimension and the Visible property on the cube gets set to false accidentally.  At least that how I ended up doing it.  I hope this helps someone else realize how it happened to them.
    Thursday, February 01, 2007 5:29 PM
  • If I could click the Yes button on "Was This Response Helpful" I would!

    Thank god for the internet when it comes to things like this!  Thankfully I only spent about 15 minutes looking into permissions before I thought to just copy/paste the exact error message into the search engine.

    Cheers for admitting your boneheaded mistake so that other boneheads might learn from your self-correction!
    Friday, September 28, 2007 7:55 PM
  • Damned... I spent 1 hour to find why my cube was unavailable before founding this post... thanks anyway!

     

    Friday, December 14, 2007 3:44 PM
  • This is a serious waste of time.

    The metadata browser is not showing up, even it the cube is set in the advanced properties to visible=true.

    This concept works only if you are working online with an instance of AS2005. It does not work in a projekt that you are working on with BIDS.

    Thanks for bringing this up.

    Monday, January 14, 2008 9:20 PM
  • Thanks! Your post just saved me a lot of frustration.

    Monday, February 15, 2010 8:40 PM
  • I dont think this is a freak mistake...i suspect this happens when you open up you cube in OnlineMode and do some operation with 2008..  

    Thursday, March 18, 2010 7:30 PM
  • Does any one has the solution for these  yet ??????  I am really frustrated  by this issue . I can browse the cube but I am unable to   write MDX  queries .  

     

     Any help    is greatly appreciated.

    Monday, January 10, 2011 4:32 AM
  • Hi

    I had the same problem today,after several years when u originally faced this.:)

    however i got the visibility of the cube properties set to true, but this error still comes up  "Error loading Metadata: No cubes were found." so i went to build and deploy(changes only) again and it now shows up fine..

    thanks

    Saturday, November 09, 2013 9:18 AM
  • Yep - built and re-deployed an infinitum (as it was not a visibility issue with me). Also refreshed a million times before I was finally able to see the cube in its entirety!
    Tuesday, April 01, 2014 3:34 PM