Model: Maintenance - Specifications for Dimension Table: SLA ORDER

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: SLA ORDER.

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

Attributes

Attribute	Description (where applicable)
Company Code	Company Code
SLA Order	Built up as CODE + '- ' + DESCRIPTION
SLA Order Code	SLA Order Code
SLA Order Created By	User ID of responsible for creating SLA Order
SLA Order Created Date	Created date of SLA Order
SLA Order Desc	SLA Order Description
SLA Order Status	SLA Order status Code
SLA Order Template ID	STemplate ID if SLA Order created from template

Hierarchies

Hierarchy	Level
SLAOrderHy
	Company Code
	SLA Order

USED BY MODEL(S)

Model Name

Maintenance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
SLA ORDER	DIM_SLA_ORDER_TM	DIM_SLA_ORDER_BI	DIM_SLA_ORDER	On Line