Exemplo

Este capítulo inclui um breve exemplo de configuração para um território de análise simples.

Exemplo

O território de análise contém as tabelas Funcionário e Cargo. Os nomes na tabela são únicos e podem ser usados como chaves primárias. O esquema do território de análise tem aparência a seguir.

s_ppm_da_realm_ex.png

O território de análise é configurado em XML da forma a seguir.

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