Database Reference
In-Depth Information
Figure 14-21.
The results are the same for all the code in Listing 14-26.
Listing 14-26.
Various Paths to Access a Member or Level
-- Starts like this...
Select
{ [Measures].[SalesQuantity] } On Columns,
{
−- Dim.Hierarchy.Level.Member.Member (long path)
[DimTitles].[TitlesByPublisher].[Publisher].[New Moon Books].[Is Anger the Enemy?]
} On Rows
From [CubePubsSales];
GO
-- Can change to this...
Select
{ [Measures].[SalesQuantity] } On Columns,
{
−- Hierarchy.Level.Member.Member
[TitlesByPublisher].[Publisher].[New Moon Books].[Is Anger the Enemy?]
} On Rows
From [CubePubsSales];
GO
-- Or this...
Select
{ [Measures].[SalesQuantity]} On Columns,
{
−- Dim.Member.Member
[DimTitles].[New Moon Books].[Is Anger the Enemy?]
} On Rows
From [CubePubsSales];
GO
-- Or this...
Select
{ [Measures].[SalesQuantity] } On Columns,
