Automating the Processing of a Database
For most OLAP databases, updating the cubes with new values is a routine process that must be performed on a regular basis—monthly, weekly, nightly, or even hourly. Analysis Manager doesn’t provide any direct tools for automating the processing of databases. Manually carrying out routine tasks—particularly if you’ll be incrementally updating dimensions and cubes—can be an extremely tedious assignment.
Fortunately, Microsoft SQL Server 2000 has a facility for automating many different types of data manipulation activities, including processing OLAP components. The tool is DTS, which stands for Data Transformation Services. While you can use Analysis Services without using SQL Server, to use DTS, you must ...
Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
