Create Data Analysis views

  • Article

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

You must create Data Analysis views if you want your Project Web Access users to be able to access your OLAP cube data.

Before you perform this procedure, confirm that:

  • You understand the guidance and requirements given in the article named View OLAP Cube data.

  • Your user account logged on to Project Web Access has the View OLAP Data global permission set to Allow.

To create a Data Analysis view

Use this procedure to create a Data Analysis view in Project Web Access. When completed, the Data Analysis view you create can be used by Project Web Access users who have permissions to the category to which you assign it.

Create a Data Analysis view

  1. Log on to Project Web Access as an administrator.

  2. Click Server Settings.

  3. In the Look and Feel section, click Manage Views.

  4. On the Manage Views page, click New View.

  5. On the New View page, in the Name and Type section, change the View Type to Data Analysis. After you make the selection, the page refreshes with new configuration options specific to the selected view type.

  6. In the Name and Type section, enter a name and description for the Data Analysis view.

  7. In the Analysis Services Settings section, specify information about the SQL Server Analysis Services instance that you are using to create your cube.

    • If you select the Default server option, you will use the instance of SQL Server Analysis Services you specified when you configured your cube build and configuration settings.

    • If you select the Custom server option, you have the option to select a different instance of SQL Server Analysis Services.

  8. In the Analysis Services Database to be created list, select the database that hosts the Project Server 2007 cube.

  9. In the Cube list, select the cube you want to use for this view.

    There are fourteen cubes to choose from that are automatically generated by the Cube Building Service (CBS). You can also create cubes that store additional data not created by the CBS. As a result, organizations can now report on Timesheet, Issues, Risks, and Deliverables data, in addition to Project and Resource information.

  10. In the View Options section, in the Show Data as options, choose how you want the data to be displayed:

    • PivotChart only

    • PivotTable only

    • PivotTable with PivotChart

  11. Select Show Field List if you want the field list to be visible when the view is used.

    Note

    Allow this option if you want the users of the view to be able to select additional fields.

  12. Select Show Toolbar if you want the toolbar to be visible when the view is being used.

    Note

    This should only be required by power users who need to add subtotals and other advance features.

  13. In the View Definition section, pick default measures and dimensions from the PivotField List and add them to the PivotTable or PivotChart.

  14. Choose the data you want to display in the view and drag it to the row, column, or filter field in which you want it to appear. You can select multiple measures and dimensions by pressing the CTRL key while you make selections.

  15. In the Security categories section, select the categories that you want to make available to this view.

    Note

    You can manage access to categories by users and groups though the Security section of Project Web Access Server Settings. Note that enabling access to a Data Analysis view through a category allows users to see report data for projects and resources that they might not otherwise have permission for. For example, User 1 does not have access to Project 1. However, OLAP data from Project 1 is displayed in Data Analysis View 1. Data Analysis View 1 is added to Category 1. If User 1 is included in Category 1 as a user or as a member of a group, that user will be able to see the report data on Project 1 through Data Analysis View 1.

  16. Click Save to create the view.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Project Server 2007.