Re: Can CellSet be passed as parameter?

#1

I am using ADOMD.NET (ExecuteCellSet command) to retrieve data in the cube
into CellSet. But, what is the command to retrieve the data in cube into
DataSet directly? Can you give me some help? Thanks.

"JÃ©jÃ©" wrote:

Quote:

have you try the ADOMD.NET?
you can directly read a cube and take the result in a dataset

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:932D4F29-D622-44F7-B86A-440AC72AA486 (AT) microsoft (DOT) com...
I have written a function which take CellSet as
parameter, and convert the CellSet into DataTable, then
return the DataTable. But, it seem like the CellSet
cannot be passed as parameter.

But, when i copy the code in the function and paste in
the same procedure as i get the CellSet, it work.

Can I pass CellSet as parameter?
(all my code is written in VB.Net )

Best Regards,
Chrysan

#2

When I do such, the system prompt me the following error message:

"The same table (Member) cannot be the child table in two nested
relations."

Can you help? Thanks.

"JÃ©jÃ©" wrote:

Quote:

maybe like this:
m_tmpReader = cmd.ExecuteXmlReader()
Dim tmpReturnDS As New DataSet
tmpReturnDS.ReadXml(m_tmpReadeÂ*r)

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:4B4A4E3C-2900-4BAB-BC52-41D0918A1BF6 (AT) microsoft (DOT) com...
I am using ADOMD.NET (ExecuteCellSet command) to retrieve data in the cube
into CellSet. But, what is the command to retrieve the data in cube into
DataSet directly? Can you give me some help? Thanks.

"JÃ©jÃ©" wrote:

have you try the ADOMD.NET?
you can directly read a cube and take the result in a dataset

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:932D4F29-D622-44F7-B86A-440AC72AA486 (AT) microsoft (DOT) com...
I have written a function which take CellSet as
parameter, and convert the CellSet into DataTable, then
return the DataTable. But, it seem like the CellSet
cannot be passed as parameter.

But, when i copy the code in the function and paste in
the same procedure as i get the CellSet, it work.

Can I pass CellSet as parameter?
(all my code is written in VB.Net )

Best Regards,
Chrysan

#3

have you a dimension with 2 hierarchies?

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote

Quote:

When I do such, the system prompt me the following error message:

"The same table (Member) cannot be the child table in two nested
relations."

Can you help? Thanks.

"Jéjé" wrote:

maybe like this:
m_tmpReader = cmd.ExecuteXmlReader()
Dim tmpReturnDS As New DataSet
tmpReturnDS.ReadXml(m_tmpReade*r)

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:4B4A4E3C-2900-4BAB-BC52-41D0918A1BF6 (AT) microsoft (DOT) com...
I am using ADOMD.NET (ExecuteCellSet command) to retrieve data in the
cube
into CellSet. But, what is the command to retrieve the data in cube
into
DataSet directly? Can you give me some help? Thanks.

"Jéjé" wrote:

have you try the ADOMD.NET?
you can directly read a cube and take the result in a dataset

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:932D4F29-D622-44F7-B86A-440AC72AA486 (AT) microsoft (DOT) com...
I have written a function which take CellSet as
parameter, and convert the CellSet into DataTable, then
return the DataTable. But, it seem like the CellSet
cannot be passed as parameter.

But, when i copy the code in the function and paste in
the same procedure as i get the CellSet, it work.

Can I pass CellSet as parameter?
(all my code is written in VB.Net )

Best Regards,
Chrysan

#4

My mdx statement is as follow:

select {[Measures].[Units Ordered]} on columns , NON EMPTY [Store].[Store
Name].members on rows from Warehouse

Is that a dimension with 2 hierarchies? If so, what should I do to put in
my dataset?

Thanks.

"JÃ©jÃ©" wrote:

Quote:

have you a dimension with 2 hierarchies?

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:7F5425CD-04D2-4084-A183-283F84890FC4 (AT) microsoft (DOT) com...
When I do such, the system prompt me the following error message:

"The same table (Member) cannot be the child table in two nested
relations."

Can you help? Thanks.

"JÃ©jÃ©" wrote:

maybe like this:
m_tmpReader = cmd.ExecuteXmlReader()
Dim tmpReturnDS As New DataSet
tmpReturnDS.ReadXml(m_tmpReadeÂ*r)

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:4B4A4E3C-2900-4BAB-BC52-41D0918A1BF6 (AT) microsoft (DOT) com...
I am using ADOMD.NET (ExecuteCellSet command) to retrieve data in the
cube
into CellSet. But, what is the command to retrieve the data in cube
into
DataSet directly? Can you give me some help? Thanks.

"JÃ©jÃ©" wrote:

have you try the ADOMD.NET?
you can directly read a cube and take the result in a dataset

"Chrysan" <Chrysan (AT) discussions (DOT) microsoft.com> wrote in message
news:932D4F29-D622-44F7-B86A-440AC72AA486 (AT) microsoft (DOT) com...
I have written a function which take CellSet as
parameter, and convert the CellSet into DataTable, then
return the DataTable. But, it seem like the CellSet
cannot be passed as parameter.

But, when i copy the code in the function and paste in
the same procedure as i get the CellSet, it work.

Can I pass CellSet as parameter?
(all my code is written in VB.Net )

Best Regards,
Chrysan

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

Re: Can CellSet be passed as parameter?

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

Re: Can CellSet be passed as parameter? - 08-25-2005 , 10:06 PM

Re: Can CellSet be passed as parameter? - 08-26-2005 , 01:31 AM

Re: Can CellSet be passed as parameter? - 08-26-2005 , 07:14 AM

Re: Can CellSet be passed as parameter? - 09-01-2005 , 02:20 AM