Restoring the entire Metrics database and PowerCube
The Metrics database contains the raw data that is used to generate the PowerCube. Backing up the Metrics database on a regular basis ensures that you can rebuild the PowerCube in the event of a failure.
Before you begin
If you plan to restore the PowerCube on a staging server before copying to your product server, begin by installing Cognos® Business Intelligence on the staging server. Best practice is to install and configure the staging server just like the production server; at a minimum the staging server requires the customized version of Cognos Business Intelligence that you installed on the production server, and access to the LDAP directory where the Cognos administrator account resides.
About this task
When you restore the Metrics database, you must rebuild the PowerCube to make sure it contains all of the same data. You can restore the entire Metrics database in a single operation, and then rebuild the entire PowerCube in another single operation. If the Metrics database is large and your space for restoring the database and rebuilding the PowerCube is limited, you can complete the process incrementally by restoring subsets of data and rebuilding the PowerCube to add each additional set of data. For more information, see Restoring the Metrics database and PowerCube incrementally. To minimize the impact on your users, restore the PowerCube to a staging server and then copy the completed PowerCube to the production server where IBM Cognos Transformer is installed.
If the database is large, it can take a long time to restore it and rebuild the PowerCube.