Hi All,

I am running a simple DrillThrough MDX on FoodMart 2000 on Sales cube,
the MDX is :

DRILLTHROUGH MAXROWS 1000
SELECT {[Customers].[All Customers].[USA].[CA].[Berkeley]} ON 0,
{[Time].[1997]} ON 1,
{[Product].[All Products].[Drink]} ON 2
FROM Sales


But it shows the following error:

----------------
Unable to open cellset
The connection cannot be used to perform this operation. It is
either closed or invalid in this context.
-----------------

This query seems to work in Reporting Services Designer - what MDX
client tool are you using?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

MDX Sample Application

You have to use some other app for doing DrillThrough. Most of the
3rd-party MS OLAP client apps support it; or you can use SQL Server
Reporting Services (though MSRS 2000 drillthrough only seems to work for
single-partition cubes). The Office Excel add-in should work as well:

http://www.microsoft.com/office/solu...eladdin/defaul
t.mspx


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***