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 |
Dimension of RELATION or PROCESS type. |
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.