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!

Google Reader Wish List

Here are some features I'd like to see added to Google Reader:

1. Ability to easily read one group: Actually this was recently added. The GUI was changed a bit -- a 'subscriptions' drop down was added from which you can easily select just one group (prior to that you had to navigate through the GUI a bit; and even then it wasn't quite clear what group you were reading).

2. A count of new messages in a group, since I last read the group: I'd like to have someway of easily seeing (in the 'subscriptions' drop down panel, perferrably) a count of new messages (since I last viewed the group).

3. (Similar to 2) A count of starred messages in a group: This, too, preferrably in the 'subscriptions' drop down panel.

A Graphical History of Computer Languages

I love a good graphic! Here's a graphical history of computer languages: http://www.levenez.com/lang/history.html.

Civilization IV for the Mac

Civilization IV was released for the Mac about a month ago. It's having much the same birthing pains it had on the PC. I bought the Special Edition of Civilization IV for the PC shortly after it came out. The forums were filled with wailing and moaning and knashing of teeth. A month or so later a patch was released and the game even ran on my under spec Sony Vaio PCG GRX670 (a bit choppy, mind you, but I was willing to put up with quite a bit just to be able to play). I'm planing on buying my first Mac in the next six months or so. I'm waiting for the Merome to hit the laptop line. I'm hoping to get a MacBook (plain, not the Pro). And I'm hoping to run Civilization IV for the Mac on whatever I get. Yes, once again, I'll be trying to run the game on an under spec system. From what I've read, however, people who've played it on a MacBook have had similar experiences to those I had playing it on my Sony Viao, so I think I know what I'm getting into.

Article: Groupware Bad

A quote from Groupware Bad: "If you want to do something that's going to change the world, build software that people want to use instead of software that managers want to buy."