NONEMPTY
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
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 |
|---|---|
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]