Financial segment dimensions: BPDxSEGMENT
Financial segments are involved in statutory consolidations. Budgeting at the financial segment level is optional. Configuration sets can be configured with or without primary, secondary or tertiary financial segment detail.
The three financial segment dimensions are structurally identical, but differentiated by P, S, or T in the dimension name:
- BPDPSEGMENT is the primary segment.
- BPDSSEGMENT is the secondary segment.
- BPDTSEGMENT is the tertiary segment.
If you intend to import one or more of these dimensions, follow the table specifications described in this topic.
The BPDxINTERSEGMENT dimensions are created automatically based on the contents of the BPDxSEGMENT dimension.
There are no separate staging tables for the BPDxSEGMENT dimensions 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_BPDxSEGMENT_ELEMENTS table provides basic information, including translated names, for each financial segment element, but does not contain parent-child information.
This table describes DIM_BPDxSEGMENT_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 element in dimension. |
The DIM_BPDxSEGMENT_PARENTS table provides parent-child structure information for primary, secondary, and tertiary financial segments. If the source system has a flat list of segment elements, the parent for each element is TOTAL_SEGMENT.
This table describes DIM_BPDxSEGMENT_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_SEGMENT. |
| HIERARCHY | Y | Hierarchy name; normally the name of the dimension, such as BPDPSEGMENT. |
| WEIGHT | Y | Weighting used for rolling up purposes; typically set to 1. |
| SORT | N | Sequence of element in dimension. |