I did read
http://msdn.microsoft.com/library/de...nservdrill.asp
several times now, but I cannot get my drillthrough to work as I would like
it to.

Say I got a very simple table in Excel (loaded from a cube)
Orders Items
October 3 5

So in October there were 3 orders that contained 5 items. Orders is a
measure in a measure group defined on an orders table, items is a measure
defined on the orders detail table (all pretty standard design)

Can I get the drill arranged in a way that by drilling on 3 I get returned
the 3 rows from the order measure group, and by drilling on the 5 the 5
items from the order detail measure group are returned? Somehow, for me it
always returns the 5 details.

Thanks!
Ralf

"Ralf Mayer" schrieb im Newsbeitrag...
I should have added an example of the mdx command issued to drill, here it
is (in this case for 8th of July 2006, Detail Level is the cube name, Data
is dimension containing the date of an order):

DRILLTHROUGH MAXROWS 65000 SELECT {[Data].[Submitted Date].[Submitted
Year].&[2006].&[200607].&
[20060708]} ON 0 FROM [Detail Level]

I think this is the most simple command possible... It will return 5 detail
lines for all the items in the 3 orders on the day.

I do not have a return clause in here, I have 2 sets of Drillthrough actions
defined in the Cube Actions, hoping the drill would use the appropriate one
(as the link above would suggest). The command is generated identical for
the orders measure group or items measure group btw, and that I think is the
problem.

How would it have to be changed to return only the 3 orders and not give the
duplicates, if that is possible at all? Or is the setup in Cube Actions what
I need to get this result?

You should explicitly specify a measure, to ensure that the desired
measure group is selected, like:

DRILLTHROUGH MAXROWS 65000
SELECT {[Measures].[Orders]} ON 0
FROM [Detail Level]
where [Data].[Submitted Date].[Submitted
Year].&[2006].&[200607].&[20060708]


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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