ANCENDANTS

ANCENDANTS

This documentation is for Kyvos 2026.2.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.2.x. To view documentation for other Kyvos versions, click here.

Description:

This function is used to return the set of the ascendants of a specified member, including the member itself.
Syntax:

Ascendants(Member_Expression)

Return Type:
SET

Parameters:

Parameter

Description

Parameter

Description

Member_Expression

It is a valid MDX expression that returns a member.

Example:

select [Measures].[Internet Sales Amount] on columns,ascendants([Customer].[Geography].[City].&[Australia]&[New South Wales]&[Goulburn]) on rows from [AdventureWorksMF]

Copyright Kyvos, Inc. 2026. All rights reserved.