Copy an OLAP cube (Project Server 2010)


Applies to: Project Server 2010

Topic Last Modified: 2011-03-12

OLAP cubes are managed on the OLAP Database Management page in Server Settings on a Microsoft Project Web App (PWA) site.

To copy an OLAP cube, you must have the Manage Cube Building Service Global Permission. Perform the following procedure to copy an existing OLAP Cube. Copying a cube creates a new cube with the same settings and configuration as the cube that you copied. Copying a cube does not copy the Analysis Services database, but instead copies all the cube settings from which you can build a new Analysis Services database.

You must specify a new name for the Analysis Services database after you copy the cube.

Use the following procedure to copy an OLAP cube.

To copy an OLAP cube
  1. On the PWA home page, click Server Settings.

  2. On the Server Settings page, in the Database Administration section, click OLAP Database Management.

  3. On the OLAP Database Management page, select the cube that you want to copy, and then click Copy.

  4. On the OLAP Database Build Settings page, type the name of the server and the database that you want created and adjust any other desired settings.

  5. Click Save.

    This procedure copies the cube configuration but does not build the cube. You can build the cube manually or wait for it to build on the schedule that you set.