We need to calculate the Average Duration inside an Analysis Services
cube with 5 dimensions. The Cube contains 1.6 million rows.



Calculating the Duration is very, very easy but we are having difficulty
counting the number records within the selected dimensions.



We have tried MDX Count and CountDistinct but that returns the count of
records in the entire cube and does not change with the Dimension
settings. Then we tried MDX CrossJoin and NonEmptyCrossJoin, I am not
sure this is what we want and the time it takes to return the results is
unacceptable.



Count(CrossJoin({[Measures].[Duration]}, [Claims].[Claim No].Members),
ExcludeEmpty)



Count(NonemptyCrossJoin({[Measures].[Duration]}, [Claims].[Claim No]
Members))



Any suggestions..



Thanks Dan Carlson


--
Posted via http://dbforums.com