Database Reference
In-Depth Information
The Children Function
To use the
Children
function, indicate the coordinates of a member that represents the parent of the child
members to be returned.
You can use this function multiple times in the same statement to access a set of child tuples from different
members in the same dimension. For example, Listing 14-30 is using the Date dimension to identify the children
of the years 1993 and 1992. The results are shown in Figure
14-23
.
Figure 14-23.
The results of the first example in Listing 14-30
Listing 14-30.
he
Children
Function
Select
{ [Measures].[SalesQuantity] } On Columns,
{
[DimDates].[Year-Qtr-Month-Day].[Year].[1992].
Children
, [DimDates].[Year-Qtr-Month-Day].[Year].[1993].
Children
} On Rows
From [CubePubsSales];
The Parent Function
he
Parent
function allows you to specify a member and receive its parent members' value. In Listing 14-31 we
are specifying the first quarter of 1993 and requesting its parent. This means the value for the year 1993, which is
the parent of that first quarter, will be returned. For the results, see Figure
14-24
.