次の方法で共有


AggregationPrefix (MDStore Interface)

ms133256.note(ja-jp,SQL.90).gifメモ :
この機能は、Microsoft SQL Server の次のバージョンで削除されます。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションはできるだけ早く修正してください。

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

Applies To:clsAggregation, clsCube, clsDatabase, clsPartition

Data Type

String (maximum length 50 characters, exclusive of any plus signs)

Access

Access depends on the value of the ClassType property of the object.

Class type Access

clsCube

R/W

clsDatabase

R/W

clsPartition

R/W

clsAggregation

R

解説

The default value for this property depends on the value of the ClassType property of the object.

Class type 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

The name of the parent partition.

Aggregation prefixes are used to generate aggregation names, and they 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 provided by the user 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 a plus sign (+), and DatabasePrefix is used only if CubePrefix begins with a plus sign. For example, if PartitionPrefix is +_Partition1, CubePrefix is +_1995, and DatabasePrefix is Sales, the aggregation prefix is Sales_1995_Partition1.

参照

関連項目

MDStore Interface

ヘルプおよび情報

SQL Server 2005 の参考資料の入手