This cube dimension represents sales contract and is based on the IFS Applications dimension DIM_SALES_CONTRACT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Sales Contract | NO | Key. Built as the CODE + ' - ' + CONTRACT_NAME |
Sales Contract Bid Status | NO | Contract bid status (client value) (BID_STATUS) |
Sales Contract Category 1 Desc | NO | Category 1 name (CATEGORY1_NAME) |
Sales Contract Category 1 Name | NO | Description of category 1 name (CATEGORY1_DESC) |
Sales Contract Category 2 Desc | NO | Category 2 name (CATEGORY2_NAME) |
Sales Contract Category 2 Name | NO | Description of category 2 name (CATEGORY2_DESC) |
Sales Contract Code | NO | The dimension CODE, i.e. the contract number |
Sales Contract District Code | NO | The district code (DISTRICT_CODE) |
Sales Contract District Desc | NO | The district description (DISTRICT_DESC) |
Sales Contract Manager | NO | The contract manager identity (CONTRACT_MANAGER) |
Sales Contract Manager Name | NO | The name of the contract manager ( CONTRACT_MANAGER_NAME) |
Sales Contract Market Code | NO | The market code (MARKET_CODE) |
Sales Contract Market Desc | NO | The market description (MARKET_DESC) |
Sales Contract Multiple Prospects | NO | Are there multiple prospects for the contract? (MULTIPLE_PROSPECTS) |
Sales Contract Name | NO | The sales contract name (CONTRACT_NAME) |
Sales Contract Prime Contract No | NO | Primary contract number (ORIME_CONTRACT_NO) |
Sales Contract Prospect Name | NO | Name of prospect (PROSPECT_NAME) |
Sales Contract Ref | NO | Contract reference (CONTRACT_REF) |
Sales Contract Region Code | NO | The sales region code (REGION_CODE) |
Sales Contract Region Desc | NO | The sales region description (REGION_DESC) |
Sales Contract Salesman | NO | Identity of salesman (SALESMAN) |
Sales Contract Salesman Name | NO | The name of the salesman (SALESMAN_NAME) |
Sales Contract State | NO | Status of sales contract (CONTRACT_STATE) |
Sales Contract Sub State | NO | Sub status of the sales contract (SUB_STATE) |
Sales Contract Sub State Desc | NO | Description of sub status (SUB_STATE_DESC) |
Sales Contract Supply Country | NO | Client name of supply country (SUPPLY_COUNTRY) |
Sales Contract Type | NO | Sales contract type (CONTRACT_TYPE) |
Sales Contract Type Desc | NO | Description of sales contract type (CONTRACT_TYPE_DESC) |
Sales Contract Win Probability | NO | Probability to win (WIN_PROBABILITY) |
Cube Name |
SALES CONTRACT |
BI Access View | BI Component | Recommended Source Type |
DIM_SALES_CONTRACT_BI | CONMDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.089 Load IFSAppl_DIM_SALES_CONTRACT_BI.dtsx | IFSAppl_DIM_SALES_CONTRACT_BI |
T - DW | 2.1.089 Load Dw_DIM_SALES_CONTRACT.dtsx | Dw_DIM_SALES_CONTRACT |
L - DM | 3.1.089 Load Dm_DIM_SALES_CONTRACT.dtsx | Dm_DIM_SALES_CONTRACT |