MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1055

can be used to pass in one arbitrary configuration setting to be used by
MDX functions.

See also: UserName, Call ()

D

Member .DataMember Returns: member Extension: AS2005, AS2000

This function returns the system-generated data input member associ-
ated with a member (as opposed to the input data). In AS2000 this func-
tion generally applies to parent-child dimensions where data is input at
the parent level and also calculated by aggregating the parent's children.
In AS2005, you can use this on any hierarchy. The following example
produces both the input individual salary and the aggregated organiza-
tional salary for each employee:
WITH MEMBER [Measures].[Individual Salary]
AS
'([Employees].CurrentMember.DataMember,
[Measures].[Salary])'
SELECT
{ [Employees].Members } on columns,
{ [Measures].[Salary], [Measures].[Individual
Salary] } on rows
FROM HRCube

Note that when using the UPDATE CUBE command, the .DataMember
function enables you to write data to the actual member, as opposed to
the member's leaf descendants.

dimension .DefaultMember Standard

hierarchy .DefaultMember Standard

Each of these returns the default member for the dimension or hierarchy.
If the dimension has an All level and member, then the default member is
the All member. If the dimension does not have an All member, then an
arbitrary member from its top level will be the default member. Microsoft