Calculations

The IBM Cognos Transformer modeler can add calculated categories to a cube to eliminate the need for report authors to recreate common calculations in different reports. Calculated categories appear in the dimension viewer with a calculator icon .

The following differences exist for calculations in Explorer versus Reporter reports:

• In Explorer, you can perform all calculations except minimum, maximum and average.
• In Reporter, you can perform all calculations except forecast.
• In Reporter, you can perform group calculations when you want to repeat the same calculation for many categories.
• In Reporter, you can specify a precedence order for calculations.
• In Explorer, the position of the calculation is automatically determined based on the operands. You can not change the location of the calculation.
• In Reporter, the calculation is inserted after the pointer position. You can delete or move categories that are part of the calculation, or the calculation, without affecting the calculation.
• In Explorer, the label and values of the calculation are italicized. The italic formatting is removed when you switch to a Reporter report.
• In Explorer, if you drill down to the lowest level, a single category appears. You cannot perform calculations on this category.

For both Explorer and Reporter reports, you cannot perform calculations on the 'Other' category (80/20 suppression).

The following size limits apply to values you specify when using calculations:

• maximum 1.7976931348623158e+308
• minimum 2.2250738585072014e-308

After adding calculations to reports, you may want to format the labels and values. For example, you can change the default label.