Compartilhar via


About data preparation

Atualizado em: 2009-04-30

Before you can integrate data, you must prepare it in the staging area so that it can be uploaded to the application database. This topic describes a single method for conforming data just before you move it to the Planning Server application database.

Label-Based Data Preparation

Because the Planning Server application only supports the loading of ID-based tables from the staging database to the application database, stored procedures are provided to simplify data preparation in the staging database.

Stored procedures perform label-based table creation from existing ID-based hierarchy, dimension, and measure group tables in the following ways:

  • For all dimensions

  • For one hierarchy

  • For all hierarchies in a dimension

  • For one measure group

  • For all measure groups in a model

Label-based data preparation enables you to prepare dimension (D_), hierarchy (H_) and measure group (MG_) tables that have labels. After that, you can convert the labels to IDs to load the application database. The primary reason to use label-based data loading is that source systems do not provide IDs that are consistent with MemberIDs in application tables from Planning Business Modeler. Database administrators might also prefer to work with fact data by using related dimension member labels instead of cryptic IDs.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for PerformancePoint Planning Server.

Consulte Também