| title | DataMember (MDX) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2016 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| f1_keywords |
|
|
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 65bf21e8-1cb2-4ae8-bfbe-bb4d72589557 | |
| caps.latest.revision | 30 | |
| author | Minewiskan | |
| ms.author | owend | |
| manager | erikre |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns the system-generated data member that is associated with a nonleaf member of a dimension.
Member_Expression.DataMember
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
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.
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]
MDX Function Reference (MDX)
Key Concepts in MDX (Analysis Services)