CUBE DIMENSION - SALES CONTRACT LINE

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

ATTRIBUTES

Attribute Hierarchy Description
Contract No NO The contract number (CONTRACT_NO) the sales contract line belongs to.
Sales Contract Line Code NO The CODE of the dimension, i.e. line number
Sales Contract Line Description NO The description of the sales contract line (LINE_DESCRIPTION)
Sales Contract Line Id NO Key. Built as CONTRACT_NO + '^' + REV_SEQ + '^' + LINE_NO
Sales Contract Line Name NO The name of the sales contract line (LINE_NAME)
Sales Contract Line Rev Seq NO The revision number of the sales contract line

USED BY CUBE

Cube Name
SALES CONTRACT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SALES_CONTRACT_LINE_BI CONMDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.087 Load IFSAppl_DIM_SALES_CONTRACT_LINE_BI.dtsx IFSAppl_DIM_SALES_CONTRACT_LINE_BI
T - DW 2.1.087 Load Dw_DIM_SALES_CONTRACT_LINE.dtsx Dw_DIM_SALES_CONTRACT_LINE
L - DM 3.1.087 Load Dm_DIM_SALES_CONTRACT_LINE.dtsx Dm_DIM_SALES_CONTRACT_LINE