Beispiel

Dieses Kapitel zeigt ein kurzes Konfigurationsbeispiel eines einfachen Analyseraums.

Beispiel

Der Analyseraum enthält die beiden Tabellen Employee und Position. Die Namen in der Tabelle sind eindeutig und können als Primärschlüssel verwendet werden. Der Analyseraum sieht schematisch wie folgt aus.

s_ppm_da_realm_ex.png

Der entsprechende Analyseraum wird wie folgt in XML konfiguriert.

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

<!DOCTYPE realm SYSTEM "analysisrealm.dtd">

<realm keyword="Employee-Positions">

<descriptions>

<description

name="Mitarbeiterpositionen"

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

</description>

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

Positions of the Employ-ees...

</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>