ANCENDANTS

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]

Kyvos 2025.2

ANCENDANTS

Analytics

Related content