Add an asymmetric calculation to a Classic view

You can now create calculations that apply to nested dimension sets on rows or columns in a view. Because these calculations are applied to specific selected members and are not common to all nested sets for the dimension, they are called asymmetric calculations.

About this task

Asymmetric calculation can be confined within a single nested set or span multiple nested sets of the same dimension.

In this example, which is confined within a single nested set, you can see the Putters+Woods asymmetric calculation in the Products set. It calculates the total of Putters and Woods in Canada. Note that the calculation appears just once; it is not duplicated in both nested Products sets.

single nested set asymmetric calculation

This example shows the Golf Accessories + Putters asymmetric calculation, which spans multiple nested sets of the Product dimension. It calculates the total of Golf Accessories in the United States plus Putters in Canada. Though the calculation spans the nested Products set for both United States and Canada, it appears only in the nested Products sets for Canada.

multiple nested set asymmetric calculation

Note that an asymmetric calculation is calculated using the specific members you select in the context of a nested dimension. In the previous example, Golf Accessories + Putters is always the sum of Golf Accessories in the United States plus Putters in Canada. This is not a general calculation definition of Golf Accessories + Putters that is applicable across the Products dimension; it is always the calculation of Golf Accessories in the United States plus Putters in Canada.

This is important to understand, because the asymmetric calculation is available for selection in the set editor. However, regardless of where you place the calculation in a set, it is always calculated using the originally selected members in context of nesting. For this reason, it is a good idea to assign a clearly descriptive name to an asymmetric calculation.

Procedure

  1. Click the Targeted selection icon for the axis where you want to create the asymmetric calculation. Targeted selection icon for rows for rows and Targeted selection ison for columns for columns.
  2. Select the members you want to be included in the calculation. Use CTRL+click to select multiple non-adjacent members, use SHIFT+click to select multiple adjacent members. The asymmetric calculation will be inserted adjacent to the last member you select.
  3. Right-click a selected member, then click Create calculation.
  4. Optionally, enter a descriptive name for the calculation.
    If you create a calculation without entering a descriptive name, the calculation is assigned a name that reflects the calculation type you choose, with references to the nested set members included in the calculation. For example, Golf Accessories + Putters or median (Irons, Putters, Woods).
  5. Select the calculation you want to apply. See Member calculations for more details on the calculation that are available.
  6. Click OK.
  7. To remove a calculation, right-click the calculation label in the view, then click Remove.