Compartilhar via

  • Artigo

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.

ObservaçãoObservação:

To find detailed information on Utilitário de Comando do Planning, 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 Console de Administração do Planning or Utilitário de Comando do Planning if a staging database does not already exist. Refer to Console de Administração do Planning Help for creating a staging database.

    A sintaxe

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

    Exemplo:

    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 Utilitário de Comando do Planning. Repeat, as required, for all dimensions and models to be migrated:

    • Dimensions (includes hierarchies by default)

    • Modelos

    A sintaxe

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

    Exemplos:

    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 Utilitário de Comando do Planning.

    A sintaxe

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

    Exemplos:

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

  4. Back up the staging database.

Consulte Também