SQL Server
United States (English) Sign in
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)
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

Trend Element (ASSL)

SQL Server 2008

Contains a Multidimensional Expressions (MDX) expression that returns a trend indicator for a Kpi element.

Xml
Copy 

<Kpi>
   ...
   <Trend>...</Trend>
   ...
</Kpi>

Characteristic

Description

Data type and length

String

Default value

None

Cardinality

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

Relationship

Element

Parent element

Kpi

Child elements

None

The Trend element contains an MDX expression that evaluates to a number between -1 and 1.

The element that corresponds to the parent of Trend in the Analysis Management Objects (AMO) object model is Kpi.

Did you find this helpful?
(1500 characters remaining)

Community Additions

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