Step 3: Adding the New Dimension

In Step 1, you created the staging tables for the Pay Period dimension and, in Step 2, added them to the MSP_ASSN_FACT cube in Analysis Manager, linked the Pay Period dimension to the Fact table, and processed the cube. The third and final step is to add the new dimension to your virtual MSP_PORTFOLIO_ANALYZER cube and reprocess the cube.

To add the new dimension to the virtual cube:

1. In SQL Server Analysis Manager, right-click MSP_PORTFOLIO_ANALYZER, and click Edit.
2. In the Virtual Cube Editor, right-click MSP_PORTFOLIO_ANALYZER, and then click Edit Structure (Wizard).
3. In the Virtual Cube Wizard, click Next, click Next again, and, on the Select the dimensions for the virtual cube page of the wizard, double-click Pay Period to add the dimension to your list of selected dimensions in the right-hand pane.
4. Click Next to process and create the MSP_PORTFOLIO_ANALYZER virtual cube. When you see the message Processing completed successfully in the Process dialog box, click Close.
5. Close the Virtual Cube Editor and go back to the Analysis Manager main window.

Note  After you have created this new dimension, it will be processed each time you process the cube.

To use the Pay Period dimension in a Portfolio Analyzer chart, see Using the Pay Period Dimension.

Summary

The first sample in the Portfolio Analyzer OLAP Extensions solution starter showed how to add a dimension to the cube. You used the UserStagingTablesUpdate breakout function to add data from Microsoft® Office Project Server 2003, and then used the SQL Server Analysis Manager to manually update the cube and add the new dimension to the virtual cube.

The other two solution starter samples show how to update the cube and add new dimensions and measures programmatically, and how to add new views to Portfolio Analyzer.

• Adding Windows SharePoint Services Data for Risk Analysis
• Adding Task Information for Earned Value Analysis