Cube Dimension - SLA

This cube dimension represents the Service Level Agreements (SLA) data in form Service Contract Basic Data and is based on the IFS Applications dimension DIM_SC_SLA. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Calendar Desc NO Calendar Description
Calendar Id NO Calendar Code
Company Code NO Company Code
Cut Off Time H NO Cut-off Time Hours
Cut Off Time M NO Cut-off Time Minutes
Last Loaded NO Last Data warehouse update time
Modified By User NO Responsible user data warehouse update
Resolution Time H NO Resolution Time Hours
Resolution Time M NO Resolution Time Minutes
Response Time H   Response Time Hours
Response Time M   Response Time Minutes
Primary Scheduling Type   The identity of the primary scheduling type
Primary Scheduling Type Desc   The description of the primary scheduling type
Secondary Scheduling Type   The identity of the secondary scheduling type
Secondary Scheduling Type Desc   The description of the secondary scheduling type
Secondary Scheduling Type Duration   The duration in hours for the default secondary scheduling type
SLA   Company + SLA Id + SLA Description
SLA Desc   SLA Description
SLA Displaceable Until Days   Displaceable until Number of Days
SLA ID Desc   SLA ID + Description

Used By Cube

Cube Name
MAINTENANCE

ETL Information

BI Access View BI component Recommended
Source Type
DIM_SC_SLA SRVCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.148 Load IFSAppl_DIM_SC_SLA_BI.dtsx IFSAppl_DIM_SC_SLA_BI
T - DW 2.1.148 Load Dw_DIM_SC_SLA.dtsx Dw_DIM_SC_SLA
L - DM 3.1.146 Load Dm_DIM_SC_SLA.dtsx Dm_DIM_SC_SLA