Cube Dimension - Sales Contract

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.

ATTRIBUTES

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)

USED BY CUBE

Cube Name
SALES CONTRACT

ETL Information

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