Export data from the source system

Reference data (dimension and hierarchy data) and fact data (models) are not migrated during the application migration process. You can load the required data into the production deployment the same way that you load data into the source system. If you need to migrate data from test deployment (source) to production deployment (destination), use the following procedure to export the data from the source server.

Note

To find detailed information on Planning Command Utility, type ppscmd.exe /? or refer to Using the PerformancePoint Planning Command Utility.

Export data from the source system

  1. Create a staging database by using Planning Administration Console or Planning Command Utility if a staging database does not already exist. Refer to Planning Administration Console Help for creating a staging database.

    Syntax:

    ppscmd stagingdb /operation createstaging /server <planning server url> /path <application_label>

    Example:

    ppscmd stagingdb /operation createstaging /server https://localhost:46787 /path alpine_ski_house

  2. Synchronize the staging database for each site by using Planning Business Modeler or Planning Command Utility. Repeat, as required, for all dimensions and models to be migrated:

    • Dimensions (includes hierarchies by default)

    • Models

    Syntax:

    ppscmd stagingdb /operation synchronizedata /server <planning server url> /path <application_label> . <modelsite_label> /collection dimensions | models

    Examples:

    ppscmd stagingdb /operation synchronizedata /server https://localhost:46787 /path alpine_ski_house.ash_corporate /collection models

    ppscmd stagingdb /operation synchronizedata /server https://localhost:46787 /path alpine_ski_house.ash_corporate /collection dimensions

  3. Synchronize the staging database for associations to be migrated by using Planning Business Modeler or Planning Command Utility.

    Syntax:

    ppscmd stagingdb /operation synchronizedata /server http:// <ppsservername> :46787 /path <application_label> /collection assocations

    Examples:

    ppscmd stagingdb /operation synchronizedata /server https://localhost:46787 /path alpine_ski_house /collection associations

  4. Back up the staging database.

See Also