NONEMPTY

Description:

This function is used to return the set of tuples that are not empty from a specified set, based on the cross product of the specified set with a second set.

Syntax:

NONEMPTY(set_expression1 [,set_expression2])

Return Type:

SET

Parameters:

Parameter	Description

Parameter	Description
Set_Expression1	It is a valid MDX expression that returns a set.
Set_Expression2	It is a valid MDX expression that returns a set.

Example:

WITH SET [NonEmptyCombinations] AS
    NonEmptyCrossjoin([Date].[Calendar].[Calendar Year].Members,
                      [Product].[Product Categories].[Category].Members)
MEMBER [Measures].[Valid Combination Count] AS
    Count([NonEmptyCombinations])
SELECT [Measures].[Valid Combination Count] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]