Converting measures into query items

If you have created a measure dimension and want to join it to regular dimensions, you need to create joins. Joins need keys and keys are query items, not measures. The measure that you want to use as a key must be converted into a query item.

You can also convert a query item into a measure Converting query items into measures.

Procedure

  1. Double-click the measure dimension that contains the measure.
  2. Click the Measure Dimension tab.
  3. Right-click the measure, and click Convert to Query Item, OK.