Details and interaction with Power BI
DimCostCenter(dCostCenter)
Regular dimension with the following columns:
- le_id - Long - Foreign key to DimLegalEntity
- cc_id - Long - Primary key for this dimension
- cc_number - String - The cost center number
- cc_name - String - The cost center name
- cc_label - String - Concatenated value of cc_number and cc_name
DimCostCenterHierarchy(dCostCenterHierarchy)
Regular hierarchy dimension based of the cost center Data Perspective, it contains the following columns:
- le_id - Long - Foreign key to DimLegalEntity
- cc_hierarchy_id - Long - Primary key for this dimension
- cc_id - Long - Primary key for this dimension
- mode - String - "Le" or "Cg" depending on whether the hierarchy belongs to the individual legal entity or to the corporate group
- group_n_code - String - The hierarchy group's identifier
- group_n_name - String - The hierarchy group's name
- group_n_sort_order - Integer - The hierarchy group's sort order