mdxmissingmembermode-element-assl.md

title	MdxMissingMemberMode Element (ASSL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	MdxMissingMemberMode Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
helpviewer_keywords	MdxMissingMemberMode element
ms.assetid	aca6130b-5fb8-4fa1-af8b-8e1ef361926f
caps.latest.revision	13
author	Minewiskan
ms.author	owend
manager	erikre

MdxMissingMemberMode Element (ASSL)

Determines how missing members are handled for Multidimensional Expressions (MDX) statements.

Syntax

  
<Dimension>  
   ...  
   <MdxMissingMemberMode>...</MdxMissingMemberMode>  
   ...  
</Dimension>  

Element Characteristics

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

Element Relationships

Relationship	Element
Parent element	Dimension
Child elements	None

Remarks

The value of this element is limited to one of the strings listed in the following table.

Value	Description
Ignore	Missing members are ignored.
Error	An error is raised if missing members are encountered.
Default	Missing members are ignored.

The element that corresponds to the parent of MdxMissingMemberMode in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.Dimension.

See Also

Multidimensional Expressions (MDX) Reference
Properties (ASSL)