Step 4: Validating data in the staging database

Data validation helps make sure that your data is valid and ready for loading. The following list describes the validations that Planning Server performs.

  • Make sure that the staging database defines relationships for any foreign keys that are required.

  • Make sure that the dimension members and measure groups that are used in associated business rules are in the model.

Planning Server performs this validation testing before it loads data from the staging database to the application database. To perform the validation, Planning Server creates stored procedures that perform the validations in the staging database, and runs those procedures at the appropriate time.

Validation occurs automatically when you load model data from Planning Business Modeler. You can decide not to validate measure group data when you load by using the Planning コマンド ユーティリティ with the /novalidation switch. For more information see Scriptable data integration.

このセクションの内容

関連情報

  • Data integration overview
    Provides an overview of the architecture of the Planning Server data integration system and of the data load processes.
  • Step 2: Synchronizing the staging database
    Provides background information about how Planning Server synchronizes the structures and data of each database, and describes the steps that you must follow to perform synchronization.
  • Scriptable data integration
    Describes the commands in the Planning コマンド ユーティリティ that you can use to write a script that performs data integration steps.