Show TOC

Tab: CalculationsLocate this document in the navigation structure

On the Calculations tab, you can configure local calculation settings for a formula or a key figure.

Local calculations are performed (on the client) on the result set provided by your BW system. This allows you to recalculate results or single values from a report based on specific criteria. On the Calculations screen, you can specify for a structure component which rules are used to recalculate result rows and/or single values, and in which direction the calculations are performed.

Note

For example, you can create ranking lists or calculate the total of a top 10 product list.

Note the following features:

  • Local calculations only work on the displayed data. This means that local calculations only change how the values are displayed. For any subsequent calculations (such as formulas), the system uses the original values calculated by the BW system and NOT the display values changed by the local calculations.
  • Local calculations cannot be applied to hierarchies.
  • If you are processing large result sets, local calculations can take significantly more time to perform.
    Note

    For performance reasons, we recommend that you work with exception aggregation and calculated key figures. This is because all the operations executed on the server can be processed significantly faster (especially when using the SAP HANA database).