drillthrough while you have multiple partitions

#1

Hi,

What is the way to do in ADOMD drillthrough while you have multiple
partitions in the cube?

I manage to do it using OleDbDataReader NextResult() method:

OleDbCommand cmd = new OleDbCommand();
OleDbDataReader dr = null;

cmd.CommandText = "DRILLTHROUGH SELECT From [Sales] Where ...";
dr = cmd.ExecuteReader();
do
{
...
}
while (dr.NextResult());

#2

Looks correct.

For multiple partitions, AS returns a recordset for each partition.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <96244529-30E8-4A34-8D6A-104AFBBE917C (AT) microsoft (DOT) com>,
Moshe (AT) discussions (DOT) microsoft.com says...

Quote:

Hi,

What is the way to do in ADOMD drillthrough while you have multiple
partitions in the cube?

I manage to do it using OleDbDataReader NextResult() method:

OleDbCommand cmd = new OleDbCommand();
OleDbDataReader dr = null;

cmd.CommandText = "DRILLTHROUGH SELECT From [Sales] Where ...";
dr = cmd.ExecuteReader();
do
{
...
}
while (dr.NextResult());

#3

but if I use
AdomdCommand & AdomdDataReader instead of OleDbCommand & OleDbDataReader it
doesn't work.
Is it a bug or there is another way to do it?

"Darren Gosbell" wrote:

Quote:

Looks correct.

For multiple partitions, AS returns a recordset for each partition.

--
Regards
Darren Gosbell [MCSD]
dgosbell_at_yahoo_dot_com
Blog: http://www.geekswithblogs.net/darrengosbell

In article <96244529-30E8-4A34-8D6A-104AFBBE917C (AT) microsoft (DOT) com>,
Moshe (AT) discussions (DOT) microsoft.com says...
Hi,

What is the way to do in ADOMD drillthrough while you have multiple
partitions in the cube?

I manage to do it using OleDbDataReader NextResult() method:

OleDbCommand cmd = new OleDbCommand();
OleDbDataReader dr = null;

cmd.CommandText = "DRILLTHROUGH SELECT From [Sales] Where ...";
dr = cmd.ExecuteReader();
do
{
...
}
while (dr.NextResult());

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

drillthrough while you have multiple partitions

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

drillthrough while you have multiple partitions - 09-21-2005 , 05:09 AM

Re: drillthrough while you have multiple partitions - 09-21-2005 , 06:04 AM

Re: drillthrough while you have multiple partitions - 09-21-2005 , 06:31 AM