This cube represents the human resouces dimension organization code and is
based on the IFS Applications dimensions DIM_COMPANY and DIM_ORGANIZATION_CODE.
The two dimensions are connected through the company column in each dimension.
| Attribute |
Hierarchy |
Description |
| Company Code |
NO |
Company Code |
| Company - Organization Name |
NO |
Built up as Company Code - Organization Name |
| Country Code |
NO |
Dim_Company.Country Code |
| Company Name |
NO |
Dim_Company.Name |
| Organization Code |
NO |
Refered as Code in Dim_Organization_Code |
| Corganization Code Name |
No |
Built up as Organization Code - Organization
Name |
| Company - Structure - Organization - Valid
To |
NO |
Key Column. Built up as Company Code -
Structure ID - Organization Code - Valid To Structure - Organization
Name |
| Organization Level |
NO |
Referred as Organization_Level_Name in
Dim_Organization_Code |
| Organization Name |
NO |
Organization Name |
| CompanyOrgHy |
YES |
"Company" -> "Organization
Code Name"
|