About setting the BizSystemFlag column

PerformancePoint Server 2007

更新: 2009-04-30

This topic describes what you must do to add, update, or delete rows from the application database by using the BizSystemFlag column in the staging database.

About the BizSystemFlag Column

After populating the staging database, you must set the BizSystemFlag to indicate which action should be taken on each row in the tables that you are loading to the application database. These tables include the following:

  • Dimension (D_) tables

  • Hierarchy (H_) tables

  • Measure group (MG_) tables

  • Annotation (A_) tables

For more information, see Step 5: Loading data from staging to application database.

Add, update, and delete rows

For adding, deleting, and updating rows in the application database set the BizSystemFlag in the staging database.

  • Rows with BizSystemFlag = 0 (default - no action is taken)

  • Rows with BizSystemFlag = 400 (deletes)

  • Rows with BizSystemFlag = 200 (adds)

  • Rows with BizSystemFlag = 300 (updates)

Rows with a BizSystemFlag = 100 indicate that data is already located in the application database. This data may have been either previously-loaded or user-created.

The links in the following table provide considerations and examples for adding, updating, and deleting dimensions, hierarchies, and measure groups by using the BizSystemFlag.

Topic Definition

Add, update, delete rows in a dimension

Describes what you must do to add, update, or delete rows in a dimension table that is derived from the application database

Add, update, delete rows in a hierarchy

Describes what you must do to add, update, or delete rows in a hierarchy table that is derived from the application database

Add, update, delete rows in a measure group

Describes what you must do to add, update, or delete rows in a measure group table that is derived from the application database

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.

另请参阅

显示: