Function documentationFormula Editor

 

In this function, you use existing key figures as the basis for defining formula-based key figures, which you can then display in the Analyzer Information System (AIS).

Integration

The system calculates formula-based key figures at runtime only. This takes place when the Analyzer Information System is called. In the Analyzer Information System, the system displays the formula-based key figures and the key figures that you stored in the initial layout for the AIS. Unlike the other key figures, the formula-based key figures are not stored in the database.

When the AIS is called, the system checks all the formulas of the initial layout. If errors occur, the system does not display the formulas in question. However, it does display an error log. This occurs if, for example, you used key figures to define formulas and these key figures were deleted from the initial layout.

Prerequisites

  • You have defined all the key figures you need for the formula-based key figures.

  • If you want to use book values for formula-based key figures, you have entered the settings required to import them into the system.

Activities

  1. In Customizing for Financial Supply Chain Management, choose Start of the navigation path Treasury and Risk Management Next navigation step Market Risk Analyzer End of the navigation path or Start of the navigation path Portfolio Analyzer Next navigation step Results Database Next navigation step Define Formulas for AIS End of the navigation path.

    The system displays the initial layouts that have already been defined.

  2. Select the initial layout, and choose the area for which you want to define formula-based key figures.

    In this area, the system displays the formula-based key figures that exist.

  3. If required, create a new formula-based key figure.

  4. To store a formula for the formula-based key figure, select a key figure and choose Formula Editor.

    The system opens the formula editor.

  5. Define the formula as required, and save your entries.

    The formula editor contains the basic mathematical functions and an if function for defining formula-based key figures.

    Note Note

    To display the documentation about the formula editor, choose Information.

    End of the note.