About the staging database after model synchronization
Aktualisiert: 2009-04-30
This topic describes changes to the staging area after you synchronize measure group data for models from the application database to the staging database. When you synchronize in Planning Business Modeler, you can synchronize either all models or a single model.
The structure of the staging database is derived from the structure of the application database, together with some additional tables and columns that help with troubleshooting and referential integrity. For more information, see About the structure of the staging database.
Staging Database Changes
When you synchronize one or more models, all tables related to that model are copied to the staging database. Additionally, the foreign key table, FK_Relationships reflects changes to relationships between tables and a ModelSiteTree table reflects related model sites.
The following table describes the potentially related model tables.
| Table | Purpose |
|---|---|
ModelSiteTree |
Relation tables specify how model sites are related. |
MG_<measureGroupTableName> |
Measure group tables contain fact data for models. Each model definition can contain one or more measure group tables. |
A_<annotationTableName> |
An annotation table exists for each measure group that is created when the Enable annotations property is set during model creation. |
AG_<attributeGroupTableName> |
Attribute group tables contain predefined property values for the dimension tables. |
D_<dimensionTableName> |
Dimension tables contain a flat list of all members in the dimension. Each dimension definition contains one table. |
H_<hierarchyTableName> |
Hierarchy tables contain a hierarchical list of members for a dimension. Each dimension definition can contain zero or any number of hierarchy tables. |
NS_<hierarchyTableName> |
Nested set tables contain a tree representation of related hierarchy tables. Each hierarchy has a related nested set table. |
Table Columns
Each of the measure group tables mentioned previously contains the types of columns that are shown in the following table.
| Column type | Description |
|---|---|
Data Columns |
Columns that contain business data. This data is created by the user or is loaded from an external data source. |
System Columns |
Columns that contain system data. This data is created by the system to keep track of internal processes and status. |
Error Reporting Columns |
BizSystemFlag, BizSystemErrorDetails, and BizValidationFlag are used to track validation and loading status. |
- Data Columns
Columns that contain business data. This data is created by the user or is loaded from an external data source.
- System Columns
Columns that contain system data. This data is created by the system to keep track of internal processes and status.
- Error Reporting Columns
BizSystemFlag, BizSystemErrorDetails, and BizValidationFlag are used to track validation and loading status.
Error Reporting Columns
The following table lists the additional columns that are added to dimension and hierarchy tables in the staging database.
| Column | Data type | Description |
|---|---|---|
BizSystemFlag |
bigint |
Indicates a numeric value that is associated with error details. See About setting the BizSystemFlag column |
BizSystemErrorDetails |
nvarchar(1024) |
Indicates, for troubleshooting, the column where the error exists. |
BizSystemValidationStatus |
bigint |
Indicates the value that stores validation errors for business logic. See About the validation of model data by using business logic. |
BizSystemFlag, BizSystemErrorDetails, and BizValidationStatus
The following table lists error reporting columns for BizSystemFlag, BizSystemErrorDetails, and BizValidationStatus.
| Tables | BizSystemFlag | BizSystemErrorDetails | BizValidationStatus |
|---|---|---|---|
dimension (D_) |
X |
X |
N/A |
hierarchy (H_) |
X |
X |
N/A |
attribute group (AG_) |
X |
X |
N/A |
measure group (MG_) |
X |
X |
X |
annotation (A_) |
X |
X |
X |
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.