NONEMPTYCROSSJOIN
Description:
This function is used to return a set that contains the cross product of one or more sets, excluding empty tuples and tuples without associated fact table data.
Syntax:
NonEmptyCrossjoin(Set_Expression1 [ ,Set_Expression2,...] [,Count ])
Return Type:
SET
Parameters:
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. |
Count | It is a valid numeric expression that specifies the number of sets to be returned. |
Example:
WITH MEMBER [Measures].[NonEmpty Count] AS
Count(NonEmpty([Product].[Product].[Product].Members))
MEMBER [Measures].[NonEmpty Sales] AS
SUM(NonEmpty([Product].[Product].[Product].Members), [Measures].[Internet Sales Amount])
SELECT {[Measures].[NonEmpty Count], [Measures].[NonEmpty Sales]} ON COLUMNS
FROM [AdventureWorksMF_ValueBased]