An object of ClassType clsDatabaseCommand provides a specific implementation of the Decision Support Objects (DSO) Command interface. This object provides collections, methods, and properties through the Command interface.
An object of ClassType clsDatabaseCommand encapsulates a user-defined command that is automatically executed on the Microsoft® SQL Server™ 2000 Analysis Services client when the database containing the command is accessed. You add a command to a database by adding it to the database's Commands collection. Such commands include calculated members, named sets, library references, and others.
Use the following code to create an object of ClassType clsDatabaseCommand:
'Assume an object (dsoServer) of ClassType clsServer exists 'with an existing database Dim dsoDB As DSO.MDStore 'Database Dim dsoCmd As DSO.Command 'Command Set dsoDB = dsoServer.MDStores(1) Set dsoCmd = dsoDB.Commands.AddNew("DBCmd1")