Add a measure to the cube.

When you press the Add or Edit button in section Creation of the cube Measures dimension , we get the following dialog:

In the dialog's upper section is shown a list of fields that can appear as a measure in the cube. The fields are:

  • Table : Table name in the database.
  • Field : Database field that you can choose. 
  • Alias : Alias assigned to this field.
  • Type: Data type assigned to this field. It can be either Char, Date or Number .

You can fill the following options:

  • Name : Name of this measure in the field.
  • Aggregate : Is the aggregation type you will assign to this field, in order to summarize the cube. The aggregates are:
    • Sum : Brings the sum of the field in relation to other fields of the query. It will add all it's query values to get it's final value.
    • Distinct values : Counts the number of distinct values this field have. This aggregate can apply to fields that are not of numeric data type.
    • Max : Brings the geatest value of the field.
    • Min : Brings the smallest value of the field.
  • Format: This is the output format of this measure in the cube. In the list you will find the following formats, although you can write your own format:
    • Default: Default format, no format is added.
    • Standard
    • Currency
    • Percentage
    • 0
    • 0.00
    • #,##0
    • #,##0.00
    • $#,##0
    • $#,##0.00
    • 0%: The value gets multiplied by 100
    • 0.00%: The value gets multiplied by 100
    • 00.00%: The value gets multiplied by 100
    • #,##0,.: The format is divided by 1000
    • #,##0,.00: The format is divided by 1000
  • Field type: This is the OLE DB type used to store this measure in the cube. Leave default if you don't wish to change its type. The field types are: DBTYPE_I2, DBTYPE_I4, DBTYPE_I8, DBTYPE_UI1, DBTYPE_UI2, DBTYPE_UI4, DBTYPE_UI8, DBTYPE_R4, DBTYPE_R8, DBTYPE_CY, DBTYPE_DECIMAL, DBTYPE_NUMERIC, DBTYPE_DATE.
  • Hide field: Select this option if you don't wish this measure to appear in the cube. For example, if there is only one measure, either see it or not see it won't make a difference. You could possible want to hide measures used in the cubes virtual formulas.

Press the OK button to define the measure or Cancel button to exit this dialogo with defining it.