Solved

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

Posted on 2008-06-23
2
645 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

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...
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

635 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