Reporting with MDX Queries - Pro SQL Server 2012 BI Solutions - page 592

Figure 14-22. The results of the examples in Listing 14-29
Listing 14-29. PrevMember and NextMember Functions
Select
{ [Measures].[SalesQuantity] } On Columns,
{
[DimDates].[Year].[1993]
, [DimDates].[Year].[1993]. PrevMember
} On Rows
From [CubePubsSales];
GO
Select
{ [Measures].[SalesQuantity] } On Columns,
{
[DimDates].[Year].[1992]. NextMember
, [DimDates].[Year].[1992]
} On Rows
From [CubePubsSales];
GO
-- You can even chain these functions together
Select
{ [Measures].[SalesQuantity] } On Columns,
{
[DimDates].[Year].[1991]. NextMember.NextMember
,[DimDates].[Year].[1992]
} On Rows
From [CubePubsSales];