Share via

Implementations

  • Article

This section describes implementations of cube extensions for each of the three scenarios in the Portfolio Analyzer OLAP Extensions Solution Starter. Any one, or all three, of the extensions can be added to the Portfolio Analyzer in Microsoft® Office Project Server 2003, so that cube generation will automatically include the additional data. The following sections explain how to develop, install, and test each of the samples.

  • Adding a Pay Period Dimension introduces the steps in adding a dimension to the cube. The sample uses a simple example of the UserStagingTablesUpdate breakout function, and then shows how to manually update the cube using the SQL Server Analysis Manager.
  • Adding Windows SharePoint Services Data for Risk Analysis summarizes the steps in extending the cube with task issues and risks from data entered in a Microsoft® Windows® SharePoint™ Services site. The sample includes a more complex implementation of the UserStagingTablesUpdate breakout function. The sample also uses the UserOLAPUpdate breakout function with Decision Support Objects (DSO) calls to SQL Server Analysis Services to programmatically update the cube.
  • Adding Task Information for Earned Value Analysis summarizes the steps to include enterprise task outline codes and task earned value data from Project Server with the standard cube parameters for analyzing earned value. The custom code in UserStagingTablesUpdate and UserOLAPUpdate includes functions that create and add calculated members to cube dimensions.

Installing Multiple Extensions

The Portfolio Analyzer OLAP Extensions Solution Starter includes three separate implementations of the breakout functions and a separate test application for each of the implementations. After you install the download, your installation directory will contain the directories PayPeriodDimension, TaskEarnedValue, and TaskIssuesRisks. The Microsoft® Visual Basic® project group in each directory is independent.

There can be only one DLL with the breakout functions registered on the Project Server computer, so that generation of the cube automatically includes the extended functions. If you want to install more than one of the extensions, you will need to combine the custom code for the breakout functions into one MSPOLAPBREAKOUT project, compile that project into the MSPOLAPBREAKOUT.dll, and then register that DLL on the Project Server computer.

You can use each OLAP extension independently with its test application. For example, you can follow the steps to compile, install, and test the issues and risks extension, and then later compile and use the test application with the task earned value extension. However, if you register MSPOLAPBREAKOUT.dll for the task earned value sample, that will replace the previously registered functions for the issues and risks extension.

You can create and install as many OLAP extensions as you want. For Portfolio Analyzer to include them in automatic cube updates, all of the extensions have to be compiled into one MSPOLAPBREAKOUT.dll.

For a complete list of the files and directories in the download, see Solution Starter Files.