Demystifying SSAS Date Dimension Attribute Types

This spreadsheet (via Google Docs) is my attempt at organizing the SSAS date/time attributes. Note that the spreadsheet has four tabs. FEEDBACK AND SUGGESTIONS FOR IMPROVEMENT WELCOME. [Direct link: http://spreadsheets.google.com/pub?key=pIsKma8AZfzY_KETerdpcAA&gid=2]

No cube or table listed under the selected database in the Excel Data Connection Wizard

Problem: No cube or table listed under the selected database in the Excel Data Connection Wizard.

Solution: In Microsoft Visual Studio set the cube's "Visible" property to "True"; republish the cube

Recently I was trying to connect from a brand new Excel document to a cube I had created in Analysis Services.

Where the problem is: In Excel 2007...

• Select the "Data" ribbon
• Select "From Other Sources"
• Select "From Analysis Services"
• The "Data Connection Wizard" opens up
• On the "Connect to Database Server" pane enter your server name
• Click "Next"
• The "Select a Database and Table" pane displays
• Select your database from the "Select the database that contains the data you want"
• "Connect to a specific cube or table" should be checked
• No cube or table shows up

The solution:

• Open your Analysis Services cube project in Microsoft Visual Studio
• In the "Solution Explorer" double click on your cube ("MyCube" for example)
• The "MyCube.cube" tab opens up
• In the "Measures" pane (or "Dimensions" pane, or...) right click on your cube (the root node) and select "Properties"
• On the "Properties" pane set "Visible=True"
• Republish the cube

Good luck!