formatstring-element-assl.md

title	FormatString 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	FormatString Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	FormatString
helpviewer_keywords	FormatString element
ms.assetid	7b996221-936e-4f36-a3a8-676eb9869c55
caps.latest.revision	34
author	Minewiskan
ms.author	owend
manager	erikre

FormatString Element (ASSL)

Describes the display format for a CalculationProperty element or a Measure element.

Syntax

  
<CalculationProperty> <!-- or Measure -->  
   ...  
   <FormatString>...</FormatString>  
   ...  
</CalculationProperty>  

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 elements	CalculationProperty, Measure
Child elements	None

Remarks

The FormatString property contains a Multidimensional Expressions (MDX) expression. In the case of CalculationProperty elements, it applies to elements with a CalculationType of Member or Cells.

The elements that correspond to the parents of FormatString in the Analysis Management Objects (AMO) object model are xref:Microsoft.AnalysisServices.CalculationProperty and xref:Microsoft.AnalysisServices.Measure.

See Also

CalculationProperties Element (ASSL)
MdxScript Element (ASSL)
MdxScripts Element (ASSL)
Properties (ASSL)