3

If I want to refer to measures/metrics and dimensions with a single term, what would be a good industry-accepted expression?

Metrics is used commonly in UIs as well such as Google Analytics or Tableau.

The context for my question is for a UI. I'd like to group both of them and refer to them with an industry-accepted name, if one exists.

MDCCL
  • 8,530
  • 3
  • 32
  • 63
Will E
  • 39
  • 3

2 Answers2

6

Dimensions and Measures are the two main components of cubes. The dimensions are basically ways to look at the data while the measures are the data.

When writing MDX the measures are a member of the [Measures] dimension but that is mostly a syntax convention.

As for a common name, I would say they both are partly definitions of a cube design. The measures define the values and the dimensions define how you slice or aggregate the measures.

The combined result of a query across dimension members and measures is called a cellset but that term is used for a result rather than a cube definition (which is what measures and dimensions are).

If there even is a common term for the combination of dimensions and measures it would be physical aspects of data aggregation

If I were to design a UI where I list both in an interface for users to add a report I would probably call them 'report items' or 'data components' or something but I think the clearest for an end user would be to follow what Excel does and label them 'rows' or 'columns' and 'values' where things you can add to rows/columns are the dimensions and values are the measures.

I don't think it's any clearer to an end user to try and find a common name and from a UI design perspective I would make a distinction between things they should put on an axis and 'values'.

Tom V
  • 15,752
  • 7
  • 66
  • 87
-1

I would call the screen "Measuring" and there you can define your "Dimensions", like X, Y, Z, time and then use the dimensions to perform "Measures" (is that a word?) or "Measurements" like 5 meters, 20 seconds.