Architecture of the Scorecard Run-Time Object in PerformancePoint Services
Published: May 2010
In PerformancePoint Services in Microsoft SharePoint Server 2010, a scorecard view incorporates many objects from the object model. This topic describes the architecture and components of the run-time object that is used to render a scorecard view on a dashboard page.
Applies to: PerformancePoint Services for SharePoint Server, Enterprise version
A GridViewData object is the primary component of the scorecard run-time object. It is produced at run time by evaluating a GridViewDefinition object, and it defines the dataset and structure of the scorecard view.
GridViewDefinition is stored in the PerformancePoint Services repository as part of the scorecard definition. It is a design-time object that defines the structure and formatting of a scorecard, but it does not contain information about cell data.
GridViewData defines the basic structural elements of a scorecard view: two hierarchy trees that represent the column and row headers, and a two-dimensional array that represents the cells at the intersection points of the headers. Row headers render on the left side of the scorecard view, and column headers render across the top. This grid structure is shown in the following diagram.
GridViewData is returned by the GenerateView method, and it is used to generate the HTML for a scorecard view. Custom applications can consume GridViewData to obtain information about a scorecard, and custom scorecard transforms can programmatically manipulate its properties. For more information about scorecard transforms, see Overview of PerformancePoint Services Scorecard Transforms.
GridViewData properties store configuration information that is defined in PerformancePoint Dashboard Designer by the scorecard's author. GridViewData is a complex object, and many of its properties return other PerformancePoint Services objects, as shown in the following diagram.
The following sections describe the component objects of a GridViewData object and the properties that return them.
Represent the scorecard’s row and column header cells, which display the name of a KPI, metric, or dimension member. Each row header aligns to a row, but only column headers at the leaf level align to a column. Leaf-level column headers typically contain metrics such as Actual and Target. Column headers above the leaf level are aggregates for the headers that represent their child elements. For example, in Figure 1, CY2009 represents the aggregate of the Actual and Target metrics below it. GridHeaderItem objects define the header hierarchy and some properties of the items in the cell, such as the indicator and display and format settings.
RootColumnHeader The root column header cell of the scorecard view.
RootRowHeader The root row header cell of the scorecard view.
RootRowHeader represents the row that contains the column headers. It is discarded during rendering and only its child elements are rendered.
GridCellSet and GridCell Objects
Represent the scorecard's data cells, which are derived from the intersections of column and row headers.
The GridViewData.Cells property returns a GridCellSet object, which is a collection of GridCell objects that define properties such as the cell's value, calculations, annotation, and display and format settings.
Represent the format settings for the header and body cells in a scorecard view. Default settings for a scorecard view are defined at the GridViewData object, but they can be overridden at the header or cell level.
Represent the locations of content types (which represent first class objects) in the repository. The PerformancePoint Services repository comprises SharePoint document libraries and lists.
Represent the transforms that are applied to the scorecard view. GridViewTransformReferenceCollection returns a collection of GridViewTransformReference objects that represent references to the transforms. Transforms can change the appearance, contents, or functionality of scorecards.
PreQueryTransforms A set of transform operations that are applied before retrieving data from the data source.
PostQueryTransforms A set of transform operations that are applied after retrieving data from the data source.
PreRenderTransforms A set of transform operations that are applied immediately before rendering the scorecard view.
For more information about scorecard transforms, see Overview of PerformancePoint Services Scorecard Transforms.