AggregationPrefix

The AggregationPrefix property of the MDStore interface contains the prefix associated with an aggregation in an MDStore object.

Applies To
clsAggregation clsDatabase
clsCube clsPartition

Aggregation prefixes are used to generate aggregation names, and are used for table names in the relational database.

A fully-expanded aggregation name has four parts:

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

The first three parts of the name are user-provided and make up the aggregation prefix; the fourth part of the name is a system-defined ID over which users have no control. The first two prefixes (DatabasePrefix and CubePrefix) are optional. CubePrefix is used only if PartitionPrefix begins with “+”, and DatabasePrefix is used only if CubePrefix begins with “+”. For example, if PartitionPrefix is “+_Partition1”, CubePrefix is “+_1995”, and DatabasePrefix is “Sales”, the aggregation prefix is “Sales_1995_Partition1”.

Data Type

String

Values
Range
Cannot exceed 22 characters (exclusive of any plus signs).
Default

 

Class Default Value
clsDatabase None.
clsCube None.
clsPartition If not provided by user, a unique name is derived from the parent cube name and partition name.
clsAggregation Parent partition’s name

Access

Access to an aggregation prefix depends on the class of the associated MDStore object.

MDStore object class type Access
clsCube R/W
clsDatabase R
clsPartition R/W
clsAggregation R

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.