Organization dimension: BPDORGANIZATION

The BPDORGANIZATION dimension is used to hold organizational structures such as departments or cost centers. Configuration sets can be configured with or without organizational detail.

There is no separate staging table for the Organization dimension and there is no validation of data. Instead, you load source system data directly into the Elements and Parents dimension tables that Designer can import.

The DIM_BPDORGANIZATION_ELEMENTS table provides basic information, including translated names for each organization. It does not contain parent-child information.

The bds_integration_bp_import_dimensions stored procedure populates the DIM_BPDORGANIZATION_ELEMENTS table.

This table describes DIM_BPDORGANIZATION_ELEMENTS:

Field Required Description
ID Y Element ID; must be a unique identifier.
TYPE N

N (numeric, this is the typical value)

S (string)

H (hierarchy)

NAME Y Caption for the element. Unique names are recommended.
LANG_CS N Element name translated into Czech.
LANG_DA N Element name translated into Danish.
LANG_DE N Element name translated into German.
LANG_EN N Element name translated into English.
LANG_ES N Element name translated into Spanish.
LANG_FR N Element name translated into French.
LANG_IT N Element name translated into Italian.
LANG_JA N Element name translated into Japanese.
LANG_NL N Element name translated into Dutch.
LANG_NO N Element name translated into Norwegian.
LANG_PL N Element name translated into Polish.
LANG_PT_BR N Element name translated into Brazilian Portuguese.
LANG_RU N Element name translated into Russian.
LANG_SV N Element name translated into Swedish.
LANG_ZH_CHS N Element name translated into Simplified Chinese.
SORT N Sequence of elements in a dimension.

The DIM_BPDORGANIZATION_PARENTS table provides parent-child structure information for organization elements. If the source system has only a flat list of organizations (no hierarchy of organizations), the parent for each element is TOTAL_BPDORGANIZATION.

This table describes DIM_BPDORGANIZATION_PARENTS:

Field Required Description
ID Y Child element ID; must be a unique identifier.
PARENT Y Parent element ID; if the source system has a flat list of elements, the parent for each element is TOTAL_BPDORGANIZATION.
HIERARCHY Y Hierarchy name; normally the name of the dimension, BPDORGANIZATION.
WEIGHT Y Weighting used for rolling up purposes. The default is 0.
SORT N Sequence of elements in a dimension.