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
Web Reporting
Installation
Local Settings
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
Reference
icCube Client Library
XMLA Client Library
CoalesceEmpty (standard MDX)

Returns the first non-empty numeric value from the parameters list.

Parameters

Name Type Cardinality Default value
  numeric-expression  one-n   

Return

numeric-value

Description

The function returns the first non-empty/null numeric value among the list of parameters.

Usually used to handle nulls, division by zero and/or add a default numeric value.

Examples

CoalesceEmpty(NULL,numeric,numeric,...)

Special Examples (errors, null, ...)

CoalesceEmpty(NULL)
CoalesceEmpty()

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