Export (0) Print
Expand All

Copy an OLAP cube (Project Server 2010)

Published: May 12, 2010

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.

note Note:

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.

    note Note:

    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.

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