About the staging database after it is created
Aktualisiert: 2009-04-30
This topic provides information about the structure of the staging database after you have completed the tasks in Step 1: Creating the staging database.
You must be a member of the Global Administrator role to create a staging database in Planning-Verwaltungskonsole, or by using Planning-Befehlszeilendienstprogramm. For more information, see Security roles.
List of Tables
The following tables are created when the staging database is created.
DBSchemaVersion
FK_Relationship
SystemErrorDetails
DBSchemaVersion Table
The DBSchemaVersion table stores the version of the database. This guarantees that the application and staging database are the same version. If you use a staging database from a prior release, unexpected results may occur.
| Column | Data type | Description |
|---|---|---|
DBSchemaVersionNumber |
nvarchar(50) |
The version of the Planning Business Modeler shell. |
UpgradeStatus |
nvarchar(30) |
The status of the upgrade. |
CreateDatetime |
datetime |
The creation date of the staging database. |
ChangeDatetime |
datetime |
The date and time when the database schema changed. |
FK_Relationship Table
The FK_Relationship table helps maintain the relationship among the following:
dimension (D_) and attribute group (AG_) tables
dimension (D_) and hierarchy (H_) tables
measure group (MG_) and related annotation (A_) tables
Rows in the FK_Relationship table are deleted or updated to reflect changes when dimensions or models have been changed or deleted in Planning Business Modeler.
| Column | Data type | Description |
|---|---|---|
Scope |
nvarchar(128) |
Model site that has a model or dimension label. Example: ASH_Corporate:BusinessProcess |
ScopeType |
narchar(10) |
Either D for dimension or MG for the measure group of a model. |
SourceTable |
nvarchar(128) |
The name of the source table. |
TargetTable |
nvarchar(128) |
The name of the destination table. |
SourceColumn |
nvarchar(128) |
The name of the source column. |
TargetColumn |
nvarchar(128) |
The name of the destination column. |
SourceTableType |
nvarchar(10) |
Indicates the source table type D = dimension AG = attribute group H = hierarchy MG = measure group |
TargetTableType |
nvarchar(10) |
Indicates the target table type D = dimension AG = attribute group H = hierarchy |
SequenceNumber |
int |
Indicates the sequence in which the tables are to be processed in a ScopeType. The Sequence column can have three values: 0, 1, and 2. 0 indicates all other relationships that are not a hierarchy. 1 indicates the relationship between the hierarchy and the dimension (where SourceTableType = “H” and TargetTableType = “D”). 2 indicates the relationship between the MemberID and the ParentMemberID in the hierarchy itself (where SourceTableType = “H” and TargetTableType = “H”). |
SystemErrorDetails Table
The SytemErrorDetails table provides error messages for specific BizSystemFlag codes.
| Column | Data type | Description |
|---|---|---|
TableType |
nvarchar(10) |
Indicates the table type to which the BizSystemFlag applies. D - error for a dimension table H - error for a hierarchy table MG - error for a measure group table |
ErrorCode |
int |
The error code. |
Description |
nvarchar(1024) |
Description of the error. |
Stored Procedures and Functions
Stored procedures and functions that help with data integration are added to the staging database. The following table contains a list of stored procedures that are included in the staging database. They will help you perform data integration.
| Validation | Label-based data preparation |
|---|---|
For each measure group, a stored procedure will be created in the following format:
Bsp_DI_Validate_MG_<name of measure group>
Other stored procedures include the following:
Reporting_MeasureGroup_default_partition
bsp_DI_ResetSystemColumnsForAssociations
bsp_DI_ResetSystemColumnsForDimension
bsp_DI_ResetSystemColumnsForModel
bsp_DI_GetSysMemberIdRange
bsp_DI_CleanupAllObjects
bsp_DI_CleanupSingleObject
bsp_DI_ResetColumns
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.