Database Reference
In-Depth Information
Figure 14-25.
The results of the examples in Listing 14-32
Listing 14-32.
he
CurrentMember
Function
Select
{ [Measures].[SalesQuantity] } On Columns,
{ [DimDates].[Year].
CurrentMember
} On Rows
From [CubePubsSales];
GO
-- The CurrentMember function is implied
Select
{ [Measures].[SalesQuantity] } On Columns,
{ [DimDates].[Year] } On Rows
From [CubePubsSales];
Occasionally, when you are working with MDX expressions in Visual Studio or in a reporting application
such as SSRS, the
CurrentMember
function must be explicitly typed out for an expression to work properly. Both
of these tools usually let you create the MDX expression with a designer interface that programs the MDX code
for you, but not always. Therefore, keep this option in mind when creating MDX expressions in either one of
these programs.
