SSAS 2008/Excel 2007 - Can't see cube

Question

I have created a cube in SSAS 2008. In BIDS and SSMS I can see it fine. However, I cannot connect through Excel. I have tried both Excel 2003 and Excel 2007. I must support both and neither work. I can see the database but the cubes do not show up.

I created a dummy cube in the project using the wizard and deployed that to the same database. In Excel 2003, I can see and connect to the dummy cube. Excel 2007 can't even find the server/instance after adding this cube. I have used another computer and received the same results with Excel 2003.

Does anyone have any suggestions?

Answer 1

The cube has a property Visible. If it's false, Excel won't list the cube.

To see this property

A) double click on the cube in BI studio's Solution Explorer

B) go to the cube tab

C) right click on either the cube which appears in the Measures pane OR the one in the Dimension pane and choose Properties.