Measures

A measure is a numeric field whose values can be aggregated and analyzed in an OLAP cube. Common measures include Sales Total, Costs, Margins, and Quantities. Measures provide the quantitative data for cube analysis, enabling comparisons, calculations, and trend identification.

Within the OLAP Manager, measures are organized into Measure Groups. These groups improve navigation and usability by categorizing measures for quicker access during analysis. Measure groups have no impact on cube functionality, but it is considered best practice to organize measures logically — for example, grouping value-based measures separately from quantity-based measures. Before creating a measure, you must first create a measure group.

You can refresh measure data at any time by clicking Refresh Screen Data in the Options panel.

Add measures to a cube

Make the cube editable

1. In the Administration page, select OLAP Manager from the sidebar.
2. In the cube list, select the cube where you want to create measures.
3. Clear the In Production checkbox.
4. Click Save.

Create a measure group

1. In the Options panel on the right, click the Navigation icon.
2. Select Slices.
3. In the Options panel, click the Add Folder icon.
4. Enter a group name.
5. Click Save.

Create a measure

1. In the measure list, expand a dimension group.
2. Click Add.
3. In the Measure Properties panel, fill in all required fields.
4. Click Save.

Measure properties

Field	Description
Description	Text label identifying the measure.
Field Name	Name for the column in the cube table. Use only uppercase letters and avoid SQL keywords. Example: ...
Data Type	.NET data type that most closely matches the data source type.
Folder	Measure group where the measure is stored.
Precision	Size of the data type, if applicable.
Scale	Number of decimal places for the Decimal data type.
Summarizable	System behavior where the sum of the measure value is calculated at the cube aggregation level. When selected, the cube calculates the aggregation totals for measures such as Quantity, Amount, Margin, or Cost. When cleared, measures remain at 0. It is strongly recommended to keep this option selected.

Manage measure groups

Edit a measure group name

1. In the measure list, expand a measure group.
2. Modify the group name.
3. Click Save.

Delete a measure group

1. In the measure list, expand a measure group.
2. Click Delete.
3. In the confirmation message, select the confirmation option, and then click Yes.

Manage measure

Edit a measure

1. In the measure list, expand a measure group.
2. Select a measure to open the Measure Properties panel.
3. Make the necessary changes.
4. Click Save.

Delete a measure

1. In the measure list, expand a measure group.
2. Select a measure to open the Measure Properties panel.
3. Click Delete.
4. In the confirmation message, select the confirmation option, and then click Yes.