Show More Columns dialog

Use this dialog to add or remove columns that display data such as the status, trend, target, and variance of KPIs on a KPI Watchlist, perspective, initiative, or objective. This enables you to customize the KPI data displayed by specifying visible columns.

For information about KPIs, see:

Components

Available Columns

Displays all of the columns that you can select to present a wide variety of data for the KPIs that evaluate the initiative. Table E-7 describes some of the commonly used columns.

To display additional columns to present more KPI data on the initiative, select the columns individually or as groups by pressing Shift or Ctrl, and then click Move. To display all KPI data available, click Move All.

Visible Columns

Displays the columns that are currently visible. To remove columns, select them individually or in groups by pressing Shift or Ctrl, and click Remove. To remove all KPI data displayed, click Remove All.

Move

Use this button to display a column that you select in the Available Columns pane.

Move All

Use this button to display all available columns.

Remove

Use this button to hide a column that you select in the Visible Columns pane.

Remove All

Use this button to not display any KPI data on the initiative.

Notes

Table E-7 lists and describes the some of the commonly used KPI data columns.

Table E-7 Commonly Used KPI Data Columns

Column	Description
Change	If you enabled trending, displays the amount by which the KPI's current actual value differs from the actual value of the previous period. For example, if the actual value of KPI for "Annual Number of Sales" is 2000 and was 1850 last year, the change is 150.
% Change	If you enabled trending, displays the percent by which the KPI's current actual value differs from the actual value of the previous period. For example, if the actual value of KPI for "Annual Number of Sales" is 2000 and was 1850 last year, the change percent is 7.5%.
Data Type	Displays the data type of the KPI values that are stored in the database, for example, integer or percentage.
Formatting	Displays the KPI's raw actual and target values in the formatting for the unit that quantifies the values, such as dollars or days.
Label of Node	Displays the KPI's descriptive name that was specified in the "Add KPI dialog".
Last Run	Displays the date on which KPI value calculations were performed by the backup server.
Normalized	Displays the KPI value after it was converted from its original scale (a value between 1 and 50, for example) to a standard scale (values between 1 and 100) so that you can compare it with other KPI values. For example, assume that you want to use a scale of 0-100 to assess two KPIs. The first KPI is expected to have a value between 0 and 10. It collects a value of 3. The second KPI is expected to have a value between 0 and 1000. It collects a value of 800. To evaluate this data as x% or 100, the Normalize feature converts the KPI values to one between 1 and 100. Accordingly, the first KPI is multiplied by 10 (30) and that of the second KPI is divided by 10 (80).
Owner	Displays the user ID of the person responsible for managing the KPI.
Status	Indicates the performance level of the KPI determined by comparing its actual value with its target. If you own the KPI, you can right-click to override its status.
Target	Displays the KPI's desired value.
Target (Unformatted)	Displays the KPI's raw target value. For example a target value of 134500 dollars would be formatted as $134,500.00.
Trend	Indicates whether KPI performance has improved or declined, is good or bad, or has remained the same. Trend is a separate calculation that involves both the point of view and the Compare to Prior time grain setting (for example quarter, month, or year). The actual value is determined by the point of view. The trend calculation looks at the actual value for point of view time and compares it with the previous time period at the Compare to Prior time grain defined in the "KPI editor: General Properties page". For example, if the Compare to Prior time grain is set to quarter and if you choose 4Q2011 (fourth quarter of 2011) in the point of view, then that KPI's trend would look at the difference between 4Q2011 and 3Q2011, to determine the appropriate symbol (for example, a green up arrow or a red down arrow) to display for trend. See "Trend" for trend symbols and their descriptions.
Value	Displays the KPI's current value.
Value (Unformatted)	Displays the raw KPI value. For example a value of 450019 dollars would be formatted as $4,500.19.
Variance	Displays the value by which the KPI's actual value differs from its target value. For example if the actual value for a Net Profit KPI is 600,000 and its target is 650,000, then the variance is -50,000.
% Variance	Displays the percent by which the KPI's actual value differs from its target value. For example if the actual value for a Net Profit KPI is 600,000 and its target is 650,000, then the variance as a percent is -7.7%
Weight	If you evaluate initiative performance by assigning weights to individual KPIs, then this displays these individual weights. If you do not enter weights that add to 100% Oracle Scorecard and Strategy Management does it for you. The weight for each KPI is used with its normalized assessment value to determine the performance of the objective or initiative.The normalized assessment value is compared against the assessment ranges in the "Settings dialog: Assessment Mappings tab". The range that contains the normalized assessment value is found and that determines the objective's status.