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 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Analysis Services)

Analysis Services Scripting Language XML Elements (ASSL)

Properties

Account Element (ImpersonationInfo)

AccountType Element

ActionID Element

Administer Element

AggregateFunction Element

AggregationDesignID Element

AggregationFunction Element

AggregationID Element

AggregationInstanceSource Element

AggregationPrefix Element

AggregationStorage Element

AggregationType Element

AggregationUsage Element

Algorithm Element

Alias Element

AllowedRowsExpression Element

AllMemberAggregationUsage Element

AllMemberName Element

AllowBrowsing Element

AllowDrillThrough Element

AllowDuplicateNames Element

AllowedSet Element

Application Element

AssociatedMeasureGroupID Element

AttributeAllMemberName Element

AttributeHierarchyDisplayFolder Element

AttributeHierarchyEnabled Element

AttributeHierarchyOptimizedState Element

AttributeHierarchyOrdered Element

AttributeHierarchyVisible Element

AttributeID Element

Audit Element

AutoRestart Element

BackColor Element

CacheMode Element

CalculationReference Element

CalculationType Element

CalendarEndDate Element

CalendarLanguage Element

CalendarStartDate Element

Caption Element

CaptionIsMdx Element

Cardinality Element

CaseCubeDimensionID Element

ClassifiedColumnID Element

Collation Element

CollectionCaption Element

ColumnID Element (ColumnBinding)

ColumnID Element (EventColumn)

Condition Element

ConnectionString Element

ConnectionStringSecurity Element

Content Element

CreatedTimestamp Element

CubeDimensionID Element

CurrentStorageMode Element

CurrentTimeMember Element

DataAggregation Element

DatabaseID Element

DataSize Element

DataSourceID Element

DataSourceImpersonationInfo Element

DataSourceViewID Element

DataType Element

DbSchemaName Element

DbTableName Element

Default Element

DefaultMeasure Element

DefaultMember Element

DefaultScript Element

DefaultValue Element

DeniedSet Element

DependsOnDimensionID Element

Description Element

DimensionID Element

DiscretizationBucketCount Element

DiscretizationMethod Element

DisplayFlag Element

DisplayFolder Element

Distribution Element

Edition Element

Enabled Element

EndOfData Element

EstimatedCount Element

EstimatedPerformanceGain Element

EstimatedRows Element

EstimatedSize Element

EventID Element

Expression Element

Filter Element (Binding)

Filter Element (Trace)

FirstDayOfWeek Element

FiscalFirstDayOfMonth Element

FiscalFirstMonth Element

FiscalYearName Element

FoldingParameters Element

FontFlags Element

FontName Element

FontSize Element

ForceRebuildInterval Element

ForeColor Element

FormatString Element

Goal Element

GranularityAttributeID Element

HideMemberIf Element

HierarchyID Element

HierarchyUniqueNameStyle Element

HoldoutActualSize Element

HoldoutMaxCases Element

HoldoutMaxPercent Element

HoldoutSeed Element

ID Element

IgnoreUnrelatedDimensions Element

ImpersonationInfo Element

ImpersonationInfoSecurity Element

ImpersonationMode Element

InstanceSelection Element

IntermediateCubeDimensionID Element

IntermediateGranularityAttributeID Element

InvalidXmlCharacters Element

Invocation Element

IsAggregatable Element

IsKey Element

Isolation Element

KeyDuplicate Element

KeyErrorAction Element

KeyErrorLimit Element

KeyErrorLimitAction Element

KeyErrorLogFile Element

KeyNotFound Element

KeyUniquenessGuarantee Element

KpiID Element

Language Element

LastProcessed Element

LastSchemaUpdate Element

LastUpdate Element

Latency Element

LogFileAppend Element

LogFileName Element

LogFileRollover Element

LogFileSize Element

ManagedProvider Element

ManufacturingExtraMonthQuarter Element

ManufacturingFirstMonth Element

ManufacturingFirstWeekOfMonth Element

MasterDatasourceID Element

Materialization Element

MaxActiveConnections Element

MdxMissingMemberMode Element

MeasureExpression Element

MeasureGroupID Element

MeasureID Element

MeasureQualification Element

MemberNamesUnique Element

MemberUniqueNameStyle Element

MembersWithData Element

MembersWithDataCaption Element

MimeType Element

MiningModelID Element

Multiplicity Element

Name Element

NamingTemplate Element

NonEmptyBehavior Element

NotificationTechnique Element

NullKeyConvertedToUnknown Element

NullKeyNotAllowed Element

NullProcessing Element

OnlineMode Element

OptimizedState Element

Optionality Element

OrderBy Element

OrderByAttributeID Element

Ordinal Element

OverrideBehavior Element

PartitionID Element

Password Element

Path Element

PendingValue Element

PermissionSet Element

Persistence Element

Process Element

ProcessingMode Element

ProcessingPriority Element

ProcessingQuery Element

ProductName Element

Query Element

QueryDefinition Element

Read Element

ReadDefinition Element

ReadSourceData Element

RefreshInterval Element

RefreshPolicy Element

RelationshipType Element

RemoteDatasourceID Element

ReportingFirstMonth Element

ReportingFirstWeekOfMonth Element

ReportingWeekToMonthPattern Element

ReportServer Element

RequiresRestart Element

Root Element

RootMemberIf Element

ScriptCacheProcessingMode Element

SilenceInterval Element

SilenceOverrideInterval Element

Slice Element

SolveOrder Element

Source Element (Binding)

Source Element (ComAssembly)

Source Element (Measure)

SourceAttributeID Element

SourceColumnID Element

State Element

StatusGraphic Element

StopTime Element

StorageEngineUsed Element

StorageLocation Element

StorageMode Element

TableID Element

TargetType Element

Text Element

Timeout Element

Trend Element

TrendGraphic Element

Trimming Element

Type Element (Action)

Type Element (Binding)

Type Element (ClrAssemblyFile)

Type Element (Dimension)

Type Element (DimensionAttribute)

Type Element (MeasureGroup)

Type Element (MeasureGroupAttribute)

Type Element (MiningStructureColumn)

Type Element (Partition)

Type Element (PerspectiveCalculation)

UnknownMember Element

UnknownMemberName Element

Usage Element (DimensionAttribute)

Usage Element (MiningModelColumn)

Value Element

Version Element

Visibility Element

Visible Element

VisualTotals Element

Write Element

WriteEnabled Element

Minimize

This topic has not yet been rated - Rate this topic

OrderBy Element (ASSL)

SQL Server 2012

SQL Server 2005

Describes how to order the members contained in the attribute.


<DimensionAttribute>
   ...
      <OrderBy>...</OrderBy>
   ...
</DimensionAttribute>

Element Characteristics

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

Element Relationships

Relationship	Element
Parent element	DimensionAttribute
Child elements	None

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

Value	Description
Name	Order by the member name.
Key	Order by the member key.
AttributeKey	Order by the member key of the attribute specified in the OrderByAttributeID element of DimensionAttribute.
AttributeName	Order by the member name of the attribute specified in the OrderByAttributeID element of DimensionAttribute.

The enumeration that corresponds to the allowed values for OrderBy in the Analysis Management Objects (AMO) object model is OrderBy.

Reference

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.