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 |
NO |
Dim_Company.Company |
| Company - Organization Name |
NO |
COMPANY + ' - ' + ORGANIZATION_NAME as
COMPANY_ORGANIZATION_NAME |
| Country Code |
NO |
Dim_Company.Country Code |
| Name |
NO |
Dim_Company.Name |
| Organization Code |
NO |
Refered as Code in Dim_Organization_Code |
| Organization Hierarchy |
YES |
CASE PARENT_ORG_CODE WHEN '*' THEN NULL ELSE
COMPANY ||'^'|| PARENT_ORG_CODE ||'^' || DECODE(SIGN(VALID_TO -
TO_DATE('01-01-1900', 'DD-MM-YYYY', 'NLS_CALENDAR=GREGORIAN')), -1,
TO_CHAR(TO_DATE('01-01-1900', 'DD-MM-YYYY', 'NLS_CALENDAR=GREGORIAN')),
TO_CHAR(VALID_TO,'YYYY-MM-DD')) END as PARENT_ID |
| Organization Level |
NO |
Refered as Organization_Level_Name in
Dim_Organization_Code |
| Organization Name |
NO |
Dim_Organization_Code.Organization_Name |
| Hierarchy |
YES |
"Company" -> "Company - Organization Name"
|