Syntax

NonEmptySubset (set [, value_expression [, dimension...]])

Parameters

set

The set to reduce.

value_expression

A value expression--ideally, a stored member or a simple formula. For each tuple in set, if value_expression is nonempty, the tuple is returned as part of the subset. Otherwise, it is removed.

dimension

One or more (comma-separated) dimensions from which to return the non-empty subset.

Notes

Value_expression, if used, should be a stored member or simple formula. If value_expression is a complex formula, the retrieval of the nonempty subset is not optimized.

Example

The following MDX query gets the bottom 10 products in terms of Units (items per package), and then returns the CrossJoin of that set and the level 0 members (zip codes) of [Albany - NY].

WITH SET Bottom_10 
AS '
 BottomCount(
  Leaves(Products),
  10,
  Units
 )
'
SELECT 
 {Units} 
ON COLUMNS,
 NonEmptySubset(CrossJoin(Bottom_10, Leaves([Albany - NY])))
ON ROWS
FROM Asosamp.Basic

The above query returns the following output: