About the staging database after dimension synchronization
Actualizado: 2009-04-30
This topic describes changes to the staging area after you synchronize the application database and the staging database. When you synchronize in Planning Business Modeler, you can synchronize either all dimensions or a single dimension.
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 dimensions, the related attribute group, hierarchy, nested set tables, and other tracking tables 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. |
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. |
Additionally, the foreign key table, FK_Relationships, reflects changes to relationships between tables.
Table Columns
Each of the dimensional tables mentioned previously contain 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 and BizSystemErrorDetails are used to track validation and loading status. |
Error Reporting Columns
The following table describes the error 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 the column where the error exists. Used for troubleshooting. |
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.