Hi

Is there any way to get the total count of rows (or columns) in a cellset
via MDX. I want to be able know how many pages of data (where a page is a
fixed amount) I have gor a given MDX statement. I know I can count the total
members but I can't figure out how to get the count of members in a 'non
empty' cellset.

Example statement

SELECT NON EMPTY {[Yearly Income].members ON 0, [Product].members ON 1 FROM
[Sales]

I would like to be able to return the number of supressed rows without
executing the entire statement and get the axis members count (as larger
views would lock up the database)

TIA

Graham

How about:

WITH MEMBER [Measures].[SuppressedCount] AS '([Yearly Income].Members.Count
* [Product].Members.Count) - NonEmptyCrossJoin([Yearly
Income].Members.Count, [Product].Members.Count).Count'

....?



"Graham Lloyd" <gilly1409_NOT (AT) hotmail (DOT) com> wrote

Thank you

It wasn't exactly what I was after but certainly pointed me in the right
direction


"Elad" <NoSpam> wrote