Definition of relation and organizational dimensions

All dimension types (except search dimensions) can be defined as relation or organizational dimensions using the dimtype XML attribute (see chapter on Definition of dimensions). These dimension types are only available for evaluations in the Organizational analysis module. These dimensions are indicated by yellow symbols in the user interface. For relation dimensions, the location attribute also specifies which object of the relation is searched for the corresponding dimension values (attributes). By default, this is the relation itself.

Relation and organizational dimensions are configured using the following XML elements and XML attributes in the measure configuration:

XML tag

Description

name

Unique key word for dimension. Referenced in the refdim XML element in the relation definition (see Definition of relations chapter). Recommended prefix: REL_

dimtype

RELATION (Relation dimension)
OT_ORG (Organizational dimension)

location
(optional)

Only for type="RELATION"

Valid values: SOURCE (the attribute from which the dimension value is taken, search performed on the source reference object of the relation.)
TARGET (the attribute from which the dimension value is taken, search performed on the target reference object of the relation.)

THIS (default value: The search for the attribute from which the dimension value is taken is performed on the relation itself)

Examples (extracts from measure configuration)

Time dimension as relation dimension:

...

<timedim name="REL_CO_TIME" dimtype="RELATION"

attrname="AT_END_TIME" location="TARGET"

tablename="FUNC_ENDTIME" precision="HOUR"

dimgroup="DIM_GROUP_TIME" storage="DIMTABLE"

calculated="FALSE" internal="no"

earlyalert="no" importmode="OPTIONAL">

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

</timedim>

...

Two-level dimension as organizational dimension:

...

<twoleveldim name="FROMORG" dimtype="OT_ORG"

dimgroup="DIM_GROUP_CRITERIA" internal="no"

importmode="OPTIONAL">

<description language="de"

name="Organisationseinheit (Start)"/>

<leveldesc>

<dimitem attrname="AT_ORGGRP"

colname="GRP" calculated="FALSE">

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

</dimitem>

</leveldesc>

<leveldesc>

<dimitem attrname="AT_OBJNAME"

colname="NAME" calculated="FALSE">

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

</dimitem>

</leveldesc>

</twoleveldim>

...

Warning

Search dimensions (searchdim XML element) cannot be defined as either relation dimensions or organizational dimensions.