Definition of relations

Relations are the basis for the definition of relation measures and relation dimensions. They are defined in the measure configuration.

A relation exists between a source reference dimension and a target reference dimension (see Reference dimensions chapter) and has a name and a relation calculator assigned using the calcrel XML element.

XML tag

Description

relation

Relation definition

name

Unique key word for the relation for internal referencing

id

Unique integer between 0 and 999 under which the corresponding database table is created

description

Language-specific user interface name. This must be specified in the default language.

sourcedim

Source reference dimension. Only one or two-level dimensions of OT_FUNC or OT_ORG type (see chapter on Reference dimensions)

targetdim

Target reference dimension. Only one or two-level dimensions of OT_FUNC or OT_ORG type (see chapter on Reference dimensions)

refki

At least one measure of the RELATION type

refdim
(optional)

Dimension of RELATION or PROCESS type.
Each referenced dimension can only be evaluated in the context of the specified relation.

Example

(extract from Keyindicator.xml)

...

<relation name="REL_CARRY_OUT" id="0">

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

<sourcedim name="FROMORG" />

<targetdim name="FUNCTION" />

<refki name="REL_CO_CORATE" />

<refki name="RNUMA" />

<refki name="REL_CO_DLZ" />

<refki name="ORGCAPA" />

<refki name="REL_CO_COST" />

<refdim name="REL_CO_TIME" />

</relation>

...

Warning

Do not use the same dimension as the source and target reference dimension of a relation. This leads to the measure configuration import being aborted with a corresponding error message.

You cannot reference any cardinality measures in the refki XML element.