Hi

We have a web app that browse the MSAS database. One of the issues we have
come across is when a user wants to retrieve large views of data. We got
around this by paging the view using the SUBSET statement in the MDX query
on the row axix and having a 'page next' button. This all works great until
I run out of rows.

What I need is an efficient way of counting the rows of the entire view so I
can calculate when I am going to hit the last page and disable the next page
button.

I can't execute the entire query and get the count of the Members on the
axix. An extreme example would be

{[Product].[All Product].Members} ON 0, {[Customer].[All Customer].members}
ON 1

If I execute that query the server will obvously just sit there for ages. I
was looking for some COUNT function to return the count of the number of
rows of data in the cellset, but all I can find is how to count the members
in an expression eg COUNT([Customers].[All Customers].Members) which takes
no account for non-empty cells or any of data that makes up the cellset.

Is it possible to do what I am trying in either MSAS 2000 or 2005 ??

TIA

Graham