The measure manager

(click on the various sections to view the notes)

The Measure Manager allows you to quickly set the appearance of measures on the PivotGrid.  You can activate the Measure Manager by clicking on the Measure Manager image on the PivotGrid.

You can also activate it by clicking on the image on the Measures Toolbar.  If you click on the drop down arrows for the individual measure items, you will activate the Measures Manager only for that item.

Note that some of the measures may require a supersaturated cube to be built.  Please refer to section 2.1.2.3.1 of the User Guide.

These are the views available for each measure.  You can choose which view to display or hide by clicking on the check boxes.  If you do not choose any view to display but the measure is displayed, the 'Value' view will be displayed by default.  For more information on views, please refer to section 4.4.3.1 of the User Guide. 

You can change the default captions of the views by changing the values in the // map view names section of the PivotCube.lng file.  You should then deploy this file together with your application.  You can also load a custom language file to change the default captions, by calling the LoadLNGFile method of TPivotCube.  See section 7 of the User Guide.

The default display caption for a measure is its AliasName, as defined in the underlying TPivotCube.  You can change this to another description by entering the text here.  To change the display caption via code, you set the DisplayName property of the dimension in the underlying TPivotMap e.g.

pivotmap1.Measures[0].DisplayName := 'Summary'; pivotmap1.RefreshData;

Once a value for a measure's view has been calculated, it can be displayed as is or replaced by another calculated value.  You can choose which value to display by choosing from the Value drop down box.  For some calculated values, you can further perform simple arithmetic operations on them.  Please see section 4.4.3.2 of the User Guide.

You can set a lower and upper range of values to display on the PivotGrid by setting the filter values.  When the values of a measure are filtered, an indicator will appear on the measures toolbar.

You can change this color using the TPVMeasureToolbar.ItemSettings.FilteredColor property.

When you filter by fact table records, you are excluding all values that do not meet the filter criteria BEFORE calculating the measures' values.  This is in contrast to the normal filtering, which only hides or displays calculated cells that do not meet the filter criteria.  To filter by fact table records, you need to build a supersaturated cube.  Please see section 4.4.1 of the User Guide on further details on these filters.

When a filter is active, an indicator will appear on the measures toolbar, as displayed above.

You can set the display format of a measure's values here.  The formatting codes are similar to that used for the FormatFloat function in Delphi.  You can also click on the Build button to see same samples of formatting values.

You can also control the formatting of the value using the FormatString property of the underlying TMapMeasure, linked to the grid as follows:

TPivotGrid.Map > TPivotMap.Measures > TMapMeasure.FormatString

A formula will be displayed if the selected measure is a calculated measure.  You can edit the formula directly here, or you can use the Calculated Measures Manager dialog.