Saturday, July 4, 2009

SQL Server 2005 Analysis Services with the Project Server 2007 : Part 1

The Microsoft Office Project Server 2007 Cube Building Service is a reporting feature that allows to perform complex analysis on project data. It uses SQL Server Analysis Services to create an online analytical processing (OLAP) database containing several cubes that are used for data analysis reporting. It allows for data cubes to be built from selections within the Reporting database. This article describes Configuration settings for cube building process।

Installation
In order for SQL Server 2005 Analysis Services to function correctly with the Office Project Server 2007 Cube Building Service, you must install following Component

  • SQL Server 2005 Service Pack 1 or higher.
  • DSO client components - These components can be downloaded from the Feature Pack for Microsoft SQL Server 2005 (
http://go.microsoft.com/fwlink/?LinkId=87078&clcid=0x409).
  • Microsoft SQL Server Native Client (sqlncl.msi)
  • Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xm.msi)
  • Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi)
  • Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider (SQLServer2005_ASOLEDB9.msi) - This component can be downloaded from the Feature Pack for Microsoft SQL Server 2005(http://go.microsoft.com/fwlink/?LinkId=87078&clcid=0x409).
  • Microsoft Office Web Components - Users are prompted to download the ActiveX components to their computer when they first build a Data Analysis view or when they attempt to use such a view. The Microsoft Office Web Components are a collection of ActiveX components that allows Project Web Access users to use PivotTable and Chart components to access OLAP cube data. This component can be downloaded from Office XP Tool: Web Components (http://go.microsoft.com/fwlink/?LinkId=87125&clcid=0x409).


  • ---------------------------------

    Part 2 >>

    No comments: