Hi,

I am using ADOMD cellset object to go through the result set of an MDX
Statement and build an XML file.

My question is, is there an easy way to find out the number of cells
returned by the MDX staetement and also the number of non-empty cells.

I thought the cellset object would have a property defined to do this but
did not find it. Any sample code is appreciated.

Thx,

Sam.

Number of cells = (Number of tuples on Rows) x (Number of tuples on
Columns).

int cellcount = Cellset.Axes(0).Positions.Count *
Cellset.Axes(1).Positions.Count

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