Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Analysis Services)
XMLA Reference
XML Elements (XMLA)
Properties
AllowOverwrite Element
ApplyCompression Element
Attribute Element
AttributeName Element
Attributes Element
Axes Element
AxesInfo Element
Axis Element
AxisInfo Element
BackupRemotePartitions Element
Binding Element
Bindings Element
CancelAssociated Element
Capability Element
Caption Element
Cell Element
Cell Element (MDDataSet)
CellData Element
CellInfo Element
CellOrdinal Element
Command Element
ConnectionID Element
ConnectionString Element
CrossProduct Element
Cube Element
Cube Element (OlapInfo)
CubeID Element
CubeInfo Element
CubeName Element
CustomRollup Element
CustomRollupProperties Element
Database Element
DatabaseID Element
DatabaseName Element
DataSource Element
DataSourceID Element
DataSourceType Element
DataSourceView Element
DbSchemaName Element
DbStorageLocation Element
DbTableName Element
DeleteWithDescendants Element
Description Element
Dimension Element
DisplayInfo Element
Error Element
ErrorCode Element
ErrorConfiguration Element
Exception Element
File Element
Folder Element
Folders Element
HelpFile Element
HierarchyInfo Element
ID Element
Keys Element
Key Element
Language Element
LastDataUpdate Element
LastSchemaUpdate Element
LName Element
LNum Element
Location Element
Locations Element
Materialize Element
MeasureGroupID Element
Member Element
Members Element
Message Element
Messages Element
Mode Element
MoveWithDescendants Element
Name Element
Name Element (Parameter)
New Element
Object Element
Object Element (Dimension)
ObjectDefinition Element
OlapInfo Element
Optimization Element
Original Element
Parallel Element
Parameter Element
Parameters Element
ParentObject Element
PartitionID Element
Password Element
Properties Element
PropertyList Element
Queries Element
Query Element
ReadWriteMode Element
RequestType Element
RestrictionList Element
Restrictions Element
results Element
return Element
Role Element
root Element
row Element
Security Element
SessionID Element
SkippedLevels Element
Source Element
Source Element (Error)
Source Element (Synchronize)
Sources Element
SPID Element
Steps Element
Storage Element
SynchronizeSecurity Element
TableNotification Element
TableNotifications Element
Target Element
Time Element
Translation Element
Translations Element
Tuple Element
Tuples Element
Type Element
UName Element
UnaryOperator Element
Value Element
Value Element (Parameter)
Warning Element
Where Element
WritebackTableCreation Element
FolderPosition Element
DefaultDetailsPosition Element
DisplayKeyPosition Element
CommonIdentifierPosition Element
IsDefaultMeasure Element
IsDefaultImage Element
SortPropertiesPosition Element
ContextualNameRule Element
EditionId Element
ServerMode Element
ProductLabel Element
Expand Minimize
This topic has not yet been rated - Rate this topic

Optimization Element (XMLA)

SQL Server 2012

Specifies the optimization threshold percentage used by the DesignAggregations command to design aggregations.

Xml
Copy 

<DesignAggregations>
   ...
   <Optimization>...</Optimization>
   ...
</DesignAggregations>

Characteristic

Description

Data type and length

Double

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Relationship

Element

Parent elements

DesignAggregations

Child elements

None
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.