Syntax

member.Parent [(hierarchy) ]

or

Parent ( member [, hierarchy ] )

Parameters

member

A member specification.

hierarchy

Optional. A specific hierarchy within the time dimension.

Example 1

{Parent ([100-10])}

returns [100], which is the parent of 100-10.

Example 2

The following MDX query uses Filter to find the months in which Sales for [Product].[100] are higher than 8,570. The Parent function is used with Generate to create a set consisting of the parents (quarters) of the high-sales months:

WITH SET [High-Sales Months] as 
' 
 Filter( 
 [Year].Levels(0).members, 
 [Measures].[Sales] > 8570 
 ) 
' 
SELECT 
   {[Measures].[Sales]} 
ON COLUMNS, 
   Generate([High-Sales Months], { Parent([Year].CurrentMember) })
ON ROWS 
FROM 
  sample.basic 
WHERE 
 ([Product].[100]) 

This query returns the grid: