Analysis Services (SQL Server 2000)

The OLAP Services feature from SQL Server v7.0 is called Analysis Services in SQL Server 2000. To enable analysis services, select Tools > General Options, click the Add-ins category, select the Microsoft Analysis Services add-in (PdMsOlap.dll), and then click OK to install it and return to the model.

For information about analysis services in SQL Server 2005, see Microsoft SQL Server 2005 Analysis Services.

Analysis Services provide the following capabilities:

Source data for multidimensional cubes resides in relational databases where the data has been transformed into a star or snowflake schema typically used in OLAP data warehouse systems. Analysis Services can work with many relational databases that support connections using ODBC or OLE DB.

DSO uses hierarchically arranged groups of objects to define basic elements of Analysis Services data storage, as implemented by the Analysis server:



The following table lists the mappings between the objects contained within the DSO and PowerDesigner PDM metamodels:

DSO Object

PowerDesigner PDM Object

clsDatabase

Model

(Each model corresponds to a DSO Database.)

clsDataSource

Data source

ClsDatabaseDimension

Dimension

(As in the DSO model, PowerDesigner dimensions are shared among cubes.)

clsCube

Cube

(Cubes managed by PowerDesigner are only local cubes.)

clsCube

Fact

(A Fact corresponds to a DSO cube in order to store measures.)

clsCubeMeasure

Measure

clsDatabaseDimension

Dimension hierarchy

(Each dimension hierarchy is generated as a DSO Database Dimension. Attributes of a dimension hierarchy define levels of the corresponding DatabaseDimension.)

clsDatabaseLevel clsCubeLevel

Dimension attribute

(Attributes of a dimension or dimension hierarchy define levels in a database dimension.)

clsCubeDimension

Cube dimension association

(In DSO, when the name of a Cube Dimension corresponds to the name of a Database Dimension, the Cube Dimension is automatically associated with the Database Dimension to be shared between cubes.)