Step 3: Populating the staging database

Planning Server supports loading of ID-based tables from the staging database to the application database. Because only ID-based tables can be loaded, stored procedures are provided to help you prepare data that has labels in hierarchy and measure group tables.

In This Section

• About data preparation
  Learn about the BizSystemFlag, and other important considerations for preparing data.

• About preparing dimension data
  Learn about how to work with linked dimensions and attribute groups.

• About preparing hierarchy data
  Learn about how to prepare hierarchy data. Also learn how to populate a hierarchy and how to prepare label-based data for hierarchies.

• About preparing measure group data for a model
  Learn about how to prepare measure group and model data. Also learn about how to prepare label-based data for measure groups.

Related Sections

• Data integration overview
  Provides an overview of the architecture of the Planning Server data integration system and of the data load processes.

• Data integration configurations
  Describes different configurations that you can use for security and performance.

• Step 1: Creating the staging database
  Provides background information about the organization of the staging database, and describes the steps that are required to create it.

• 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 are required to perform synchronization.

• Step 4: Validating data in the staging database
  Describes the procedures that validate data in the staging database, and describes the steps that are required to run the procedures.

• Step 5: Loading data from staging to application database
  Provides background information about dimensions and models, and describes the steps that are required to load data

• Scriptable data integration
  Describes the commands in the Planning Command Utility. You can use the commands to write a script that performs data integration steps.

• Troubleshoot data integration
  Provides detailed reference information about error codes.