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
limit	value-expression	zero-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.

The third parameter, optional, limits the number of returned tuples.

Examples

NonEmptyX(tuple_set, measure)

Returns all set members that are non empty, facts indexing wise, from the tuple set.

In our example, this is equivalent to nonEmpty

Query

NonEmptyX([Geography].[Geo].members * [Time].[Calendar].members, [Measures].[Amount] )

Result

{
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 12 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 14 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 15 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 16 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 17 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 18 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 20 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 22 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 25 2010] ), 
  ( [Geography].[Geo].[All Regions], [Time].[Calendar].[Day].[May 29 2010] ), 
  ( [Geography].[Geo].[Continent].[America], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[Continent].[America], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[Continent].[America], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[Continent].[America], [Time].[Calendar].[Day].[May 25 2010] ), 
  ( [Geography].[Geo].[Continent].[America], [Time].[Calendar].[Day].[May 29 2010] ), 
  ( [Geography].[Geo].[Country].[United States], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[Country].[United States], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[Country].[United States], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[Country].[United States], [Time].[Calendar].[Day].[May 25 2010] ), 
  ( [Geography].[Geo].[Country].[United States], [Time].[Calendar].[Day].[May 29 2010] ), 
  ( [Geography].[Geo].[City].[New York], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[City].[New York], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[City].[New York], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[City].[New York], [Time].[Calendar].[Day].[May 25 2010] ), 
  ( [Geography].[Geo].[City].[New York], [Time].[Calendar].[Day].[May 29 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 12 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 14 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 15 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 16 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 17 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 18 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 20 2010] ), 
  ( [Geography].[Geo].[Continent].[Europe], [Time].[Calendar].[Day].[May 22 2010] ), 
  ( [Geography].[Geo].[Country].[France], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[Country].[France], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[Country].[France], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[Country].[France], [Time].[Calendar].[Day].[May 15 2010] ), 
  ( [Geography].[Geo].[City].[Paris], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[City].[Paris], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[City].[Paris], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[City].[Paris], [Time].[Calendar].[Day].[May 15 2010] ), 
  ( [Geography].[Geo].[Country].[Spain], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[Country].[Spain], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[Country].[Spain], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[Country].[Spain], [Time].[Calendar].[Day].[May 12 2010] ), 
  ( [Geography].[Geo].[Country].[Spain], [Time].[Calendar].[Day].[May 14 2010] ), 
  ( [Geography].[Geo].[City].[Barcelona], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[City].[Barcelona], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[City].[Barcelona], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[City].[Barcelona], [Time].[Calendar].[Day].[May 14 2010] ), 
  ( [Geography].[Geo].[City].[Madrid], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[City].[Madrid], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[City].[Madrid], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[City].[Madrid], [Time].[Calendar].[Day].[May 12 2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Day].[May 16 2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Day].[May 17 2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Day].[May 18 2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Day].[May 20 2010] ), 
  ( [Geography].[Geo].[Country].[Switzerland], [Time].[Calendar].[Day].[May 22 2010] ), 
  ( [Geography].[Geo].[City].[Geneva], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[City].[Geneva], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[City].[Geneva], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[City].[Geneva], [Time].[Calendar].[Day].[May 22 2010] ), 
  ( [Geography].[Geo].[City].[Lausanne], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[City].[Lausanne], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[City].[Lausanne], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[City].[Lausanne], [Time].[Calendar].[Day].[May 16 2010] ), 
  ( [Geography].[Geo].[City].[Lausanne], [Time].[Calendar].[Day].[May 17 2010] ), 
  ( [Geography].[Geo].[City].[Lausanne], [Time].[Calendar].[Day].[May 18 2010] ), 
  ( [Geography].[Geo].[City].[Zurich], [Time].[Calendar].[Year].[2010] ), 
  ( [Geography].[Geo].[City].[Zurich], [Time].[Calendar].[Quarter].[Q2 2010] ), 
  ( [Geography].[Geo].[City].[Zurich], [Time].[Calendar].[Month].[May 2010] ), 
  ( [Geography].[Geo].[City].[Zurich], [Time].[Calendar].[Day].[May 20 2010] )
}

Assertion : Cell Equals

NonEmpty([Geography].[Geo].members * [Time].[Calendar].members, [Measures].[Amount] )

NonEmptyX(tuple_set, measure,limit)

Special Examples (errors, null, ...)

NonEmptyX(tuple_set, member)

Since Version

6.8.3

XMLA Properties

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