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
NonEmpty (standard MDX)

Return the list of members that are non empty.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  set-expression  zero-one   

Return

set

Description

Returns a set of non empty tuples.

A single set as parameter :

This function filters out members that are empty. Empty tuples are the ones that have an empty value for the given measure. Missing members in the tuple are completed using the same logic than in the axis (slicer/default).

Two sets as parameter :

This function returns the tuples in the first set that are non empty when evaluated across the tuples of the second set.

See Also

IsEmpty Exists

Examples

NonEmpty(tuple_set)
NonEmpty(tuple_set,tuple_set) -

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