Overview | Reference | Examples
Methods
ConnectCube | |
Use this method to connect to a MS OLAP cube. Errors will be raised for invalid parameters. Use prior to retrieving a cube specific property. | |
object.ConnectCube [Server], [Database], [Cube] | |
Server | MS OLAP Services Server Name |
Database | OLAP Database Name |
Cube | Cube Name |
ProcessCube | |
This obviously processes the cube. If connection has not been made, it will be done now using ConnectCube method internally. In addition the processing type can be specified. | |
object.ProcessCube [Server], [Database], [Cube], [ProcessType] | |
Server | MS OLAP Services Server Name |
Cube | OLAP Database Name |
Cube | Cube Name |
ProcessType | Process Types |
ConnectDimension | |
Use this method to connect to a shared dimension. Errors will be raised for invalid parameters. Use prior to retrieving a dimension specific property. | |
object.ConnectDimension [Server], [Database], [Dimension] | |
Server | MS OLAP Services Server Name |
Database | OLAP Database Name |
Dimension | Shared Database Dimension Name |
ProcessDimension | |
This obviously processes a shared dimension. If connection has not been made, it will be done now using ConnectDimension method internally. In addition the processing type can be specified. | |
object.ProcessDimension [Server], [Database], [Dimension], [ProcessType] | |
Server | MS OLAP Services Server Name |
Database | OLAP Database Name |
Dimension | Shared Database Dimension Name |
ProcessType | Process Types |
ProcessAllDimensions | |
Used to process all shared dimensions within a database. This interrogates the database to find all shared dimensions. The ProcessDimension method is called internally for each dimension found. The processing type specified will be applied to all dimensions found. | |
object.ProcessAllDimensions [Server], [Database], [ProcessType] | |
Server | MS OLAP Services Server Name |
Database | OLAP Database Name |
ProcessType | Process Types |
UnInitialize | |
Use this method to close the connection with the server, but not destroy the object. | |
object.UnInitialize |
Properties
Cube | |
Returns or sets the Cube name for the object. (Not validated until required by a method) | |
object.Cube [=value] | |
DataType | String |
Modifiable | Read/Write |
Database | |
Returns or sets the Database name for the object. (Not validated until required by a method) | |
object.Database [=value] | |
DataType | String |
Modifiable | Read/Write |
Dimension | |
Returns or sets the current database dimension for the object. (Not validated until required by a method) | |
object.Dimension | |
DataType | String |
Modifiable | Read/Write |
LastProcessed | |
Returns the date and time the cube/dimension was last processed. | |
object.LastProcessed | |
DataType | Date Time |
Modifiable | Read Only |
ProcessDuration | |
Returns the time taken to process the cube/dimension(s). Only available after ProcessCube, ProcessDimension, or ProcessAllDimensions has been executed, otherwise returns zero. | |
object.ProcessDuration | |
DataType | Date Time |
Modifiable | Read Only |
ProcessType | |
Returns or sets the process type for the object. Must be a valid processType. | |
object.ProcessType [=value] | |
DataType | DSOCtrl.ProcessType |
Modifiable | Read/Write |
Server | |
Returns or sets the Server for the object. (Not validated until required by a method) | |
object.Server [=value] | |
DataType | String |
Modifiable | Read/Write |
Constants
ProcessType | |
This is used to define the process performed by one of the Process methods. This is a replica of the Microsoft DSO ProcessTypes enumerator. | |
Constant | Value |
processDefault | 0 |
processFull | 1 |
processRefreshData | 2 |
Only the above three DSO values are supported. Please see Microsoft SQL Server OLAP Services Production Documentation for full descriptions. |