Cube Dimension - Service Contract

This cube dimension represents service contract line information and is based on the IFS Applications dimension DIM_SERVICE_CONTRACT_LINE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Service Contract NO The service contract id (CONTRACT_ID)
Service Contract Connection Type NO The connection type (CONNECTION_TYPE)
Service Contract Coordinator NO The name of the contract coordinator (CORRDINATOR_NAME)
Service Contract Currency NO Contract currency code (CURRENCY_CODE)
Service Contract Customer NO Customer name (CUSTOMER_NAME)
Service Contract Fixed Catalog NO Defined as the fixed catalog description (FIXED_CATALOG_DESC)
Service Contract Invoice Catalog NO Defined as the invoice catalog description (INVOICE_CATALOG_DESC)
Service Contract Invoice Rule NO Defined as the invoice rule description (INVOICE_RULE_DESC)
Service Contract Invoice Type NO Invoice type (client value)
Service Contract Line NO Key. Defined as CONTRACT_ID + ' - ' + CODE + ' - ' + DESCRIPTION. CODE represents the line number.
Service Contract Manager NO The name of the contract manager. ( CONTRACT_MANAGER_NAME)
Service Contract Name NO The contract name (CONTRACT_NAME)
Service Contract Type NO Defines as the contract type description (CONTRACT_TYPE_DESC)
Service Contract Work Type NO Defined as the contract work type description (WORK_TYPE_DESC)

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SERVICE_CONTRACT_LINE_BI PCMSDI Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.021 Load IFSAppl_DIM_SERVICE_CONTRACT_LINE_BI.dtsx IFSAppl_DIM_SERVICE_CONTRACT_LINE_BI
T - DW 2.1.021 Load Dw_DIM_SERVICE_CONTRACT.dtsx Dw_DIM_SERVICE_CONTRACT
L - DM 3.1.021 Load Dm_DIM_SERVICE_CONTRACT.dtsx Dm_DIM_SERVICE_CONTRACT