Drillthrough on cube with multiple partition

#1

Hi,
Currently I have a cube with multiple partitions based on the same
fact table, split by month.

When I do a drillthrough with the analysis services (AS) manager
interface, it returned the correct result (i.e. results for all the
months involved).

But when using the drillthrough function via OWC XP, it returns only
data from one of the partitions...

Have tried to trace the query involved using sql profiler, it seems
that when I use the AS manager, it queries all partitions, yet it seem
to query only using the filtering criteria of one of the partitions
when I use OWC (also tried ADO in VB, rs.NextRecordset returns
nothing...)

I've seen some posts suggesting that PTS returns multiple recordsets
for each partition involved... it seems to be true when running from
AS but not from OWC nor ADO...

Any suggestions from anyone out there??

Any comments is appreciated cos I've been looking at this problem for
ages already...

#2

Hi All,

I think I have similar problem of having cube with
multiple partitions based on the same fact table, split by
month, and drillthrough returns empty set in some months.

I actually drillthrough using ADODB.Recordset. In some
months, it returns the same results as AS, but in some
months it returns an empty set, while AS seems to return a
correct result.
Drillthrough MDX where [Period].[All Period].[2002].[2002 -
12] --- works
Drillthrough MDX where [Period].[All Period].[2003].[2003 -
01] --- returns empty set

I have AS SP3, and have tried to restart AS Server after
processing the cubes, but the problem is still there.

Appreciate for your help.

Regards,
Dao

Quote:

-----Original Message-----
If you can't guess from the code, the issue is that
multiple partitions,
drillthough returns a collection of recordsets; one for
each partition. You
need to loop through the collection.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and
confers no rights.

"VMG" <vmg (AT) agro (DOT) dp.ua> wrote in message
news:b954e013.0308140511.4063a7f9 (AT) posting (DOT) google.com...
Use drillthrough.htc from Office component toolpack
with next adds and
modifications:
...
{
...
// alert(sMDX)

rs.Source = sMDX;//about 1444 line

{
rs.Open();

var rsCasper = new ActiveXObject
("ADODB.Recordset"); //~begin
rsCasper.CursorLocation = 3;
rsCasper.LockType = 4;
for(var i=0;i<rs.Fields.Count;i++)
rsCasper.Fields.Append(rs.Fields(i).Name+i,
rs.Fields(i).Type,rs.Fields(i).DefinedSize);
rsCasper.Open();
while(rs) {
while(!rs.EOF){
rsCasper.addNew();
for(var i=0;i<rs.Fields.Count;i++)
rsCasper.Fields(i)=rs.Fields(i);
rsCasper.Update();
rs.MoveNext();
}
rs = rs.NextRecordset();
}
//~ end
}
...
iNumRecords = rsCasper.RecordCount;//~
...
this.Recordset = rsCasper; //~

return rsCasper; //~
}
}

Add in function setupPivotTable(ptMe) code

while(!rs.EOF)rs.MoveNext();//~

after
rs = dt.Data.GetRecordset();

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Drillthrough on cube with multiple partition

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Drillthrough on cube with multiple partition - 08-13-2003 , 07:28 PM

Re: Drillthrough on cube with multiple partition - 08-20-2003 , 07:42 PM