Ancestor

Returns the ancestor of a member at a specified level.

Syntax

Ancestor(«Member», «Level»)

Example

If the Geography dimension includes levels Country, State, and City, then the following functions return the following values.

Function Returns
Ancestor(Seattle, Country) USA
Ancestor(Seattle, State) Washington

(c) 1999 Microsoft Corporation. All Rights Reserved.