Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

DataMember (MDX)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 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]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft