About the staging database after model synchronization

PerformancePoint Server 2007

更新: 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 规划业务建模器, 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.

另请参阅

显示: