Export (0) Print
Expand All


SQL Server 2000


  New Information - SQL Server 2000 SP3.

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.

Security Note  Commands can be the source of security vulnerabilities; they can invoke system or user-defined functions without user knowledge or intervention and may contain security credentials stored in plain text. Before implementing commands, review the command text for security issues.

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")
© 2014 Microsoft