Convert to a regular dimension or measure

All regular dimensions begin as query subjects. If you converted a query subject to a regular dimension, note that determinant information for the query subject is leveraged as a starting point to define the levels of a single hierarchy.
About this task

You can convert a query subject into a regular dimension or a measure dimension when you want to use features associated with dimensions, such as defining hierarchies and levels. A model query subject becomes a model dimension. While you can convert data source query subjects to data source dimensions, data source dimensions have limited functionality in comparison to query subjects or model dimensions.

You can define regular and measure dimensions as model objects based on data source query subjects or model query subjects or both. If the query subject has determinants specified for it, the keys that you specified for each determinant are used to build a hierarchy with a business key for each level. The determinants form one hierarchy. The first string attribute for each determinant is used for the business caption. If the caption is not about the attribute that you want to use, you must change it manually. Converting a query subject into a dimension is simply a starting point. Examine each dimension that is created this way to make sure that it reflects your requirements.

  • Select the query subjects that you want to convert.
  • From the Actions menu, click Convert to Regular Dimension or Convert to Measure Dimension.
You can create a new regular dimension by merging existing objects. These objects can be dimensions, query subjects, or query items. Perform the following steps to convert a regular subject to a regular dimension:
  1. Select the objects that you want to convert to a dimension.
  2. In the Actions menu, click Merge in New Regular Dimension.
Example
What to do next

Feedback