PrevMember
The PrevMember
function returns the member that precedes the specified
member in the level.
Syntax
Member_Expression.PrevMember
Return Value
Returns the previous member value in the level of the specified member.
Input Parameters
Member_Expression
An MDX expression that returns a member.
Examples
The following example returns the order quantity for 2006, given the specified member 2007.
SELECT
{
[Order Date Dimension].[Order Date Month Hierarchy].[Order YearMonth].[2007].PrevMember
} ON 0 ,
{[Measures].[orderquantity1]} on 1
FROM [Internet Sales Cube]