SSAS 2008/Excel 2007 - Can't see cube

Posted by Brian on Stack Overflow See other posts from Stack Overflow or by Brian
Published on 2010-04-01T12:28:41Z Indexed on 2010/04/01 12:33 UTC
Read the original article Hit count: 354

Filed under:

analysis

|

Services

|

ssas

|

2008

|

excel

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?

Thanks for any help you can give me.

-Brian

© Stack Overflow or respective owner

Related posts about analysis

Visual Studio 2013 Static Code Analysis in depth: What? When and How?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this post I'll illustrate in details the following points What is static code analysis? When to use? Supported platforms Supported Visual Studio versions How to use Run Code Analysis Manually Run Code Analysis Automatically Run Code Analysis while check-in source… >>> More
Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

as seen on SQL Server Performance - Search for 'SQL Server Performance'
SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using WMI Data Reader and WMI Event Watcher ... [Read Full Article] >>> More
Should static analysis warnings fail the CI build?

as seen on Stack Overflow - Search for 'Stack Overflow'
Our team is investigating various options for static analysis in our project, and have mixed opinions about whether we want our Continuous Integration build to fail because of warnings from static analysis. The argument against failing the build is that there are often exceptions to the rules, and… >>> More
Introduction to Security in Analysis Services

as seen on Internet.com - Search for 'Internet.com'
Join BI Architect Bill Pearson in this introduction to Security in Analysis Services 2008. Here we explore security concepts and implementation, and look forward to hands-on practice with security in other articles of this subseries. >>> More
Using the Static Code Analysis feature of Visual Studio (Premium/Ultimate) to find memory leakage problems

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Memory for managed code is handled by the garbage collector, but if you use any kind of unmanaged code, like native resources of any kind, open files, streams and window handles, your application may leak memory if these are not properly handled. To handle such resources the classes that own these… >>> More

Related posts about Services

Azure Mobile Services: what files does it consist of?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Azure Mobile Services is a platform that provides a small set of functionality consisting of authentication, custom data tables, custom API’s, scheduling scripts and push notifications to be used as the back-end of a mobile application or if you want, any application or web site. As described in my… >>> More
Testing your Web services using the Data Web Services Test Client

as seen on Internet.com - Search for 'Internet.com'
Paul Zikopoulos introduces you to the Data Web Services Test Client that's available in IBM Data Studio Version 1.2 or later >>> More
Silverlight 4 + RIA Services - Ready for Business: Exposing OData Services

as seen on Dot net Slackers - Search for 'Dot net Slackers'
OData is an emerging set of extensions for the ATOM protocol that makes it easier to share data over the web. To show off OData in RIA Services, lets continue our series. We think it is very interesting to expose OData from a DomainService to facilitate data sharing… >>> More
Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

as seen on SQL Server Performance - Search for 'SQL Server Performance'
SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using WMI Data Reader and WMI Event Watcher ... [Read Full Article] >>> More
Navigating the Unpredictable Swinging of the Financial Regulation Pendulum

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Written by Guest Blogger: Maureen Clifford, Sr Product Marketing Manager, Oracle The pendulum of the regulatory clock is constantly in motion, albeit often not in any particular rhythm. Nevertheless, given what many insurers have been through economically, any movement can send shock… >>> More