How to build performance formula with BSC Designer

BSC Designer calculates the performance of indicator according to its current value and the performance function.

After the installation BSC Designer offers two performance functions: maximization (when higher “value” means higher performance) and minimization (when lower “value” mean higher performance) both are linear.

When designing KPIs business professional might need some sophisticated, non-linear functions for the performance. Performance formulas in BSC Designer can be customized with Formula Editor.

Formula builder

To access Formula Builder:

  1. Run BSC Designer. Create new indicator or select existent one.
  2. Find “Optimization” field at the bottom and click Performance Editor button: Performance Editor
  3. Formula Builder dialog will appear

Let’s look at every element that could be used in this builder.

Variables

There are 5 variables in BSC Designer that can be used in formulas:

  • Min value = mn (builder syntax);
  • Max value = mx (builder syntax);
  • Target  value = target (builder syntax);
  • Baseline value = baseline (builder syntax);
  • Score Value = value (builder syntax).

BSC Designer Manual – Indicator Details

Operations

Formula Builder supports Basic mathematical operations: “+”, “-”, “*”, “/”.

Functions

Click the button “Function” in the Formula Builder to have a list of supported mathematical functions:

  • Sin (a) – The sine trigonometry function.
  • Cos (a) – The cosine trigonometry function.
  • Tan (a) - The tangent trigonometry function.
  • Power (a, b) – Exponentiation with the base of “a” and the exponent of “b”.

For example: power (2, 4) = 16;

  • Exp (a) – Exponentiation with the base of “e”-number and the exponent of “a”.
  • Sqrt (a) – Square root. Exponentiation with the base of “a” and the exponent of “0.5”.
  • Pi – the function returns the value of pi-number.
  • Min (a, b) – The function selects the smallest among two numbers.
  • Max (a, b) – The function selects the biggest among two numbers.

For example: Min (3, 5) = 3; Max (3, 5) = 5;

Customizing Formula

By default the formula field contains linear formula of maximization ((Score – mn) / (mx – mn)) or minimization ((mx – Score) / (mx – mn)). The formula can be modified and might contain any combination of available functions and variables. Some examples are listed below:

Default maximization formula: ((value- mn) / (mx - mn))


(sin(value/mx*2.5) - mn) / (mx - mn)



tan( ((value) - sqrt(mn)) / (mx - mn) )


min((exp(value)*exp(mx)), Power( sqrt(score), Pi)*0.9)

Conditions in the performance formula

There are also special conditions available for the variable called “value”. User can define different optimization functions for different intervals of the “value”. To define function for the certain interval:

  1. Run “Formula Builder”.
  2. Click on “Add Condition” button.
  3. Enter new function.
  4. Define the interval for this function below.

Setting up the special function for the values greater than 45. Below is the resulted graph for these conditions.


The performance graph for this function (after score riches 45 and more the graph begins to fluctuate)

For more information: