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.
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")