Skip to main content

Select Dimensions and Measures

Selecting dimensions and measures defines how your cube organizes and processes data. Dimensions are descriptive fields (such as Product, Customer, or Date) that determine how measures are grouped for analysis. Measures are numeric fields (such as Sales Amount, Quantity, or Margin) that provide the values to be aggregated.

Accurate selection ensures the cube produces meaningful reports and calculations, and improves performance by only including relevant fields.

Preview a cube dimension or measure​

  1. In the Options panel on the right, click the Preview icon.
  2. Select Quick Preview Dimensions or Quick Preview Measures.
  3. Use the search bar to locate specific dimensions or measures.
  4. Close the dialog when finished.

Available dimensions or measures dialog​

ColumnDescription
DescriptionText label identifying the dimension or measure.
Field NameField name given in the cube.
Data Type.NET data type that most closely matches the data source type.
ParentGroup (dimension group or measure group) to which the field belongs.
PrecisionSize of the data type, if applicable.
ScaleNumber of decimal places for the Decimal data type.

Add fields to dimensions and measures​

When you save your changes, the selected fields appear immediately in the Dimensions and Measures Fields List on the right side of the Data Source Editor. From there, you can further configure or preview them before building the cube.

Using the checkboxes​

  1. In the Workspace, select a table and expand it to see its fields.
  2. In the table list, use the search bar to locate the field you want.
  3. Select the Dimensions or Measures checkbox for the field.
  4. Repeat the process for other fields as needed.
  5. In the Options panel, select Save Data Source.

Using the Options panel​

  1. In the Workspace, select a table and expand it to see its fields.
  2. In the table list, use the search bar to locate the field you want.
  3. In the Options panel on the right, click the Table Field icon.
  4. Select Add as Dimension or Add as Measure.
  5. Repeat the process for other fields as needed.
  6. In the Options panel, select Save Data Source.