Enable standard deviation for Data analytics

If you had Data analytics analysis realms in the version to be migrated and want to calculate the standard deviation for measures in these analysis realms, you need to manually adapt the configuration accordingly.

Procedure

  1. Close CTK.
  2. If required, start the client's servers.
  3. For each analysis realm to be adjusted, open the corresponding XML configuration file from the directory <PPM99_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. To do so, go to the directory directory <PPM99_CLIENT_RUN>/bin and execute the following command in the command line.

    runppmconfig -client <client> -user system -password <password> -mode import -overwrite -realm <PPM99_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>