Model Table CUSTOMER

This model dimension represents customer information and is based on the IFS Cloud dimension DIM_CUSTOMER. All models that refer to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
Association No	The customer's association number (ASSOCIATION_NO)
Corporate Form	Form of Customer's coorporation
Country	The description of the country the customer belongs to (COUNTRY_DESC)
Customer	Defined as CODE + ' - ' + CUSTOMER_NAME
Customer Code	The dimension CODE, i.e. the identity/code of the customer
Customer Name	The customer name (CUSTOMER_NAME)

USED BY MODEL(S)

Model Name

Cash Planning

Crm

Maintenance

Project

Sales

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
CUSTOMER	DIM_CUSTOMER_TM	DIM_CUSTOMER_BI	DIM_CUSTOMER	On Line