In PerformancePoint Dashboard Designer, you can set properties for the columns in a tabular data source. The properties that you set determine how PerformancePoint Monitoring Server classifies the data from that column. For example, if you can designate a column as Fact, Monitoring Server classifies the data values in that column as fact data that can be aggregated. If, instead, you designate that column as Tuple, Monitoring Server classifies the data values in that column as tuples from a multidimensional, SQL Server Analysis Server (SSAS) cube.
To configure properties for a data column, do the following:
In the Workspace Browser, double-click Data Sources.
Double-click the name of the specific data source for which you want to define data properties.
In the data source workspace, click the View tab.
In the Column Definitions pane, click in a column to to select that column. The data properties for the selected column appear in the Details pane.
Take the following steps:
In the Column Name box, type a display name for the column. This value will be displayed as the name of the data source column.
In the Column Unique Name box, type a unique name for the column. Monitoring Server uses this name for internal processes.
From the Column Type drop-down list, select a column type. This value is displayed in the data source column under Column Name.
Options for column type
The following table shows the options for Column Type. The option that you choose determines how Monitoring Server classifies the data in that column.
Handling for data in column
Values in this column are treated as if they were members of a dimension, based on the column.
Values in this column are treated as fact values.
Values in this column are ignored.
Values in this column are treated as tuples.
Values in this column are candidates for mapping to the Master Time Dimension for Time Intelligence.
From the Aggregation drop-down list, select a type of aggregation. The aggregated data value is displayed in the data source column under the Column Type that you specified in step c.
Options for aggregation method
The following table describes the options for aggregation method.
Type of aggregation
Calculates the average of numeric fact values.
Determines the number of occurrences of unique members in the column.
Determines the smallest numeric fact value.
Performs no aggregation.
Statistical Standard Deviation
Calculates the standard deviation of numeric fact values.
Calculates the sum of the numeric fact values.
Calculates the variance of the numeric fact values.
Determines the first fact value that occurs for each unique column member.
Repeat steps a through d for each column in the data source.
When you finish configuring data columns, click Preview Data to view the data in your data source.
Click the Home tab, and then click Publish All.
The procedures that are discussed in this topic are part of the process that is required to create a data source. For information about other procedures related to this process, see the following links.