Hi,

We are using Microsoft Analysis Services 2005.

I need to display the count of fields that I am going to display on the page
as most of the dimensions in our model are fairly large. (Pagination)

I was able to calculate the total count of fields in a particular dimension
but unable to apply filters to the MDX statement.

The below MDX works and gives the total count.

with
member [Provider].[Provider_Id].[Count] as
'[Provider].[Provider_id].members.count'
select {[Provider].[ Provider_Id].[Count]} on columns from
[Provider Cube

But I need to apply filters like Time, Geography etc to the above MDX and
determine the appropriate count. Please note that I do not have a ‘Measure’
with any type of count.
Can you please help with the syntax?

Thanks,