In All key performance indicators can be managed in the menu "Key Performance Indicators → Management" all key figures can be managed.
To create a new key figure performance indicator, click on the "Create new KPI" button. A new page then opens on which opens, here you can enter the data for the key performance indicator can be entered. This It includes data such as the name, description and formula. The reporting requirement can be selected. An existing key performance indicator can be copied if the same key figure KPI is to be calculated more than once, for example for different reporting requirements. To do thisso, select the desired required key performance indicator in the upper drop-down menu and then click on "Copy". This automatically fills in out all the fields that have been setselected, such as name and reporting requirement. However, the name must still be changed, since there must not be any key performance indicators with the same name. Check the box "Cross Reference KPI" to create a cross-reporting requirement key figure. In the Formula Wizard you can then switch between different reporting requirements. The option "Growth Rate" is available if the option "Cross reference" is not selected. These options define a key performance indicator that shows the absolute or relative growth compared to the data of the previous period. ABC Bank | 31.12.2015 | 31.03.2016 | 30.06.2016 | 31.12.2015 | 31.03.2016 |
---|
1000 | 1000 | 1100 | 1200 | 1150 | 1250 | Shareholders' equity Change quarterly (percent) |
| 10% | 9% | -4% | 9% | Shareholders' equity Change annually (percent) |
|
|
|
| 25% | Shareholders' equity Change quarterly (absolute)
|
| 100 | 100 | -50 | 100 | Shareholders' equity Change annual (absolute) |
|
|
|
| 250 |
If such a filing does not exist, the system issues displays a corresponding message. Check the box "Calculate if value missing" to set the default value to 0.00 for all empty cells.
The formula wizard makes it easy to enter key performance indicator formulas. Click on the "Add cell" button to add a single new cell. A new window opens in which ; here you can select the taxonomy, table, column, row, and Z axis. For more information on creating key performance indicators with the formula wizard, see formula wizard. For cross - reporting requirement key figures, you also have the option of selecting a reporting requirement. For key figures that are not cross-reporting requirements, this field is not available and the request reporting requirement can only be selected in the main view "Create New Key Performance Indicator". After you have clicked Click on the "Add" button , to add the cell is added to the formula. The "Sum" and "Maximum" buttons calculate the sum and maximum , respectively, for the selected cell range. The "AmountValue" button allows you to add the absolute value for the selected cell. The operator buttons are used to enter the corresponding operators. Click on the "OK" button to transfer the formula to the main formula field.
Basic rules for creating key figures performance indicators: - Cell or range specifications are always encapsulated in curly brackets.
- Partial definitions of a cell or a range are separated by commas (e.g. {r010, c010}).
If a key performance indicator is marked as "Personal KPI", it is only visible to the user who created it. The option can only be changed by this user. In this view, you can also select the currency in which the calculation result is displayed. When all After entering the data has been entered, press "Save" to create the new key performance indicator. Afterwards you are forwarded to the KPI overview page.
You can set global materiality and warning limits by clicking on "Thresholds", see Thresholds. |