G
GM
Hi,
The environment is .NET 1.1, VS2003. (can also be .NET 2.0 +VS2005)
Suppose I have downloaded a DataSet from the server to the client machine.
I can convert it to an ADO recordset and make it a datasource for a Pivot
Table. This works, but for only for a few thousands of rows. For more rows
Pivot fails with an out of memory error.
Therefore I'm thinking about creating a *.cub file locally, as it can
serve orders of magnitude more rows efficiently.
The question is then:
How to create an OLAP *.cub file from a DataSet on a client.
I tried playing with ADOMD.NET without success. The first barrier was, how
to make a .NET DataSet source for ADOMD.NET.
Is it at all doable?
Thanks
GM
The environment is .NET 1.1, VS2003. (can also be .NET 2.0 +VS2005)
Suppose I have downloaded a DataSet from the server to the client machine.
I can convert it to an ADO recordset and make it a datasource for a Pivot
Table. This works, but for only for a few thousands of rows. For more rows
Pivot fails with an out of memory error.
Therefore I'm thinking about creating a *.cub file locally, as it can
serve orders of magnitude more rows efficiently.
The question is then:
How to create an OLAP *.cub file from a DataSet on a client.
I tried playing with ADOMD.NET without success. The first barrier was, how
to make a .NET DataSet source for ADOMD.NET.
Is it at all doable?
Thanks
GM