How to automate MS OLAP cube processing?

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

How to automate/schedule MS OLAP cube processing? I have a scheduled job on sql server 7.0 transferring OLTP data into a DSS database. As it completes I would like my cube to re-process with the fresh data. Is there any OS command to call via xp_cmdshell or a possibility to schedule cube processing? Thanks, -YW

-- Anonymous, March 07, 2001

Answers

Yul,

Check out the Data Transformation Services Task Kit 1 at http://www.microsoft.com/sql/downloads/DTSKit.htm.

Here is the synopsis:

Microsoft SQL Server 7.0 OLAP Services users will benefit from the functionality made available in the Data Transformation Services (DTS) Task Kit 1 and OLAP Manager Add-in Kit (at http://www.microsoft.com/sql/downloads/OLAPaddin.htm).

The DTS Task Kit 1 contains the OLAP Services Processing Task. This task provides functionality that enables you to create and execute DTS packages that perform processing of one or more cubes or other OLAP Services objects. The first step is to use the new task to define your DTS package. Then you can run the package immediately, or schedule the package to run one or more times in the future.

Good Luck,

Eric

-- Anonymous, March 08, 2001


Moderation questions? read the FAQ