Video demo: Using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

This two-part video demonstration walks through the steps necessary to configure the Microsoft Office Project Server 2007 cube building services for use with SQL Server Analysis Services 2005.

Part I of the video demonstrates the steps required to create the Analysis Services repository, including:

  • Creating the repository database in SQL Server 2005

  • Creating a database login for the OLAP Users group

  • Making the OLAP Users group login a db_owner of the repository database

  • Creating the required schema for the database

  • Configuring the necessary repository connection parameters in Analysis Services

Screenshot of video

Watch the video (http://go.microsoft.com/fwlink/?LinkId=168546). To download a copy of the file, right-click the link, and then click Save Target As.

Part II of the video demonstrates the required Office Project Server 2007 configuration steps, including:

  • Installing Office Project Server 2007 prerequisites:

    • SQL Server Native Client

    • SQL Server 2005 Management Objects Collection

    • SQL Server 2005 Backward Compatibility Components

  • Configuring account settings:

    • Granting db_datareader permissions for the Analysis Services service account on the Office Project Server 2007 reporting database

    • Adding the shared services provider account to the OLAP Users group

    • Adding the shared services provider account as a server role member in Analysis Services

  • Installing on each client computer:

    • Microsoft Office Web Components

    • SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Screenshot of video

Watch the video (http://go.microsoft.com/fwlink/?LinkID=168547). To download a copy of the file, right-click the link, and then click Save Target As.