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.