8.2 Dimensions
This category defines business dimensions that provide contextual metadata to fact entities. Dimensions help in slicing and dicing data for reporting and analytical needs.
Entities
1. Stage Dimensions Hierarchy Interface
- Primary Keys (PK): Hierarchy Code, Parent Member Numeric Identifier, Child Member Numeric Identifier
2. Stage Dimensions Members Interface
- Primary Keys (PK): Member Numeric Identifier
3. Stage Dimensions Attribute Interface
- Primary Keys (PK): Member Attribute Name, Member Numeric Identifier
4. Stage Dimensions Translation Interface
- Primary Keys (PK): Member Numeric Identifier, Multi Language Code
Note:
There is 1 LOV mapping in this category.Variable mappings are not required for Dimensions tables, so they are
not listed here.
Table 8-3 List of connectors
| # | Connector Name | Primary Source | Target | # of fields | # of key fields | # of Direct Mapping | # of LOV Mapping |
|---|---|---|---|---|---|---|---|
| 1 | Dimensions | Preparation Dimensions Hierarchy | Stage Dimensions Hierarchy Interface | 8 | 3 | 4 | 1 |
| 2 | Dimensions | Preparation Dimensions Members | Stage Dimensions Members Interface | 8 | 1 | 6 | 1 |
| 3 | Dimensions | Preparation Dimensions Attribute | Stage Dimensions Attribute Interface | 5 | 2 | 2 | 1 |
| 4 | Dimensions | Preparation Dimensions Translation | Stage Dimensions Translation Interface | 8 | 2 | 5 | 1 |