Database Reference
In-Depth Information
Listing 14-24.
Using the NonEmpty Function
Select
{ [Measures].[SalesQuantity] } On Columns,
{
NonEmpty(
[DimTitles].[Publisher].[Publisher]
)
} On Rows
From [CubePubsSales];
Compare the results in Figure
14-19
to the results in Figure
14-18
. Notice how the
NonEmpty
function has
removed the null values.
The Non Empty Clause
Nulls can also be removed from a result set using the
Non Empty
clause in MDX statements. Both the
NonEmpty
function and the
Non Empty
clause can be combined to remove null values from your results. Listing 14-25 shows
an example of this option. See Figure
14-20
for the results.
Figure 14-20.
The results from Listing 14-25