Nonempty

Returns 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.

NONEMPTY(set_expression1 [,set_expression2])

set_expression1

A valid Multidimensional Expressions (MDX) expression that returns a set.

set_expression2

A valid Multidimensional Expressions (MDX) expression that returns a set.

In this example, getting all Countries Reseller Sales Amount for year 2005, in output you can observer I am also getting countries with Reseller Sales Amount value as Null

SELECT
  {[Measures].[Reseller Sales Amount]} ON COLUMNS
,{[Geography].[Country].Children} ON ROWS
FROM [Adventure Works]
WHERE
  [Date].[Calendar Year].&[2005];

image

What changes I need to incorporate to a…………..read more

 

 

Karan Gulati

Developer Support – Escalation Services.