Skip to main content
Version: I2023.3.0

Adding Calculation Groups

When creating a calculation group you need to specify its name and the dimension attribute.

Prerequisites

You have accessed the Calculation Groups panel in the dimension editor. For details, see Using Dimension Calculation Groups.

Creating groups

  1. Open the menu next to the filter field in the panel, and choose New calculation group.

  2. In the Create Calculation Group dialog, enter a name that is unique for the current dimension.

  3. If you need use a specific query name (by default, it's the same as the name):

    1. Enable the Override generated query name option.
    2. In the Query Name field, enter a name that is unique for the current cube.
  4. Select a dimension attribute, a hierarchy or secondary attribute from the current dimension.

  5. Optionally, enter a description, and choose one of the existing folders for the current dimension.

  6. Choose Save.

image

The system creates the Calculation Group with the default calculation of "Current". The Current calculation echos the Measure value for a given result set coordinate. This calculation is required and cannot be deleted; however, the name of the "Current" calculation can be edited.

image

Next, add calculations to the group, as described in Adding a Calculation and Bulk Creation of Calculations.

Modifying groups

To modify an existing calculation group:

  1. Locate it in the the Calculation Groups panel.
  2. Open the dotted menu on the right of its name.
  3. To modify it: choose Edit, and change its parameters as described above.
  4. To remove it, choose Delete, and then confirm.