Configure the build settings for the cube database

  • 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

Before you perform this procedure, confirm that:

  • You have read the article named Specify build and configuration settings for the cube database.

  • The SQL Server Analysis Services server and Analysis Services database name you are specifying for these procedures are correct.

  • You have determined a date range that best captures the data you want your users to see.

  • You have determined an update time that affects your users to a minimal degree (for example, 12:00AM Saturday), if you are updating your cube data at scheduled intervals.

To specify Analysis Services settings

First, specify where SQL Server Analysis Services resides.

Specify Analysis Services settings

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

  2. Click Server Settings.

  3. In the Cube section, click Build Settings.

  4. On the Cube Building Settings page, in the Analysis Services Settings section specify the information for the following fields:

    • Analysis Services Server   Enter the name of the server on which SQL Server Analysis Services is running.

    • Analysis Services Database to be created   Enter the name of the database that is used by Analysis Services. Also know as the Cube name. If the database does not exist, it will be automatically created.

    • Extranet URL   Enter the Extranet URL for users that will be accessing the OLAP cube and Portfolio Analysis views from outside the Intranet.

    • Description   Enter more information or comments about the cube.

  5. If you are done making changes on this page, click Save to save the settings. Alternatively, click Save and Build Now to save your settings and build the cube.

    Note

    If your installation is running multiple Project Server 2007 sites that share a common SQL Server Analysis Services server, we recommended that you adopt clear naming standards to differentiate each site's cubes.

To configure the database date range

Next, set the date range of data you want included in the cube.

Configure the database date range

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

  2. Click Server Settings.

  3. In the Cube section, click Build Settings.

  4. On the Cube Building Settings page, in the Database Date Range section, select one of the following options:

    • Use the earliest project start date and the latest project finish date   This option will build a cube of all the data stored in tasks on the Project Server.

      Note

      The larger this range, more data that will be placed into the cubes, therefore increasing cube build times. Use a more constrained time range if cube build times exceed your requirements.

    • Use the following last and next time units to calculate the date range at the time the cube is built   This option sets up a rolling time frame that will be updated each time the cube is built.

      In the Last box, enter the time period for data that you want to include in the cube before the cube is built.

      In the Next box, enter the time period for data that you want to be included in the cube after the cube is built.

    • Use the fixed date range specified below   This option will create a cube from the date range starting at the From date ending at the To date.

      In the From field, enter the start date for which data will be included in the cube.

      In the To field, enter the end date for which data will be included in the cube.

  5. If you are done making changes on this page, click Save to save the settings. Alternatively, click Save and Build Now to save your settings and build the cube.

To configure the update frequency of the cube

Next, configure how often you want the cube updated.

Configure the cube update frequency

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

  2. Click Server Settings.

  3. In the Cube section, click Build Settings to open the Build Settings page.

  4. In the Cube Update Frequency section, select the Update Periodically check box if you want the cube to be automatically updated. The Scheduling service rebuilds the cube based on the date ranges specified later in this procedure.

  5. If the cube build job was not executed due to the Project Queue service not functioning at the scheduled time, select Immediately retry the cube update if scheduled time fails because of queue down time.

  6. In the Update every boxes, specify the time period for updating the cube. For example, 5 days, 2 weeks, or 1 month.

  7. In the Start date box, enter the date for the next cube build. You can use the Calendar icon to select a date.

  8. In the Start time box, enter the time the next cube will start to build.

  9. If you are done making changes on this page, click Save to save the settings. Alternatively, click Save and Build Now to save your settings and build the cube.

    Note

    While the cube is building, updates to the Reporting database are queued. We recommend that you set a frequency appropriate to the update patterns (especially with project publish jobs), of your Project Server 2007 site.

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.

See Also

Concepts

Specify build and configuration settings for the cube database
Managing the Cube Building Service in Project Server 2007
Configure Office Project Server 2007 to use the Cube Building Service