Analysis Services with ADO.NET (OleDB) + ADOMD with .net

  • Thread starter Thread starter Lars-Erik Aabech
  • Start date Start date
L

Lars-Erik Aabech

Hi!

We've been experimenting a bit with Analysis Services
and .net.

We've gotten as far as getting a dataset filled with
results from an MDX query using the OLEDB provider for
msolap. But when we try to bind the dataset to a grid,
only the first column (rows dimension) in the result is
shown. The grid is set to build columns at runtime.
How come? :P

Secondly, we've been experimenting with ADOMD in .net.
What we wanted was to return a CellSet from a webservice -
The result was an error like "CellSet doesn't support
serializing". Is this not possible at all? Or do we have
to encapsulate it in another class that can serialize it?
And if we make this work.. can we databind a cellset?

Any hints appreciated :)

Lars-Erik
 
Back
Top