About the staging database after it is created
Actualizado: 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 Consola de administración de planeación, or by using Herramienta de comando de planeación. 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.