Database Reference
In-Depth Information
Figure 14-24. The results of the example in Listing 14-31
Listing 14-31. he Parent Function
Select
{ [Measures].[SalesQuantity] } On Columns,
{
[OrderDate].[Year-Qtr-Month-Day].[Q1 - 1993]. Parent
,[OrderDate].[Year-Qtr-Month-Day].[Q1 - 1993]
} On Rows
From [CubePubsSales];
The CurrentMember Function
he CurrentMember function returns values based on the member of a dimension currently under focus. To
understand this, consider how SSAS must resolve a query. Each time you ask for a given member of a dimension,
the SSAS query engine must check each member to see whether it is a match for your request. If it is not, it moves
to the next member until it finds all the members you requested in your MDX statement. Each time the SSAS
engine checks a member, that member is in focus and represents the current member of that dimension.
he CurrentMember function is rarely required for most situations in your MDX code. Listing 14-32 gives two
examples; the first uses the CurrentMember function, and the second does not. Note that both queries return the
exact same results, as shown in Figure 14-25 .
 
Search WWH ::




Custom Search