Cube Dimension - Cust Invoice Type

This cube dimension represents customer invoice type and is based on the IFS Applications dimension DIM_CUSTOMER_INVOICE_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

Natural parent is company, i.e. each company has its own set of customer invoice types.

 

ATTRIBUTES

Attribute Hierarchy Description
Customer Invoice Type NO Key. Defined as COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION represented by the ETL column COMPANY_CODE_DESCRIPTION.
Customer Invoice Type Code NO The dimension CODE, i.e. customer invoice type
Customer Invoice Type Company NO The natural parent company (COMPANY)
Customer Invoice Type Descr NO The description of the customer invoice type

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_CUSTOMER_INVOICE_TYPE_BI INVODI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.100 Load IFSAppl_DIM_CUSTOMER_INVOICE_TYPE_BI.dtsx IFSAppl_DIM_CUSTOMER_INVOICE_TYPE_BI
T - DW 2.1.100 Load Dw_DIM_CUSTOMER_INVOICE_TYPE.dtsx Dw_DIM_CUSTOMER_INVOICE_TYPE
L - DM 3.1.100 Load Dm_DIM_CUSTOMER_INVOICE_TYPE.dtsx Dm_DIM_CUSTOMER_INVOICE_TYPE