Copy OLAP cubes in Project Server 2013
Published: July 16, 2012
Summary: Copy Project Web App OLAP cube settings for use in creating a new cube.
Applies to: Project Server 2013
OLAP cubes are managed on the OLAP Database Management page in Server Settings in the SharePoint Central Administration website.
To copy an OLAP cube, you must be a Project Server service application administrator. 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
In Central Administration, in the Application Management section, click Manage service applications.
Click the Project Server service application.
Point to the Project Web App instance where you want to build the cube, click the arrow that appears, and then click Manage.
On the Server Settings page, in the Database Administration section, click OLAP Database Management.
On the OLAP Database Management page, select the cube that you want to copy, and then click Copy.
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.
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.