KPI Datasheet

The KPI Datasheet section contains fields where you can provide the basic information such as KPI Name, Parent KPI, Description, and so on. The following table provides information about the fields in this section.

Field	Data Type	Description	Behavior and Usage
Actual	Number	Displays the type of aggregation that you want to use for calculating the Actual Value.	This is a required field. This field appears in the Data Source Fields section when you select the Data Source Type as Aggregate. In all these fields, you can select any of the following calculations: Sum: The addition of all the sub-indicators Average: The calculated average of the sub-indicators. Weighted Average: The value of the KPI is calculated from the value of its sub-indictors (e.g., V1, V2, V3, and V4) and the value of pre-determined weight factor associated with each sub-indicator (e.g., K1, K2, K3, and K4). The weighted average is usually calculated as (K1 x V1 + K2 x V2 + K3 x V3 + K4 x V4)/(K1 + K2 + K3 + K4). Minimum: The minimum value from the sub-indicators. Maximum: The maximum value from the sub-indicators.
Add Measures	N/A	Displays the table where you can provide the values.	This field appears in the Data Source Fields section when you select the Data Source Type as Manual. This field displays a table with following columns : Dates Values
Aggregate Score only	N/A	If you want a normalized score to be calculated from sub-indicators, select the Aggregate Score Only check box. The aggregated score will be calculated and displayed depending upon the aggregation type selected in Actual field in the Data Source Fields section.	This field appears in the Data Source Fields section when you select the Data Source Type as Aggregate. If you have selected the Aggregate Score only check box, then you need to determine the function used to calculate the score value in the Data Source Fields section.
Best value	N/A	The optimal output level.	This field appears in the Data Source Fields section when you select theData Source Type as APM Query. This field list all the columns that contains number value. You can either select the value in these fields or provide the value in the Limit section. This value is used to calculate the normalized score that is assigned to the KPI when it is created.
Bullet Chart	N/A	Displays the KPI in bullet chart format.	This field appears in the Data Source Fields section. By default, the dial chart is selected. however, you can select this option to display the KPI in a bullet chart format in the KPI details page.
Critical	Number	Displays the type of aggregation that you want to use for calculating the Critical Value.	This field appears in the Data Source Fields section when you select the Data Source Type as Aggregate. You can either select the value in these fields by using the drop-down list box or provide the value in the Limits section. In any of the cases, you must provide value to the Actual field. In all these fields, you can select any of the following calculations: Sum: The addition of all the sub-indicators Average: The calculated average of the sub-indicators. Weighted Average: The value of the KPI is calculated from the value of its sub-indictors (e.g., V1, V2, V3, and V4) and the value of pre-determined weight factor associated with each sub-indicator (e.g., K1, K2, K3, and K4). The weighted average is usually calculated as (K1 x V1 + K2 x V2 + K3 x V3 + K4 x V4)/(K1 + K2 + K3 + K4). Minimum Maximum
Critical Value	Number	The value that indicates that the KPI is not reaching its potential target.	This field appears in the Data Source Fields section when you select the Data Source Type as APM Query. This field list all the columns that contains number value. You can either select the value in these fields or provide the value in the Limit section.
Cube	N/A	The cubes that are registered in the Analysis Services data source are displayed as a list of values.	This field appears in the Data Source Fields section when you select the Data Source Type as Analysis Services.
Data Source Type	N/A	Contains the list of data sources that can be assigned to this KPI.	The values for a KPI measurement are pulled from a specified data source. You can create KPI by using the following options. Analysis Services By using an Analysis Services, you are extracting data from a Cube that is configured in the Analysis Services. APM Query: By using a GE Digital APM query, you are extracting data from the GE Digital APM database. Aggregate: By using aggregation, you specify that the sub-indicators, or the lower level variables of the KPI, should be calculated together for the data source. An aggregation is a table or structure containing pre-calculated data for a Cube. You can aggregate sub-indicators by using a sum, an average, a weighted average, a minimum, or a maximum function. The values that can be aggregated are the actual value, the target value, the stretch value and the critical value. Manual: By using the data source as Manual, you define input for a KPI by providing specific values instead of using an external data source. Depending upon the data source that you select, the related fields appear.
Dates	Date	Specify the date for the actual values.	This field appears in the Add Measures section when you select the Data Source Type as Manual. You can select the dates by using . Note: The dates must be unique. You must not enter two values for the same date.
Description	Text	Provide a brief description of the new KPI.	In this field, you can provide the description about the KPI.
Dial Chart	N/A	Displays the KPI in dial chart format.	This field appears in the Data Source Fields section. By default, this option is selected and the KPI appears in a dial chart format in the KPI details page.
Hierarchy Member	N/A	A member from a hierarchy in the cube that you want to monitor. For example, you can select Country as a hierarchy member.	This field appears in the Data Source Fields section when you select the Data Source Type as Analysis Services.
Limit	N/A	Specifies the range of limits for a KPI.	You can provide the values manually in this section. The Limits section contains the following fields: Worst Value Critical Value Target Value Stretch Value Best value
Limiting Level	N/A	The level to which you want to view the KPI.	This field appears in the Data Source Fields section when you select the Data Source Type as Analysis Services. The value in this field depends on the value that you select in the Hierarchy Member list. When you select a hierarchy member and its limiting level, the KPIs are created for every level and member in the Limiting Level. For example, If you select Country as the hierarchy member and City as the limiting level, then the KPIs are created for each state and cities in that selected country.
Measure	N/A	The measure that you want to use for the KPI. For example, you can select Total Maintenance Cost as a measure that you want to monitor over a period of time.	This field appears in the Data Source Fields section when you select the Data Source Type as Analysis Services. This field is enabled only when you select a Cube. This is a required field.
Measurement Date	Date	Contains a list of only Date fields from the query.	This field appears in theData Source Fields section when you select the Data Source Type as APM Query. In the Measurement Date list, you select a field from the query that represents the measurement date.
Measurement Value	Number	The measure that you want to use for the KPI.	This field appears in the Data Source Fields section when you select the Data Source Type as APM Query. This field is enabled only when you select a query. This is a required field.
Name	Character	Specify the name of the KPI that you want to create.	This is a required field.
Number Format	Number	The format for the numeric values.	This field appears when you select the Data Source Type as Analysis Services, APM Query, and Aggregate. You can choose the following number formats: Number: The numeric format. Number with 0 precision: The number with no decimals. Number with 1 precision: The number with one digit after the decimal. Number with 2 precision: The number with two digit after decimal. Percentage: Specifies that the field will be formatted as a percentage, including multiplying the base value by 100 and including a percent sign (%). Currency: Specifies that numeric values will be formatted as currency, according to the browser culture on which the GE Digital APM application is being accessed and the number of digits past the decimal that you specify. When you select this option, the example that appears on the KPI Number Format dialog box uses the currency symbol associated with the browser culture on which the GE Digital APM application is being accessed.
Parent KPI	N/A	Contains the list of KPIs that can be assigned as parent KPI to this new KPI.	If the KPI should function as a sub-indicator for another KPI, then in the Parent KPI list, select the parent KPI for which this KPI will be a sub-indicator.
Query	N/A	The query from which you want to extract the data.	This field appears in the Data Source Fields section when you select theData Source Type as APM Query. You can select the query from the Catalog folder.
Show Score Only	N/A	If you want only a score to be calculated for the KPI, select the Show Score Only check box. The actual value will not be populated.	Via the Show Score Only check box on the KPI design page, you can choose to view a KPI score instead of Actual, Target, Critical, and Stretch Values in the Dial chart, trend-line chart and tabular view of the KPI details page.
Slices	N/A	The slice members that can be used to further filter KPI data.	This field appears in the Data Source Fields section when you select the Data Source Type as Analysis Services. You can add slices by selecting + Slices. The Add to Slice window appears displaying all the dimensions. You can select a dimension member from the list.
Stretch	Number	A much higher quantitative measurement than a Target Value, demanding breakthrough performance for achievement.	This field appears in the Data Source Fields section when you select the Data Source Type as Aggregate. You can either select the value in these fields by using the drop-down list box or provide the value in the Limits section. In any of the cases, you must provide value to the Actual field. In all these fields, you can select any of the following calculations: Sum: The addition of all the sub-indicators Average: The calculated average of the sub-indicators. Weighted Average: The value of the KPI is calculated from the value of its sub-indictors (e.g., V1, V2, V3, and V4) and the value of pre-determined weight factor associated with each sub-indicator (e.g., K1, K2, K3, and K4). The weighted average is usually calculated as (K1 x V1 + K2 x V2 + K3 x V3 + K4 x V4)/(K1 + K2 + K3 + K4).
Stretch Value	Number	A much higher quantitative measurement than a Target Value, demanding breakthrough performance for achievement.	This field appears in the Data Source Fields section when you select the Data Source Type as APM Query. This field list all the columns that contains number value. You can either select the value in these fields or provide the value in the Limits section.
Sub-Indicators	N/A	Contains the list of KPIs that can be assigned as the sub-indicator KPIs.	You cannot assign the KPI that is already assigned to another parent KPI.
Target	Number	A quantitative measurement of a performance metric that is to be achieved by a given time.	This field appears in the Data Source Fields section when you select the Data Source Type as Aggregate. You can either select the value in these fields by using the drop-down list box or provide the value in the Limits section. In any of the cases, you must provide value to the Actual field. In all these fields, you can select any of the following calculations: Sum: The addition of all the sub-indicators Average: The calculated average of the sub-indicators. Weighted Average: The value of the KPI is calculated from the value of its sub-indictors (e.g., V1, V2, V3, and V4) and the value of pre-determined weight factor associated with each sub-indicator (e.g., K1, K2, K3, and K4). The weighted average is usually calculated as (K1 x V1 + K2 x V2 + K3 x V3 + K4 x V4)/(K1 + K2 + K3 + K4).
Target Value	Number	A quantitative measurement of a performance metric that is to be achieved by a given time.	This field appears in the Data Source Fields section when you select theData Source Type as APM Query. This field list all the columns that contains number value. You can either select the value in these fields or provide the value in the Limit section.
Time Level	N/A	The period for which you want to view a KPI result.	This field appears in the Data Source Fields section when you select the Data Source Type as Analysis Services. This is a required field. You can select the Time Level list to select a time level, such as year, semester, quarter, month, week or day. The time level appears in the format: Dimension/Hierarchy/Level.
Values	Number	Displays a text box where you can provide the actual values.	This field appears in the Add Measures section when you select the Data Source Type as Manual. To delete a row, select .
Worst Value	N/A	The output value that should be strictly avoided.	This field appears in the Data Source Fields section when you select theData Source Type as APM Query. This field list all the columns that contains number value. You can either select the value in these fields or provide the value in the Limit section. This value is used to calculate the normalized score that is assigned to the KPI when it is created.