|
Home > Archive > MS SQL Server OLAP > September 2005 > drillthrough while you have multiple partitions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
drillthrough while you have multiple partitions
|
|
|
| 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());
| |
| Darren Gosbell 2005-09-21, 7:23 am |
| Looks correct.
For multiple partitions, AS returns a recordset for each partition.
--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <96244529-30E8-4A34-8D6A- 104AFBBE917C@microso
ft.com>,
Moshe@discussions.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());
>
>
| |
|
| 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:
> Looks correct.
>
> For multiple partitions, AS returns a recordset for each partition.
>
> --
> Regards
> Darren Gosbell [MCSD]
> < dgosbell_at_yahoo_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <96244529-30E8-4A34-8D6A- 104AFBBE917C@microso
ft.com>,
> Moshe@discussions.microsoft.com says...
>
|
|
|
|
|