Model Table SOURCE
This model dimension represents account sources defined in basic data and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| Customer Source | The account source that defines the point of contact originated with the account. |
| Customer Source Code | The ID of the account source that defines the point of contact originated with the account. |
| Customer Source Descripton | The description of the account source that defines the point of contact originated with the account. |
USED BY MODEL(S)
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 |
| SOURCE | DIM_CUSTOMER_SOURCE_TM | DIM_CUSTOMER_SOURCE_BI | DIM_CUSTOMER_SOURCE | On Line |