Working with analysis report measures

Measures are fields that hold data that can be aggregated. Measures can also be calculated fields. The measures that are available in your report depend on the data fields you added when you created the report.

The Measures list contains measures that you can drag & drop to card shelves to display the data represented by the fields in different ways in the Pivot Grid.

Measures also display as attributes in the Attributes pane. See Working with analysis report attributes for more information.

You can see whether a field that has already been dropped onto a shelf is an attribute or a measure. With the default theme, attributes are blue and measures are green. Dragging and dropping a measure to the Columns or Rows shelf displays a scale for the data on the corresponding axis.

When you drag & drop an attribute to a shelf on the Encodings card, resulting legends look different from ones created when you drag & drop a measure to it. This is because attribute values are represented as individual values while measure values are represented as a range with a sliding scale.

Aggregation

For schedule reports, the report tool imports data for each individual task from the output path. There may well be several steps within each period in the output path. For database reports, the raw data is imported at the lowest database level, normally the block level. As a result, you need to nominate an aggregation method for each measure. The options include:

•	Additive: adds the values for each output step (schedule reports) or each block (database reports).

•	Min: return the minimum value from the individual steps for a period or the minimum block value.

•	Max: return the maximum value from the individual steps for a period or the maximum block value.

•	Average: returns the average value.

•	Weight Average: user provides the calculated field to be averaged, and additionally a calculated field which acts as the weighting field.

•

Calculated: should only be selected if the measure includes a mathematical expression and uses aggregation type functions within the expression. It lets you have various aggregation methods in a single formula, that is, the sum of one calculated field multiplied by the minimum of another calculated field.

•

Distinct Sum: this is used specifically for a measure that is reporting a value from the calendar database that the user wants to sum. The value will display in each output step however only one occurrence is reported for each period. Only one reported occurrence for each scheduling period is totalled for multiple periods.

Adding or editing a measure

Although it seems that you import measures directly from XPAC, you actually query fields (which you can use later to create calculated fields) and the reporting tool creates measures from these fields. The measures point to the respective query fields, but also provide information and control of how data is aggregated and displayed.

You can add a measure by:

•	creating a new measure by right-clicking anywhere in the Measures pane and selecting Create New Measure. This displays the Create New Measure window (see Working with analysis report expressions for more information)

•	creating a new measure by clicking Import Report Data > Activity Mapping (see Activity mapping for more information)

•	importing a measure from your XPAC project by clicking Import Report Data > Import Report Data. This displays the Import Report Data window, where you can add and remove measures in the same way as you did when you created the report.

You can edit a measure by right-clicking the measure you want to edit and selecting Edit Measure. This displays the Edit Measure window (see Working with Analysis Report expressions for more information).

The Edit Measure and Create New Measure windows let you define the Caption that displays in the Measures pane and as a Card, and the Display Folder in the Measures pane under which the measure will display. The windows also let you define various expressions for the measure.

When creating new measures (or calculated fields) that refer to quantitative data for schedule reports, it is important to multiply the calculated fields with the ActualPercent query field. The ActualPercent query field returns the actual percent of each block that is being mined within the period.

Expressions

See Working with analysis report expressions for a comprehensive summary of the expression builder.

Build each expression, firstly by selecting an Aggregate Function, then by selecting from query fields drawn from the XPAC project (to the left of the expression builder) and operators (at the bottom of the expression builder).

Apply your query fields and operators by clicking in the expression field, then double-clicking the query field or operator you need.

You can set your Result Type by selecting from the relevant drop-down list.

Deleting a measure

You can delete a measure from the Measures list by right-clicking it and selecting Delete Measure. The measure will remain available for future use, but is hidden in the list view.

You can also remove a measure by clicking Import Report Data on the toolbar and selecting Import Report Data. This displays the Import Report Data dialog box, where you can measures in the same way as you did when you created the report.