SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Analysis Services - Multidimensional Data

Technical Reference

Analysis Services Scripting Language Reference

Analysis Services Scripting Language XML Elements (ASSL)

Properties (ASSL)

Access Element (ASSL)

Account Element (ImpersonationInfo) (ASSL)

AccountType Element (ASSL)

ActionID Element (ASSL)

Administer Element (ASSL)

AggregateFunction Element (ASSL)

AggregationDesignID Element (ASSL)

AggregationFunction Element (ASSL)

AggregationID Element (ASSL)

AggregationInstanceSource Element (ASSL)

AggregationPrefix Element (ASSL)

AggregationStorage Element (ASSL)

AggregationType Element (ASSL)

AggregationUsage Element (ASSL)

Algorithm Element (ASSL)

Alias Element (ASSL)

AllMemberAggregationUsage Element (ASSL)

AllMemberName Element (ASSL)

AllowBrowsing Element (ASSL)

AllowDrillThrough Element (ASSL)

AllowDuplicateNames Element (ASSL)

AllowedSet Element (ASSL)

Application Element (ASSL)

AssociatedMeasureGroupID Element (ASSL)

AttributeAllMemberName Element (ASSL)

AttributeHierarchyDisplayFolder Element (ASSL)

AttributeHierarchyEnabled Element (ASSL)

AttributeHierarchyOptimizedState Element (ASSL)

AttributeHierarchyOrdered Element (ASSL)

AttributeHierarchyVisible Element (ASSL)

AttributeID Element (ASSL)

Audit Element (ASSL)

AutoRestart Element (ASSL)

BackColor Element (ASSL)

CacheMode Element (ASSL)

CalculationReference Element (ASSL)

CalculationType Element (ASSL)

CalendarEndDate Element (ASSL)

CalendarLanguage Element (ASSL)

CalendarStartDate Element (ASSL)

Caption Element (ASSL)

CaptionIsMdx Element (ASSL)

Cardinality Element (ASSL)

CaseCubeDimensionID Element (ASSL)

ClassifiedColumnID Element (ASSL)

Collation Element (ASSL)

ColumnID Element (ColumnBinding) (ASSL)

ColumnID Element (EventColumn) (ASSL)

Condition Element (ASSL)

ConnectionString Element (ASSL)

ConnectionStringSecurity Element (ASSL)

Content Element (ASSL)

CreatedTimestamp Element (ASSL)

CubeDimensionID Element (ASSL)

CubeID Element (ASSL)

CurrentStorageMode Element (ASSL)

CurrentTimeMember Element (ASSL)

DataAggregation Element (ASSL)

DatabaseID Element (ASSL)

DataSize Element (ASSL)

DataSourceID Element (ASSL)

DataSourceImpersonationInfo Element (ASSL)

DataSourceViewID Element (ASSL)

DataType Element (ASSL)

DbSchemaName Element (ASSL)

DbTableName Element (ASSL)

Default Element (ASSL)

DefaultMeasure Element (ASSL)

DefaultMember Element (ASSL)

DefaultScript Element (ASSL)

DefaultValue Element (ASSL)

DeniedSet Element (ASSL)

DependsOnDimensionID Element (ASSL)

Description Element (ASSL)

DimensionID Element (ASSL)

DiscretizationBucketCount Element (ASSL)

DiscretizationMethod Element (ASSL)

DisplayFlag Element (ASSL)

DisplayFolder Element (ASSL)

Distribution Element (ASSL)

Edition Element (ASSL)

Enabled Element (ASSL)

EndOfData Element (ASSL)

EstimatedCount Element (ASSL)

EstimatedPerformanceGain Element (ASSL)

EstimatedRows Element (ASSL)

EstimatedSize Element (ASSL)

EventID Element (ASSL)

Expression Element (ASSL)

Filter Element (Binding) (ASSL)

Filter Element (Trace) (ASSL)

FirstDayOfWeek Element (ASSL)

FiscalFirstDayOfMonth Element (ASSL)

FiscalFirstMonth Element (ASSL)

FiscalYearName Element (ASSL)

FoldingParameters Element (ASSL)

FontFlags Element (ASSL)

FontName Element (ASSL)

FontSize Element (ASSL)

ForceRebuildInterval Element (ASSL)

ForeColor Element (ASSL)

Format Element (ASSL)

FormatString Element (ASSL)

Goal Element (ASSL)

GranularityAttributeID Element (ASSL)

HideMemberIf Element (ASSL)

HierarchyID Element (ASSL)

HierarchyUniqueNameStyle Element (ASSL)

HoldoutActualSize Element

HoldoutMaxCases Element

HoldoutMaxPercent Element

HoldoutSeed Element

ID Element (ASSL)

IgnoreUnrelatedDimensions Element (ASSL)

ImpersonationInfo Element (ASSL)

ImpersonationInfoSecurity Element (ASSL)

ImpersonationMode Element (ASSL)

InstanceSelection Element (ASSL)

IntermediateCubeDimensionID Element (ASSL)

IntermediateGranularityAttributeID Element (ASSL)

InvalidXmlCharacters Element (ASSL)

Invocation Element (ASSL)

IsAggregatable Element (ASSL)

IsKey Element (ASSL)

Isolation Element (ASSL)

KeyDuplicate Element (ASSL)

KeyErrorAction Element (ASSL)

KeyErrorLimit Element (ASSL)

KeyErrorLimitAction Element (ASSL)

KeyErrorLogFile Element (ASSL)

KeyNotFound Element (ASSL)

KeyUniquenessGuarantee Element (ASSL)

KpiID Element (ASSL)

Language Element (ASSL)

LastProcessed Element (ASSL)

LastSchemaUpdate Element (ASSL)

LastUpdate Element (ASSL)

Latency Element (ASSL)

LogFileAppend Element (ASSL)

LogFileName Element (ASSL)

LogFileRollover Element (ASSL)

LogFileSize Element (ASSL)

ManagedProvider Element (ASSL)

ManufacturingExtraMonthQuarter Element (ASSL)

ManufacturingFirstMonth Element (ASSL)

ManufacturingFirstWeekOfMonth Element (ASSL)

MasterDatasourceID Element (ASSL)

Materialization Element (ASSL)

MaxActiveConnections Element (ASSL)

MdxMissingMemberMode Element (ASSL)

MeasureExpression Element (ASSL)

MeasureGroupID Element (ASSL)

MeasureID Element (ASSL)

MeasureQualificaton Element (ASSL)

MemberNamesUnique Element (ASSL)

MemberUniqueNameStyle Element (ASSL)

MembersWithData Element (ASSL)

MembersWithDataCaption Element (ASSL)

MimeType Element (ASSL)

MiningModelID Element (ASSL)

Name Element (ASSL)

NamingTemplate Element (ASSL)

NonEmptyBehavior Element (ASSL)

NotificationTechnique Element (ASSL)

NullKeyConvertedToUnknown Element (ASSL)

NullKeyNotAllowed Element (ASSL)

NullProcessing Element (ASSL)

OnlineMode Element (ASSL)

OptimizedState Element (ASSL)

Optionality Element (ASSL)

OrderBy Element (ASSL)

OrderByAttributeID Element (ASSL)

Ordinal Element (ASSL)

OverrideBehavior Element (ASSL)

PartitionID Element (ASSL)

Password Element (ASSL)

Path Element (ASSL)

PendingValue Element (ASSL)

PermissionSet Element (ASSL)

Persistence Element (ASSL)

Process Element (ASSL)

ProcessingMode Element (ASSL)

ProcessingPriority Element (ASSL)

ProcessingQuery Element (ASSL)

ProductName Element (ASSL)

Query Element (ASSL)

QueryDefinition Element (ASSL)

Read Element (ASSL)

ReadDefinition Element (ASSL)

ReadSourceData Element (ASSL)

RefreshInterval Element (ASSL)

RefreshPolicy Element (ASSL)

RelationshipType Element (ASSL)

RemoteDatasourceID Element (ASSL)

ReportingFirstMonth Element (ASSL)

ReportingFirstWeekOfMonth Element (ASSL)

ReportingWeekToMonthPattern Element (ASSL)

ReportServer Element (ASSL)

RequiresRestart Element (ASSL)

RoleID Element (ASSL)

Root Element (ASSL)

RootMemberIf Element (ASSL)

Schema Element (ASSL)

ScriptCacheProcessingMode Element (ASSL)

SilenceInterval Element (ASSL)

SilenceOverrideInterval Element (ASSL)

Slice Element (ASSL)

SolveOrder Element (ASSL)

Source Element (Binding) (ASSL)

Source Element (ComAssembly) (ASSL)

Source Element (Measure) (ASSL)

SourceAttributeID Element (ASSL)

SourceColumnID Element (ASSL)

State Element (ASSL)

Status Element (ASSL)

StatusGraphic Element (ASSL)

StopTime Element (ASSL)

StorageLocation Element (ASSL)

StorageMode Element (ASSL)

TableID Element (ASSL)

Target Element (ASSL)

TargetType Element (ASSL)

Text Element (ASSL)

Timeout Element (ASSL)

Trend Element (ASSL)

TrendGraphic Element (ASSL)

Trimming Element (ASSL)

Type Element (Action) (ASSL)

Type Element (Binding) (ASSL)

Type Element (ClrAssemblyFile) (ASSL)

Type Element (Dimension) (ASSL)

Type Element (DimensionAttribute) (ASSL)

Type Element (MeasureGroup) (ASSL)

Type Element (MeasureGroupAttribute) (ASSL)

Type Element (MiningStructureColumn) (ASSL)

Type Element (Partition) (ASSL)

Type Element (PerspectiveCalculation) (ASSL)

UnknownMember Element (ASSL)

UnknownMemberName Element (ASSL)

Usage Element (DimensionAttribute) (ASSL)

Usage Element (MiningModelColumn) (ASSL)

Value Element (ASSL)

Version Element (ASSL)

Visibility Element (ASSL)

Visible Element (ASSL)

VisualTotals Element (ASSL)

Write Element (ASSL)

WriteEnabled Element (ASSL)

Minimize

This topic has not yet been rated - Rate this topic

FormatString Element (ASSL)

SQL Server 2008

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


<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

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 CalculationProperty and Measure.

Reference

CalculationProperties Element (ASSL)

MdxScript Element (ASSL)

MdxScripts Element (ASSL)

Properties (ASSL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.