Enable standard deviation for Data analytics

From version 9.7 the standard deviation for analysis realms can be calculated. For clients that have been migrated from PPM < 9.7 and had Data Analytics analysis realms, you can calculate the standard deviation by manually adapting the configuration accordingly.

Procedure

  1. Close CTK.
  2. If required, start the client's servers.
  3. For each analysis realm to be adapted, open the corresponding XML configuration file from the directory <PPM_CURRENT_DATA>/custom/<client>/xml in a text editor.
  4. For the measures you want to calculate the standard deviation for, remove the entry standdarddeviation="FALSE" from the respective <kidef> element.
  5. Save the file.
  6. Import the changed configuration of the analysis realm into PPM. Go to the directory <PPM_CURRENT_CLIENT_RUN>/bin and execute the following command in the command line.

    runppmconfig -client <client> -user system -password <password> -mode import -overwrite -realm <PPM_CURRENT_DATA>/custom/<client>/xml/<name of file>

The option for calculating the standard deviation is now available in Data analytics.

Example

<kidef name="amount_payment" table="payment"

column="amount" distribution="TRUE" standarddeviation="FALSE"

retrievertype="KEYINDICATOR" kigroup="KI_GROUP_TIME"

assessment="POS" scale="HOUR">

<description name="Amount" language="en" />

</kidef>

becomes

<kidef name="amount_payment" table="payment"

column="amount" distribution="TRUE"

retrievertype="KEYINDICATOR" kigroup="KI_GROUP_TIME"

assessment="POS" scale="HOUR">

<description name="Amount" language="en" />

</kidef>