Returns the number of items.
Parameters
| |
level-type-expression |
one |
|
Return
numeric-value
Description
Depending on the type of the expression, returns:
1) if a level is specified, the number of members of this level
2) if a tuple is specified, the number of members of this tuple
expression.Count : an alternate syntax that is equivalent to Count( expression )
See Also
Count(Dimensions) Count(Levels) Count
Examples
Returns the number of members in the specified level.
Query
WITH
MEMBER [Measures].[M. Count] AS [Geography].[Geo].[City].Count
SELECT
[MEASURES].[M. Count] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[M. Count] AS count( [Geography].[Geo].[City].members )
SELECT
[Measures].[M. Count] ON 0
FROM
[Sales]
Returns the number of members of the specified tuple.
Query
WITH
MEMBER [Measures].[M. Count] AS ( [Geography].[Geo].DefaultMember, [Geography].[Economy].DefaultMember, [Measures].DefaultMember ).Count
SELECT
[MEASURES].[M. Count] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[M. Count] AS 3
SELECT
[Measures].[M. Count] ON 0
FROM
[Sales]
Returns 1 as the hierarchy is converted into a tuple with one member (default member).
Query
WITH
MEMBER [Measures].[M. Count] AS [Geography].[Geo].Count
SELECT
[MEASURES].[M. Count] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[M. Count] AS 1
SELECT
[Measures].[M. Count] ON 0
FROM
[Sales]
Returns 1 as the member is converted into a tuple.
Query
WITH
MEMBER [Measures].[M. Count] AS [Geography].[Geo].[United States].Count
SELECT
[MEASURES].[M. Count] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[M. Count] AS 1
SELECT
[Measures].[M. Count] ON 0
FROM
[Sales]
Special Examples (errors, null, ...)
For non existing tuples, count returns 0.
Query
WITH
MEMBER [Measures].[M. Count] AS ( [Geography].[Geo].[France], [Geography].[Economy].[Canada], [Measures].DefaultMember ).Count
SELECT
[Measures].[M. Count] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[M. Count] AS 0
SELECT
[Measures].[M. Count] ON 0
FROM
[Sales]
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.
icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT