Entity dimension: BPDENTITY
The BPDENTITY dimension is used for the legal company or entity structure of the organization. There is no separate staging table for the Entity dimension and there is no validation of data. Source system data is loaded directly into the Elements and Parents dimension tables.
The DIM_BPDENTITY_ELEMENTS table provides basic information including translated names for each legal entity. It does not contain parent-child information.
The bds_integration_bp_import_entity stored procedure populates the
DIM_BPDENTITY_ELEMENTS table.
This table describes DIM_BPDENTITY_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_BPDENTITY_PARENTS table provides parent-child structure information for the BPDENTITY dimension. If the source system has a flat list of entities (no hierarchy of entities), the parent for each element is TOTAL_BPDENTITY.
This table describes DIM_BPDENTITY_PARENTS:
| Field | Required | Description |
|---|---|---|
| ID | Y | Child element ID; must be a unique identifier. |
| PARENT | Y | Parent element ID. The default is TOTAL_BPDENTITY. |
| HIERARCHY | Y | Hierarchy name; normally the name of the dimension, BPDENTITY. |
| WEIGHT | Y | Weighting used for rolling up purposes; typically set to 1. |
| SORT | N | Sequence of elements in a dimension. |