DrillupLevel (MDX)
Drills up the members of a set that are below a specified level.
Syntax
DrillupLevel(Set_Expression [ , Level_Expression ] )
Arguments
Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a set.
Level_Expression
A valid Multidimensional Expressions (MDX) expression that returns a level.
Remarks
The DrillupLevel function returns a set of members organized hierarchically based on the members included in the specified set. Order is preserved among the members in the specified set.
If a level expression is specified, the DrillupLevel function constructs the set by retrieving only those members that are above the specified level. If a level expression is specified and there is no member of the specified level represented in the specified set, the specified set is returned.
If a level expression is not specified, the function constructs the set by retrieving only those members that are one level higher than the lowest level of the first dimension referenced in the specified set.
Example
The following example returns the set of members from the first set that are above the Subcategory level.
SELECT DrillUpLevel
({[Product].[Product Categories].[All Products]
,[Product].[Product Categories].[Subcategory].&[32],
[Product].[Product Categories].[Product].&[215]},
[Product].[Product Categories].[Subcategory]
)
ON 0
FROM [Adventure Works]
WHERE [Measures].[Internet Order Quantity]
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