DataMember (MDX)
Returns the system-generated data member that is associated with a nonleaf member of a dimension.
Syntax
Member_Expression.DataMember
Arguments
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
Remarks
This function operates on nonleaf members in any hierarchy and can be used by the UPDATE CUBE Statement (MDX) command to writeback data to a nonleaf member directly, rather than to the leaf member's descendants.
Note
Returns the specified member if the specified member is a leaf member, or if the nonleaf member does not have an associated data member.
Example
The following example uses the DataMember function in a calculated measure to show the sales quota for each individual employee:
WITH MEMBER measures.InvidualQuota AS
([Employee].[Employees].currentmember.datamember, [Measures].[Sales Amount Quota])
,FORMAT_STRING='Currency'
SELECT {[Measures].[Sales Amount Quota],[Measures].InvidualQuota} ON COLUMNS,
[Employee].[Employees].MEMBERS ON ROWS
FROM [Adventure Works]
See Also
MDX Function Reference (MDX)
Key Concepts in MDX (Analysis Services)
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