About setting the BizSystemFlag column
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.
Describes what you must do to add, update, or delete rows in a dimension table that is derived from the application database
Describes what you must do to add, update, or delete rows in a hierarchy table that is derived from the application database
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.