Solved

SQL Server 2000 Analysis Services / Excel 2003 hooked up to server cube - error message?

Posted on 2008-06-23
2
644 Views
Last Modified: 2013-11-16
SQL Server 2000 Analysis Services with Excel linked to a cube.  When trying to drill into a matrice - the error appears:

"Can not show detail data for that selection.  If the source database has more detailed data..."

But if I put some amount of the same data into Excel I am able to drill.  How do I drill into the server data?
0
Comment
Question by:michaelrobertfrench
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
Exl04 earned 500 total points
ID: 21876626
Post this in the Excel area  may have some answers. The guys in the Excel area are very knowledgeable about databases too.
0
 

Author Closing Comment

by:michaelrobertfrench
ID: 31469808
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question