Export (0) Print
Expand All

Create OLAP cubes in Project Server 2013

Project Server 2013
 

Applies to: Project Server 2013

Topic Last Modified: 2013-12-18

Summary: Manage OLAP cubes by using the OLAP Database Management page in Central Administration.

To create an OLAP cube, you must be a Project Server service application administrator. Perform the following procedure to create a new OLAP cube.

To create an OLAP cube
  1. In Central Administration, in the Application Management section, click Manage service applications.

  2. Click the Project Server service application.

  3. Point to the Project Web App instance where you want to build the cube, click the arrow that appears, and then click Manage.

  4. On the Server Settings page, in the Queue and Database Administration section, click OLAP Database Management.

  5. On the OLAP Database Management page, click New.

  6. Configure the settings on the OLAP Database Build Settings page:

     

    Setting Description

    Analysis Services Server

    The name of the instance of SQL Server Analysis Services (SSAS) where you want to build the cube.

    Analysis Services Database to be created

    The name of the database that you want to create.

    Extranet URL

    The URL for the extranet site.

    Description

    A description of this OLAP cube.

    Project Departments

    If you have projects assigned to departments, you have the option of selecting the departments that you want to have included in the cube. If no department is selected, then no departmental filtering occurs.

    The selection of departments available is controlled by the Department custom lookup table.

    Resource Departments

    If you have resources assigned to departments, you have the option of selecting the departments that you want to have included in the cube. If no department is selected, then no departmental filtering occurs.

    The selection of departments available is controlled by the Department custom lookup table.

    Use the earliest project start date and the latest project finish date

    Select this option if you want to base the date range of the cube on the earliest start date of any project and the latest finish date of any project.

    Use the following last and next time units to calculate the date range at the time that the OLAP database is built

    Select this option if you want the date range to be configured automatically based on a delta from the date on which the cube is built. In the Last and Next boxes, type the number of days, weeks, or months that you want to use for the delta.

    Use the fixed date range specified below

    Select this option if you want to use a fixed date range. In the From and To boxes, type the dates that you want to use.

    Update periodically

    Select this option if you want to schedule an update frequency. If this option is not selected, the cube is not updated automatically.

    Immediately retry the OLAP database update if scheduled time fails because of queue down time

    If the scheduled cube build fails because the queue is not available, selecting this option causes the build job to start automatically when the queue becomes available instead of waiting for the next scheduled time.

    Update every

    Select the number of hours, days, weeks, or months for the cube to be rebuilt.

    Start date

    Select the start date for the first automated cube build.

    Start time

    Select the start time for each automated cube build.

  7. Click Save.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft