icCube

Documentation

NonEmptyX

(MDX+)

Return the list of tuples removing all tuples that are empty based on the indexing of the measure

Parameters

Name Type Cardinality Default value
  set-expression  one   
  measure  one   

Return

set

Description

This is a very fast version of pseudo - nonempty. It's worth using when applied to a huge crossjoin.

- NonEmpty is based in the indexing structure, not in fact values. Only if the measure as no NULL values in facts it will return the same result as a nonempty.
- Set has to be a crossjoin.
- Set is materialized, pay attention of the resulting size.
- If possible, a multithreaded version is used.

See Also

NonEmpty

Examples

Special Examples (errors, null, ...)

Since Version

6.8.3

XMLA Properties

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