Database Reference
In-Depth Information
Figure 14-18.
The results of the example in Listing 14-23
Listing 14-23.
A Query That Produces Many Null Values
Select
{ [Measures].[SalesQuantity] } On Columns,
{
[DimTitles].[Publisher].[Publisher]
} On Rows
From [CubePubsSales];
If you do not want null values displayed, use the
NonEmpty
function to remove nulls from the result set.
Listing 14-24 shows an example of this function. See Figure
14-19
for the results.
Figure 14-19.
The results of the example in Listing 14-24