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
Search WWH ::




Custom Search