Database Reference
In-Depth Information
Because SSAS considers each attribute a hierarchy of its own (remember the warning in the designer about
“hiding” these?), using the name of an attribute and a level also returns a SET of tuples. Listing 14-22 shows an
example of this, and Figure
14-17
displays the results.
Figure 14-17.
The results of the example in Listing 14-22
Listing 14-22.
Specifying an Attribute Hierarchy Does Not Implicitly Return All Members
Select
{ [Measures].[SalesQuantity] } On Columns,
{
−- Dimension - Attribute Hierarchy
[DimTitles].[Title]
} On Rows
From [CubePubsSales];
The NonEmpty Function
Sometimes when you execute a query, a lot of null values are included in the results. For example, in the Pubs
database, many publishers have no sales associated with them. Therefore, the sales quantity for that publisher is
displayed as null, which in MDX is equivalent to an empty set. The query in Listing 14-23 demonstrates this. The
results are displayed in Figure
14-18
.
