Returns a member's parent.
member.Parent
OR
Parent ( member )
member | A member specification. |
SELECT {Parent ([100-10])} ON COLUMNS FROM sample.basic
returns the parent of 100-10:
100 |
---|
30468 |
The following 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:
Sales | |
---|---|
Qtr2 | 27187 |
Qtr3 | 28544 |
Qtr4 | 25355 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |