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