Hi,
I would like some help with the following problem:

Imagine the following "cube", consisting of two dimensions and a
measure (counting the number of people).

Europe Asia
Male 50 56
Female 2 50

What I want to do is to drillthrough the cells of (Male-Europe) and
(Female-Asia). So to get back 100 rows.

If I write something
DRILLTHROUGH
SELECT
{[Continent].[Hierarchy].&[Europe],
[Certification Type].[Hierarchy].&[Asia]} on 0,
{[Gender].[Hierarchy].&[Male],[Gender].[Hierarchy].&[Female]} on 1
FROM [O24MKTDB CubeCustomer]
where [Measures].[Customer Count]

then I get back 50+50+56+2 rows.. How can I specify the two cells?
Should I execute two different drillthroughs?


Thanks

A single drillthrough statement should specify a single cell in the
cube, so 1 statement is needed per cell:

http://msdn2.microsoft.com/en-us/library/ms145964.aspx
Updated: 17 July 2006

Retrieves the underlying table rows that were used to create a specified
cell in a cube.
...
Remarks

Drillthrough is an operation in which an end user selects a single cell
from a cube and retrieves a result set from the source data for that
cell in order to get more detailed information.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Hi Deepak!
Thanks for your reply and for the article.

Actually, I have the same question for a simple Select query. I mean,
can I SELECT only the two cells?


Thanks,
Makis