Search code examples
visual-studiossmsssasmdx

How to get the raw mdx cellset back


The cellset that is returned in Visual Studio or SSMS is within a grid. Is there a way to examine the raw data that is returned back from the MDX query? For example, returning the data that includes the font size, the color, etc. and reading that data directly?

If so, how can I examine that in SSMS or VS?


Solution

  • In SSMS double click the result grid, it will expose you the additional porperties. In VS you can use AdoMD, any results returned from a cube will be in CellSet Class.

    enter image description here