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.
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 |
Cube Name |
SALES CONTRACT |
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 |