An MDX Question?
OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
HOWTO
Web Reporting
Web App Integration
Installation
Local Settings
Displaying a Report
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
MDX OO Extensions
JAVA Integration
R Integration
Reference
icCube Client Library
XMLA Client Library
Count (standard MDX)

Returns the number of elements in the specified set.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  EXCLUDEEMPTY|INCLUDEEMPTY  zero-one  INCLUDEEMPTY 

Return

numeric-value

Description

Returns the number of elements in the specified set.

INCLUDEEMPTY (default behavior) : empty cells are included in the count (using the measure in the current context).

EXCLUDEEMPTY : does not includes empty cells in the count (using the measure in the current context).

set-expression.Count : an alternate syntax that is equivalent to Count( set-expression, INCLUDEEMPTY )

See Also

DistinctCount Count(Dimensions) Count(Levels) Count(Level)

Examples

Count
Count(set,EXCLUDEEMPTY)
Count(set,EXCLUDEEMPTY) - measures current member

Special Examples (errors, null, ...)

Count(set,EXCLUDEEMPTY) - recursive call

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.

icCube OLAP version: 3.0.3 03-Mar-2013 14:06:07 GMT