Cube Dimension - Tool Equipment

This cube dimension represents the Tool Equipment and is based on the IFS Applications dimension DIM_TOOL_EQUIPMENT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Description NO Tool/Equipment Description
Ext Maint Responsible Name NO Maintenance Responsible Code (used if owned outside of the company)
External Acc Owner NO Accounting Owner Code (used if owned outside of the company)
External Acc Owner Name NO Accounting Owner Name (used if owned outside of the company)
External Maint Responsible   Maintenance Responsible Code (used if owned outside of the company)
Int Maint Responsible Name NO Maintenance Responsible Name (used if owned within the company)
Internal Acc Owner NO Internal Accounting Owner Code (used if owned within the company)
Internal Acc Owner Name NO Internal Accounting Owner Name (used if owned within the company)
Internal Maint Responsible NO Internal Maintenance Responsible Code (used if owned within the company)
Item Class Id NO Item Class Code
Lot Batch No   Lot- or Batch Number
Operator   Operator Code (company that is currently operating the unit)
Operator Name   Operator Name (company that is currently operating the unit)
Part No   Tool Part Number
Serial No   Tool Serial Number
Tool Equipment   Id + Description
Tool Equipment Id   Tool Equipment ID
Tool Equipment Type   Tool Equipment Type Code

Used By Cube

Cube Name
MAINTENANCE

ETL Information

ETL Step File Name of SSIS Package Table Name
DIM_TOOL_EQUIPMENT_BI TOOLDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.145 Load IFSAppl_DIM_TOOL_EQUIPMENT_BI.dtsx IFSAppl_DIM_TOOL_EQUIPMENT_BI
T - DW 2.1.145 Load Dw_DIM_TOOL_EQUIPMENT.dtsx Dw_DIM_TOOL_EQUIPMENT
L - DM 3.1.145 Load Dm_DIM_TOOL_EQUIPMENT.dtsx Dm_DIM_TOOL_EQUIPMENT