Example

This chapter includes a brief configuration example for a simple analysis realm.

Example

The analysis realm contains the two tables Employee and Position. The names in the table are unique and can be used as primary keys. The analysis realm scheme looks as follows.

s_ppm_da_realm_ex.png

The analysis realm is configured in XML as follows.

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE realm SYSTEM "analysisrealm.dtd">

<realm keyword="Employee-Positions">

<descriptions>

<description

name="Employee positions"

language="de">Positionen der Mitarbeiter...

</description>

<description name="Employee positions" language="en">

Positions of employees...

</description>

</descriptions>

<tables>

<table keyword="employee">

<column keyword="name" datatype="TEXT"/>

<column keyword="age" datatype="LONG"/>

<column keyword="start_date" datatype="TIME"/>

</table>

<table keyword="position">

<column keyword="name" datatype="TEXT"/>

<column keyword="position" datatype="TEXT"/>

<column keyword="salary" datatype="DOUBLE"/>

</table>

</tables>

<criterion-definitions>

<kidef name="employee_age" table="employee" column="age"

comment="an optional comment"

distribution="FALSE"

standarddeviation=#IMPLIED

retrievertype="NUM_KEYINDICATOR" kigroup="SomeGroup"

assessment="POS">

<description name="Alter" language="de"></description>

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

</kidef>

<kidef name="position_salary" table="position" column="salary"

comment="an optional comment" internal="no"

distribution="FALSE"

standarddeviation="FALSE"

retrievertype="NUM_KEYINDICATOR" kigroup="SomeGroup"

assessment="POS">

<description name="Gehalt" language="de"></description>

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

</kidef>

<oneleveldim name="employee_name"

comment="an optional comment" internal="no" dimgroup="SomeGroup">

<description name="Mitarbeitername" language="de"/>

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

<leveldesc>

<dimitem table="employee" column="name">

<description name="Mitarbeitername" language="de"/>

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

<defaultvalue>"SomeName"</defaultvalue>

</dimitem>

</leveldesc>

</oneleveldim>

<oneleveldim

name="position_name"

comment="an optional comment" internal="no" dimgroup="SomeGroup">

<description name="Mitarbeitername" language="de"/>

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

<leveldesc>

<dimitem table="position" column="name">

<description name="Mitarbeitername" language="de"/>

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

<defaultvalue>"SomeName"</defaultvalue>

</dimitem>

</leveldesc>

</oneleveldim>

<oneleveldim name="position_title"

comment="an optional comment" internal="no" dimgroup="SomeGroup">

<description name="Position" language="de"/>

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

<leveldesc>

<dimitem table="position" column="title">

<description name="Position" language="de"/>

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

<defaultvalue>"Software Developer"</defaultvalue>

</dimitem>

</leveldesc>

</oneleveldim>

<timedim name="start_date" table="employee" column="start_date"

comment="optional comment" precision="DAY" scale="DAYSCALE"

refinement="BY_MONTH" dimgroup="SomeGroup">

<description name="Anfangsdatum" language="de"></description>

<description name="Start date" language="en"></description>

</timedim>

</criterion-definitions>

<associations>

<table-association>

<criterion-association>

<criterion-reference name="employee_name "/>

<criterion-reference name="position_name"/>

</criterion-association>

</table-association>

</associations>

</realm>