Ascendants (MDX)
Returns the set of the ascendants of a specified member, including the member itself.
Syntax
Ascendants(Member_Expression)
Arguments
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
Remarks
The Ascendants function returns all of the ancestors of a member from the member itself up to the top of the member's hierarchy; more specifically, it performs a post-order traversal of the hierarchy for the specified member, and then returns all ascendant members related to the member, including itself, in a set. This is in contrast to the Ancestor function, which returns a specific ascendant member, or ancestor, at a specific level.
Examples
The following example returns the count of reseller orders for the [Sales Territory].[Northwest]
member and all the ascendants of that member from the Adventure Works cube. The Ascendants function constructs the set that includes the [Sales Territory].[Northwest]
member and its ascendants for the ROWS axis.
SELECT
Measures.[Reseller Order Count] ON COLUMNS,
Order(
Ascendants(
[Sales Territory].[Northwest]
),
DESC
) ON ROWS
FROM
[Adventure Works]
See Also
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho