Cube Dimension - SLA ORDER

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

ATTRIBUTES

Attribute Hierarchy Description
Company Code NO Company Code
SLA Order NO Key. Built up as CODE + '- ' + DESCRIPTION
SLA Order Code NO SLA Order Code
SLA Order Created By NO User ID of responsible for creating SLA Order
SLA Created Date NO Created date of SLA Order
SLA Order Desc NO SLA Order Description
SLA Order Status NO SLA Order status Code
SLA Order Template ID NO STemplate ID if SLA Order created from template
SLA Order Hy YES Defined as "Company Code" -> "SLA Order"

Used By Cube

Cube Name
MAINTENANCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.190 Load IFSAppl_DIM_SLA_ORDER_BI.dtsx IFSAppl_DIM_SLA_ORDER_BI
T - DW 2.1.190 Load Dw_DIM_SLA_ORDER.dtsx Dw_DIM_SLA_ORDER
L - DM 3.1.190 Load Dm_DIM_SLA_ORDER.dtsx Dm_DIM_SLA_ORDER