次の方法で共有


clsDatabaseDimension

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

An object of ClassType clsDatabaseDimension provides a specific implementation of the Decision Support Objects (DSO) Dimension interface. This object provides collections, methods, and properties through the Dimension interface.

解説

Database dimensions can be shared or private. A shared database dimension can be associated with any number of cubes, but a private database dimension can be associated with only a single cube. When a database dimension is associated with a cube, it is automatically associated with the cube's partitions and aggregations, if there are any.

All dimensions, shared and private, are created in a database object and stored in the database object's Dimensions collection. Private dimensions are identified by incorporating the names of the cubes to which they are private into the names of the dimensions. For example, a dimension named Cube1^PrivateDimension is private to Cube1 because its name begins with Cube1 followed by the caret (^) character.

使用例

Use the following code to create an object of ClassType clsDatabaseDimension:

' Assume an object (dsoDB) of ClassType clsDatabase exists
Dim dsoDim As DSO.Dimension
Set dsoDim = dsoDB.Dimensions.AddNew("MyDim")

参照

関連項目

Collections, clsDatabaseDimension
Dimension Interface
Methods, clsDatabaseDimension
Properties, clsDatabaseDimension

その他の技術情報

Dimensions (MDX)

ヘルプおよび情報

SQL Server 2005 の参考資料の入手