I've deployed my cube through BIDS 2008 to the test server with a user role (Read only) successfully. I can browse the cube through BIDS as well as through SSMS. However, when I try to access the cube through Excel 2010 - I'm not even able to see it. [Under
the data tab, use other connection - SSAS connection - Server Name - Database name but no cube]. I've read most of the forums here related to this issue but not able to find a solution.
View Complete Post