Analysis Services (SQL Server 2005)

PowerDesigner allows you to retrieve multiple dimension objects in a PDM in order to build cubes, and to create a new multiple-dimension diagram. From this diagram, you can generate cubes to a Microsoft SQL Server 2005 Analysis Server (SSAS).To enable analysis services, select Tools > General Options, click the Add-ins category, select the Microsoft SQL Server 2005 Analysis Services add-in (PowerDesigner.AddIn.Pdm.SQLServer.dll), and then click OK to install it and return to the model.

Note: In order to use the analysis services add-in to generate and reverse-engineer cubes, you must have installed the SQL Server 2005 Management Tools client component.

Specifying a Data Source for Cubes
Before generating cubes, you must define a data source with an OLE DB connection that will specify from where the cubes will be populated.
Generating Cubes for Microsoft SQL Server 2005
The Microsoft SQL Server 2005 Analysis Services add-in enables the generation of cubes.
Reverse Engineering Microsoft SQL Server 2005 Cubes
The Microsoft SQL Server 2005 Analysis Services add-in enables the reverse engineering of cubes.

Parent topic: Microsoft SQL Server