Add rows in annotations

更新: 2009-04-30

This topic describes what you must do to add rows in an annotation table that is derived from the application database. You can do this by using the BizSystemFlag column in the staging database. You cannot update or delete rows in an annotation table that is derived from the application database.

System and updatable annotation columns

The following table key lists the various settings that are available for adding rows in the annotation table in the staging database.

Table Key

Enter

Enter your values.

Ignore

This is a system column and must be ignored.

NULL

Set these columns to NULL.

The following table contains our recommended settings for adding rows in the annotation table in the staging database.

Column Add

RowId

NULL

Scenario_MemberId

Enter

Time_Month (or Time_Quarter, etc)

Enter

(optional) Any_Dimension_Or_Hierarchy_MemberId

Enter

AnnotationCount

Enter

Description

Enter

Value

Enter

CreateDateTime

Ignore  

ChangeDateTime

Ignore  

LoadingControlId

Ignore  

UserId

Ignore  

BizSystemflag

200

BizValidationStatus

NULL

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.

另请参阅