Drillthrough in AS SP3 is returning an empty recordset
both in Analysis Manager and via ADO/MD.

Drillthru options have been set on both virtual cube and
source cubes, however, source cubes are also partitioned
by Period.

The period dimension hierarchy consists of 3 levels,
ALL>Year>Period.

Partitions have been created using the DSO model and
specifies a slice value for levels 1-3.

Appreciate any clues

Julie,

When you use drillthrough against partitioned cubes, you'll get a back a
recordset for each partition. Try enumerating through the recordsets and
see if any of them have the data you are looking for.

Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Julie Sciberras" <Julie.Sciberras (AT) Solution6 (DOT) com> wrote

Hi Sean,
Can you give us an example regarding enumerating through
recordsets, as this is an empty recordset?

The following query is used for drillthrough:
DRILLTHROUGH MAXROWS 100 SELECT {[Measures].[Chargeable
Hours PTD]} ON COLUMNS, {[Engagement Partner].[All
Partner]} ON ROWS FROM [Engagement Partner Performance]
WHERE ([Currency Type].[Global : USD], [Engagement].[All
Engagement], [Period].[2002 - 08])

And an empty recordset is returned.

Thanks,
Dao.

Hi Sean,
I have found a sample to loop through the recordsets with
rec.nextrecordset.
Thanks muchly for your help!
Regards,
Dao.

Where can I find an example to loop through the recordsets with
rec.nextrecordset. ?

Thanks in advance
Pablo

"Dao Trinh" <dao.trinh (AT) solution6 (DOT) com> escribió en el mensaje
news:507101c37688$b5de4b20$a601280a (AT) phx (DOT) gbl...