This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

An object of ClassType clsCubeCommand provides a specific implementation of the Decision Support Objects (DSO) Command interface. This object provides collections and properties through the Command interface. There are no methods associated with an object of ClassType clsCubeCommand.


An object of ClassType clsCubeCommand encapsulates a user-defined command automatically executed on the Microsoft® SQL Server™ 2000 Analysis Services client when the cube containing the command is accessed. You add a command to a cube by adding it to the cube's Commands collection. Such commands include calculated members, named sets, library references, and others.

For more information, see Introducing Decision Support Objects.


Creating an Object of ClassType clsCubeCommand

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

'Assume an object (dsoServer) of ClassType clsServer exists
'with existing database and cube
Dim dsoDB As DSO.MDStore      'Database
Dim dsoCube As DSO.MDStore   'Cube
Dim dsoCmd As DSO.Command   'Command

Set dsoDB = dsoServer.MDStores(1)
Set dsoCube = dsoDB.MDStores(1)
Set dsoCmd = dsoCube.Commands.AddNew("CubeCmd1")