Returns the count of the number of tuples in a set that evaluate to non #Missing values.
NonEmptyCount ( set [,numeric_value_expression ] )
set | The set in which to count tuples. |
numeric_value_expression | Optional expression. |
Each tuple is evaluated and included in the count returned by this function. If the numeric value expression is specified, it is evaluated in the context of every tuple, and the count of non #Missing values is returned.
The following query
With Member [Measures].[Number Of Markets] as 'NonEmptyCount (Market.Levels(0).Members, Sales)' Select {[Measures].[Number Of Markets]} on Columns, {[100].Children, [200].Children} on Rows FROM Sample.Basic
Returns the grid:
Number of Markets | |
---|---|
100-10 | 20 |
100-20 | 16 |
100-30 | 8 |
200-10 | 20 |
200-20 | 17 |
200-30 | 9 |
200-40 | 3 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |