Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

AggregationPrefix Element (ASSL)

Defines the common prefix to be used for aggregation names throughout the associated parent element.


<Cube> <!-- or Database, MeasureGroup, Partition -->
   ...
   <AggregationPrefix>...</AggregationPrefix>
   ...
</Database>

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 elements

Cube, Database, MeasureGroup, Partition

Child elements

None

Aggregation prefixes generate aggregation names in Microsoft SQL Server 2005 Analysis Services (SSAS), and also generate table names in the relational database for aggregations stored in a relational OLAP (ROLAP) partition.

A fully expanded aggregation name has the following parts:

<DatabasePrefix><CubePrefix><MeasureGroupPrefix><PartitionPrefix><AggregationID>

The first four parts of the aggregation name make up the aggregation prefix. The user provides the first four parts:

  • DatabasePrefix represents the value of the AggregationPrefix element associated with a Database element.
  • CubePrefix represents the value of the AggregationPrefix element associated with a Cube element.
  • MeasureGroupPrefix represents the value of the AggregationPrefix element associated with a MeasureGroup element.
  • PartitionPrefix represents the value of the AggregationPrefix element associated with a Partition element.

The fifth part of the name, AggregationID, is a system-defined ID, and users have no control over this part of the name.

The elements that correspond to the parents of AggregationPrefix in the Analysis Management Objects (AMO) object model are Cube, Database, MeasureGroup, and Partition.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.