When all dimensions in a cube have a relationship with a measure group, any two intersections in the multi-dimensional cube can be a different value.
When only some dimensions in a cube have a relationship with a measure group, only those dimensions with a relationship can show different values for the measures in the group. Moving along a dimension that has no relationship with the measure group always results in the same value. This value depends on the measure aggregator.
After assigning a measure group and specifying its properties, you can use a Measure Group in a data cube. See Creating a New Cube.
-
Expand the schema in the Schema Tree View, right-click the Measure Groups folder, and click New Measure Group.
The Measure Groups panel opens in the Schema Element Properties View.
- In the Name box, type a name for the new measure group, then click the Caption box. The caption automatically fills with the same name as the level. The caption is a name that is displayed and can be localized to different languages in the BI client application. See Cube Schema Localization.
-
In the Fact Table list, select the option containing measures for this group.
A measure group can only group measures from a single fact table. However, the same fact table can be used for multiple measure groups.
The list of measures available to the fact table display.
-
(Optional) In the Use list, select one of the following:
- To make a calculation-only measure available in BI client, select Visible.
- To restrict a calculation-only measure from BI client availability, select Not Visible.
- To completely restrict using a calculation-only measure, select Inactive.
You can click the Set All Visible, Set All Not Visible, or Set All Inactive button to set all measures to the same value.
- Select the Dimension Usage tab. The list of dimensions available in the schema display dimension names and captions. The measure group can use a subset of dimensions related to the selected fact table.
-
To associate a dimension with this measure group, check the boxes in the Use column. You can click the Check All or Uncheck All button to select or deselect all listed dimensions.
The Fact Table column indicates RELATED or NO RELATION status for each dimension. Dimensions in the schema not related to the fact table appear but are not selectable.
- [Optional] Enable Drill-Through. (See Drill-Through.)