Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Nov 1, 1999

DSOCtrl Overview - Page 2

By Darren Green

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.


MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM