ScorecardAnnotations

Parameter

Name Data Type
ScorecardID (UNIQUEIDENTIFIER)

Grain

One record per comment within an annotation that has been associated with the Scorecard referenced in the parameter.

Result Set

Field Name Data Type Description
ScorecardID UNIQUEIDENTIFIER Uniquely identifies a Scorecard
AnnotationID UNIQUEIDENTIFIER Uniquely identifies an annotation
CommentTitle NVARCHAR(MAX) Title given to each comment within the annotation. An annotation is a collection of one or more comments
CommentMessage NVARCHAR(MAX) Text of the comment
CommentCreatedBy NVARCHAR(MAX) Domain\Username of the person who created the comment
CommentCreatedDate DATETIME Date and time the comment was created
AnnotationOwner NVARCHAR(MAX) Domain\Username of the person who created the annotation
CellPathCoordinates NVARCHAR(MAX) Concatenated string comprised of the AnnotationTuples, AnnotationKpiID and AnnotationMetricName fields
AnnotationKpiID UNIQUEIDENTIFIER Uniquely identifies the Kpi that the annotation refers to
AnnotationKpiMetricName NVARCHAR(MAX) Name of the metric the annotation refers to. The metric will be present within the Kpi referenced in the AnnotationKpiID
AnnotationTuples NVARCHAR(MAX) Delimited list of tuples that are present on either axis of the scorecard to identify the annotation cell
FilterSlice NVARCHAR(MAX) Delimited list of selected filter values relating to the context of the annotation
AnnotationCreatedOn DATETIME Date and time the annotation was created
AnnotationLastUpdatedBy NVARCHAR(MAX) Domain\Username of the person who last updated the annotation
AnnotationLastUpdatedOn DATETIME Date and time the annotation was last updated

Last edited May 30, 2008 at 6:00 AM by NickBarclay, version 2

Comments

No comments yet.