Skip to content

defaultmember-element-assl.md

Latest commit

 

History

History
71 lines (57 loc) · 3.24 KB

defaultmember-element-assl.md

File metadata and controls

71 lines (57 loc) · 3.24 KB
title DefaultMember Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
DefaultMember Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
DefaultMember
helpviewer_keywords
DefaultMember element
ms.assetid db4eea9f-f7cf-40de-abd0-b62014e7ec2d
caps.latest.revision 38
author Minewiskan
ms.author owend
manager erikre

DefaultMember Element (ASSL)

Contains a Multidimensional Expressions (MDX) expression that identifies the default member of the parent element.

Syntax

  
<AttributePermission> <!-- or DimensionAttribute, ManyToManyMeasureGroupDimension, PerspectiveAttribute -->  
      ...  
   <DefaultMember>...</DefaultMember>  
      ...  
</AttributePermission>

Element Characteristics

Characteristic Description
Data type and length String
Default value None
Cardinality 0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element
Parent element AttributePermission, DimensionAttribute, ManyToManyMeasureGroupDimension, PerspectiveAttribute
Child elements None

Remarks

The DefaultMember element defines the default member for the parent element. If DefaultMember is not specified or is set to an empty string, [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] chooses a member to use as the default member.

For ManyToManyMeasureGroupDimension elements, the DefaultMember element contains an MDX expression that specifies a member in the dimension identified in the CubeDimensionID element of the ManyToManyMeasureGroupDimension. The MDX expression is similar to the StrToMember MDX function with the CONSTRAINED keyword, in that it cannot include MDX or user-defined functions.

For more information about default members, see Define a Default Member.

The elements that correspond to the parents of DefaultMember in the Analysis Management Objects (AMO) object model are xref:Microsoft.AnalysisServices.AttributePermission, xref:Microsoft.AnalysisServices.DimensionAttribute, and xref:Microsoft.AnalysisServices.PerspectiveAttribute.

See Also

Properties (ASSL)