Drillthrough of analysis cube in Excel 2003 or 2007

Last Post 22 Aug 2008 03:44 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

21 Aug 2008 07:58 AM

Anybody has a solution for following problem: when we want to drillthrough a analysis 2005 cube in Excel 2003 or 2007 we receive this error:

Error in Excel 2003:
Cannot show detail data for this selection. If the source database has more detailed data that you want to view, click OK, click an item in the row or column field, and then click Show Detail on the PivotTable toolbar.

Error in Excel 2007:
The query did not run, or the database table could not be opened.
Check the database server or contact your database administrator. Make sure the external database is available and hasn't been moved or reorganized, then try the operation again.

We created a drillthrough action with all necessary measures and dimension, in the SQL Management browser it works fine but Excel doens't seem to work out.

We use the OLAP v9 connector to build pivot tables based on the Analysis 2005 cube.
New Member
New Member

22 Aug 2008 03:44 AM
Make sure you are up-to-date with all service packs.

Can you give us any clue? Anything unusual? Large dimension?

Turn on SQL Server Profiler trace for Analysis Services.

Send down your request again from Excel 2007 and check the captured MDX manually.

Let us know what happens.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/

Acceptable Use Policy