Analysis Services (SQL Server)

PowerDesigner allows you to retrieve and generate Microsoft SQL Server 2005 Analysis Server (SSAS) cubes using the Microsoft SQL Server 2005 Analysis Services add-in. You must have installed the SQL Server 2005 Management Tools client component.

To enable analysis services in PowerDesigner, 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.

• 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.