Using the OLE DB Command Object

When you have an MDX statement that represents the desired dataset, the next step is to submit the query for execution. OLE DB for OLAP uses the existing infrastructure in OLE DB for query execution. This infrastructure takes the form of the command object. The command object has an interface called ICommandText, which has several methods that, when taken together, provide the ability to execute queries:

• ICommand::SetCommandText associates the query string with the command object.
  
  
• ICommand::GetCommandText gets the query string associated with the command object.
  
  
• ICommand::Execute executes the query associated with the command object.
  
  
• ICommand::Cancel attempts to cancel a currently executing query.
  
  
• ICommand::GetDBSession gets an interface pointer to the session object that created this command object.

Execution of an MDX statement usually results in the creation of a dataset, unless the application chooses to ask for a rowset object to be created (which represents a flattened dataset). For more information, see “Flattening a Dataset to Produce a Rowset.”