Database Reference
In-Depth Information
Figure 14-14.
The results of the example in Listing 14-19
Listing 14-19.
Placing Members within Dimensions
-- Calculated Members do not have to be on the Measures dimension
With Member [DimDates].[Year].[1992 And 1993]
As
[DimDates].[Year-Qtr-Month-Day].[1992]
+
[DimDates].[Year-Qtr-Month-Day].[1993]
Select
{ [Measures].[SalesQuantity] } On Columns,
{
[DimDates].[Year].[1992 And 1993]
} On Rows
From [CubePubsSales];
Member Properties
MDX uses a number of properties and functions to return a set of one or more tuples. Two common properties
are the
Members
property and the
AllMembers
property. he
Members
property returns standard members. he
AllMembers
property returns standard members as well as any calculated members. Listing 14-20 gives an
example of each. Figure
14-15
displays the query results.