次の方法で共有


clsCubeDimension

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

An object of ClassType clsCubeDimension provides an implementation of the Decision Support Objects (DSO) Dimension interface that is specific to dimensions within a cube. This object provides collections and properties through the Dimension interface. There are no methods associated with an object of ClassType clsCubeDimension.

解説

The primary difference between a database dimension and a cube dimension is that in a cube dimension, certain properties that are inherited from the database dimension can be overridden by changing their values. For example, the IsVisible property can be overridden on a cube dimension, but the StorageType property cannot.

To define a cube dimension, you add a reference to a dimension that exists within a database to the Dimensions collection of the cube. A shared database dimension can be associated with multiple cube dimensions; a private database dimension can be associated with only one cube dimension. In both cases, the database dimension is automatically associated with the cube's partitions and aggregations, if there are any.

使用例

Use the following code to create a clsCubeDimension object:

'Assume an object (dsoServer) of ClassType clsServer exists
'with an existing database and cube
Dim dsoDB As MDStore
Dim dsoCube As MDStore
Dim dsoCubeDim As DSO.Dimension
Set dsoDB = dsoServer.MDStores("FoodMart")
Set dsoCube = dsoDB.MDStores("Sales")
'"Employees" is an existing database dimension
Set dsoCubeDim = dsoCube.Dimensions.AddNew("Employees")

参照

関連項目

Collections, clsCubeDimension
Dimension Interface
Properties, clsCubeDimension

ヘルプおよび情報

SQL Server 2005 の参考資料の入手