Analysis dimensions: BPDANALYSIS_nn
Analysis dimension are custom or industry-specific dimensions used for reporting. Some of these dimensions are pre-defined for industry-specific Budgeting & Planning applications such as public sector and healthcare.
Analysis dimensions are distinct from financial segments involved in statutory consolidations.
Infor d/EPM provides 12 analysis dimensions (BPDANALYSIS_01 through BPDANALYSIS_12). Within industry-specific Budgeting & Planning applications, some are reserved, and the remaining ones are available for customer specific usage.
This table describes the analysis dimensions:
| Dimension name | Reserved | Public section purpose | Health care purpose | Description |
|---|---|---|---|---|
| BPDANALYSIS_01 | N | Grant | ||
| BPDANALYSIS_02 | Y | Fund | ||
| BPDANALYSIS_03 | Y | Appropriation | Pool | Used to track allotments of resources. Pool can be used within Capital Planning. |
| BPDANALYSIS_04 | N | Program | ||
| BPDANALYSIS_05 | N | Project | ||
| BPDANALYSIS_06 | Y | Decision Package | Decision Package | Reserved for Decision Package. |
| BPDANALYSIS_07 | N | Physician | ||
| BPDANALYSIS_08 | N | Payer | ||
| BPDANALYSIS_09 | N | Service Line | May be reserved for Product. | |
| BPDANALYSIS_10 | N | Cost Type | ||
| BPDANALYSIS_11 | N | Cost Category | ||
| BPDANALYSIS_12 | Y | Strategy | Strategy | Reserved for Strategy Management. |
There are no separate staging tables for the BPDANALYSIS_nn dimensions and there is no integration stored procedure to validate the data. You load source system data directly into the Elements and Parents dimension tables that Designer can import.
The DIM_BPDANALYSIS_01_ELEMENTS - DIM_BPDANALYSIS_12_ELEMENTS tables provide basic information, including translated names, for each analysis dimension element but do not contain parent-child information.
This table describes DIM_BPDANALYSIS_nn_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. |
| FORMAT | N | Format; normally 0. |
| CUBE | N | Cube name; normally NULL. |
| DIMENSION | N | Dimension name; normally NULL. |
| HIERARCHY | N | Hierarchy name; normally the name of the dimension, such as BPDANALYSIS_01. |
| CHILDSORT | N | Sequence of child elements beneath parent. |
| 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_BPDANALYSIS_01_PARENTS - DIM_BPDANALYSIS_12_PARENTS tables provide parent-child structure information for analysis dimension elements. If the source system has a flat list of analysis dimension elements, the parent for each element is TOTAL_ANALYSIS. For example: TOTAL_ANALYSIS01.
This table describes DIM_BPDANALYSIS_nn_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_ANALYSISnn. For example, TOTAL_ANALYSIS01. |
| HIERARCHY | Y | Hierarchy name; normally the name of the dimension, BPDANALYSIS_nn. For example, BPDANALYSIS_01. |
| WEIGHT | Y | Weighting used for rolling up purposes; typically set to 1. |
| SORT | N | Sequence of element in dimension. |