hi, everyone:
In my solution, I have a cube which included two partitions. one is A,
other is B. A is a history data partition and B is weekly data partition.
when B exceeded one week, It will be merged into A.
So I want to dirll through data from these partitions. however, I got an
odd issue when drilling through from two partitions. I can drill through data
from A, on the other hands , I can't drill through current week data from B.
I don't know that there is an issue on Analysis Service 2000 or it
offers some options to drill through data from two or more partitions?

--
Developer
QA Dashboard
Microsoft China Development Centre

drillthrough returns a collection of rowsets. One rowset for each partition.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Microlong" <Microlong (AT) email (DOT) com> wrote

thanks Dave Wickert! I drill through data from cube by spelling MDX, I means
that I spell MDX statement and then push it into cube. OLAP Server will
process and retriev data. Do you know how to piont right rowsets in MDX
statement? other way is OK as well

"Dave Wickert [MSFT]" wrote:

You can use FIRSTROWSET which identifies the partition whose rowset is
returned first.

Ohjoo Kwon


"Microlong" <Microlong (AT) email (DOT) com> wrote

Here is an earlier thread from this newsgroup, with sample code to
handle rowsets returned for multiple partitions:

http://groups-beta.google.com/group/...rver.olap/msg/
201a2b1583cc812b
From: thomasgre... (AT) hotmail (DOT) com (Thomas)
Date: 27 Feb 2003 07:12:36 -0800

Subject: Re: Excel XP DrillThrough Sample for Multiple Partitions

The recordset retrieved from the drill through has data from all
partitions. The data has just to be pasted into the XL sheet by
looping through all the partitions. Assuming that rst is the recordset
you retrieved, the following code will do the job (it might not be the
best implementation but it works.)


If you're interested I can send you a XL add-in that adds drill
through (multiple partitions) functionality to XL 2000 / XP.

HTH

Thomas

'Get data from recordset to worksheet

intNumberPartitions = 0

Do Until Done

On Error GoTo ExitDo
' repeat until all partitions done
intNumberPartitions = intNumberPartitions + 1
' show current partition
Application.StatusBar = "Pasting Partition: " &
CStr(intNumberPartitions)

Dim strPasteArea As String
' determine next free row
strPasteArea = "A" & CStr(Range("a65536").End(xlUp)*.row + 1)
' paste data
Range(strPasteArea).CopyFromRe*cordset rst
' next partition
Set rst = rst.NextRecordset

If rst.State = adStateClosed Then Done = True

Loop

ExitDo:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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