Home      Functions     Common Solutions      Contact     






MDX Functions:
 
MDX Functions

 
Common Solutions

Common Solutions
 
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
 
Other Links

Contact Us
 
Microsoft SQL Server Analysis Services Function Page
Function Name: DefaultMember
Category: Navigation
Description: The DefaultMember function returns the default member of a hierarchy.
Syntax: «Hierarchy».DEFAULTMEMBER
Technet Link: MDX DefaultMember Function




The query below shows the default member value (Reseller Sales Amount) of the Measures dimension.
 

SELECT
      {Measures.DefaultMember} ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
The following query shows the default member for Measures dimension and the Promotions hierarchy. Notice the Measures dimension was not explicitly defined on an axis, yet the default measure value is returned. This is due to the context of the query. All queries are run int he context of the default members for all hierarchies.
 

SELECT
      {[Promotion].[Promotions].DefaultMember} ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
The query below shows the UniqueName of the default members for several hierarchies.
 
WITH
      MEMBER [Measures].[EmpDeparDM] AS
      [Employee].[Employee Department].DefaultMember.UniqueName
      MEMBER [Measures].[ProdCatDM] AS
      [Product].[Product Categories].DefaultMember.UniqueName
      MEMBER [Measures].[DelDateFiscalDM] AS
      [Delivery Date].[Fiscal].DefaultMember.UniqueName
      MEMBER [Measures].[OrgCurCodeDM] AS
      [Organization].[Currency Code].DefaultMember.UniqueName
SELECT
      {[Measures].[EmpDeparDM], [Measures].[ProdCatDM],[Measures].[DelDateFiscalDM],[Measures].[OrgCurCodeDM]} ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
 

 
Copyright 2008 by MDXpert.com.
 
Terms of Use                              Privacy Statement
 
Site Powered By - WinHost.Com