Trend Element (ASSL)

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

Syntax

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

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 element

Kpi

Child elements

None

Remarks

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.

See Also

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance