Cube Dimension - Sales Part

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

Natural parent is contract/site, i.e. one site has one or more sales parts.

ATTRIBUTES

Attribute Hierarchy Description
Catalog Group NO Sales group (CATALOG_GROUP)
Catalog Group Desc NO Description of the sales group.
Catalog Type NO The sales part type (CATALOG_TYPE)
Catalog Type Desc NO The sales part type description (CATALOG_TYPE_DESC)
Price Unit of Measure NO Pricing Unit of Measure for the Sales Part
Sales Part NO Key. Defined as CONTRACT + ' - ' + CODE + ' - ' + CATALOG_DESC
Sales Part Code NO The CODE of the dimension, i.e. the sales part number
Sales Part Desc NO The sales part description (CATALOG_DESC)
SalesPartHierarchy YES Hierarchy defined as "Site No" -> "Sales Part"
Sales Unit of Measure NO Pricing Unit of Measure for the Sales Part

USED BY CUBE

Cube Name
MAINTENENCE
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SALES_PART_BI ORDEDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.020 Load IFSAppl_DIM_SALES_PART_BI.dtsx IFSAppl_DIM_SALES_PART_BI
T - DW 2.1.020 Load Dw_DIM_SALES_PART.dtsx Dw_DIM_SALES_PART
L - DM 3.1.020 Load Dm_DIM_SALES_PART.dtsx Dm_DIM_SALES_PART