GrandParent (PQL)

Returns the grand parent member of the specified member in a 'regular' hierarchy.


GrandParent( <Member> )

* Click on the function's arguments above for more details on the input values.

  • The member needs to be the unique name of an existing member in a hierarchy in the model.
  • The function will not work on drill-path hierarchies.
  • For details on how to employ and use this function see the semantic calculation overview.
Different Function types
  • This function is like the MDX parent function.


This example returns the member "USA" from the Geography hierarchy in the Customer dimension based on picking the member "Brooklyn"

GrandParent([Customer].^[Geography].[USA].[New York].[Brooklyn])