COUNT
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
1. COUNT (Syntax: Hierarchy_Expression.Levels.Count)
Description:
This function is used to return the number of levels in hierarchy. It includes ALL level in count.
Syntax:
Hierarchy_Expression.Levels.Count
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Example:
WITH MEMBER Measures.X AS
[Product].[Product Categories].Levels.Count
Select Measures.X ON 0
FROM [AdventureWorksMF]2. COUNT (Syntax: Count(Set_Expression [ , ( EXCLUDEEMPTY | INCLUDEEMPTY ) ] ))
Description:
This function is used to return the number of cells in a set.
Syntax:
Count(Set_Expression [ , ( EXCLUDEEMPTY | INCLUDEEMPTY ) ] )
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example:
WITH MEMBER measures.X AS
Count([Customer].[Geography].children)
SELECT measures.X ON 0
FROM [AdventureWorksMF]3. COUNT (Syntax: Set_Expression.Count)
Description:
This function is used to return the number of cells in a set.
Syntax:
Set_Expression.Count
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example:
WITH MEMBER measures.X AS
[Customer].[Geography].children.count
SELECT measures.X ON 0
FROM [AdventureWorksMF]4. COUNT (Syntax: Tuple_Expression.Count)
Description:
This function is used to return the number of dimensions in a tuple.
Syntax:
Tuple_Expression.Count
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Tuple_Expression | It is a valid MDX expression that returns a tuple. |
Example:
WITH MEMBER MEASURES.COUNTTUPLE AS
COUNT(([Measures].[Internet Sales Amount], [Customer].[Geography].[Country].&[Australia]))
SELECT MEASURES.COUNTTUPLE ON 0
FROM [AdventureWorksMF]