Measure Lookup Dialog Box

Use the Measure Lookup dialog box to find and select a measure for a key performance indicator (KPI) in the Key Performance Indicators grid.

The Measure Lookup dialog box displays all possible project data cube measures, whether or not you selected a measure on the Measures tab in Analysis Cubes Configuration to populate the data cube. This means that you could select a measure that does not populate the data cubes.

Be sure that when you create a KPI, the measure that you select for it in the Key Performance Indicators grid has also been selected on the Measures tab in Analysis Cubes Configuration to populate the data cubes; otherwise, the KPI will not work.

User-defined fields that you selected on the Fields tab in User Defined Tabs Configuration to populate the Project data cube display in the Measure Lookup dialog box.

Location

To display the dialog box, complete the following steps:

  1. From the Vision Navigation menu, click Configuration > General > Analysis Cubes.
  2. On the Key Performance Indicators tab, click beside the Measure field in the Key Performance Indicators grid.

Contents

Field Description
Display Type This prefills with Standard. You cannot change it.
Search By

Click in this field to select the criteria that you want to use to search for a measure.

The options are:

  • Folder — This returns all measures in the results box. The measures are sorted by the folder name within the measure group in alphabetical order.

  • Group — This returns all measures in the results box. The measures are sorted by the measure group name in alphabetical order.

  • Label — This returns all measures in the results box. The measures are sorted by their name (label) in alphabetical order.

In the Excel PivotTable Field List, measures are organized in groups. Within groups, they are organized within folders.

For example, the measure named "Billed - Reimb" is located in the Billed By Category folder in the Billed measure group.

Search Text

Enter text to narrow your search. Or, leave this blank to return all possible measures in the results box.

For example, if you enter Label in the Search By field and enter Employee in the Search Text field, when you click Search, all the measure names (labels) that start with Employee display in the results box.

Search After you select search criteria in the Search By and Search Text fields, click the Search button to display the results of the search in the results box.
Results box

When the Measure Lookup dialog box first opens, the large results box at the center of the dialog box is empty. After you enter search criteria in the Search By and Search Text fields and click the Search button, the search results display the results box.

Click the measure in the results box to select it and associate it with the KPI.

Clear Click this button to clear the measures listed in the results box.
Select After you select a measure in the results box, click the Select button. The Measure Lookup dialog box closes and the measure you selected now displays in the Measure field in the Key Performance Indicators grid.