| PivotCube Visual Guide | Overview |
| General |
The measures toolbar is used to manipulate the measures defined in the PivotCube. You link the toolbar to a cube indirectly by using the Map property. The appearance of the toolbar is determined by the TPvMeasureToolbar.Settings property. The appearance of individual measures items is determined by the TPvMeasureToolbar.ItemSettings property.
| Expand/collapse toolbar |
You can collapse the measures toolbar in order to have a bigger display area for the other PivotCube user interface elements. To expand it, simply click on the image again.
You can also control the state of the toolbar by using the Collapsed property of the toolbar. The default value of this property is False.
| Measures items |
The measures that are displayed are obtained from the underlying TPivotCube, linked as follows:
TPvDimToolbar.Map > TPivotMap.Cube > TPivotCube.Measures
The order of the items in the measures toolbar determines how data is displayed in the Pivot Grid.
| Measures items labels |
The measure item labels are obtained from the AliasName property of each measure, linked as follows:
TPvMeasureToolbar.Map > TPivotMap.Cube > TPivotCube.Measures > TMeasures.MeasureItem > TMeasureItem.AliasName
| Activate global measure manager |
The measure manager is used to set the attributes of each measure item easily. Among the attributes you can set are the visibility of each measure, the displayed measure value and the filtered values. Please see the visual guide on Measure Manager for more details.
When a measure item is not displayed on the measures toolbar, use the global measure manager to set its state to visible again.
| Activate calculated measures manager |
The calculated measures manager dialog is used to add additional measures to those defined in the PivotCube. The value of these calculated measures may use the values of the defined measures, much like how calculated fields are used in a database table. Please see the visual guide on Calculated Measures Manager for more details.
| Activate individual measure manager |
The individual measure manager is used to set the attributes of each of the measures. It is identical to the global measure manager, except that you can only set the attributes of the selected measure.
| Filtered measure indicator |
When the values of a measure are filtered, the measure's button on the toolbar will change color to indicate that filtering is active. You can change this color using the TPVMeasureToolbar.ItemSettings.FilteredColor property.