Model: CRM - Specifications for Dimension Table: BUSINESS LEAD FACT
Attributes
| Attribute |
Description (where applicable) |
| Annual Revenue |
Annual revenue of the lead. |
| Association No. |
The customer's association number. |
| Business Lead Company |
The name of the lead company. |
| Business Lead Creation Date |
The date that the lead is created. |
| Business Lead Description |
The description of the lead. |
| Business Lead ID |
Not Needed |
| Business Lead Probability |
The probability level set for the lead. |
| Business Lead Status |
The status of the lead. |
| Country |
Not Needed |
| Country ID |
Country of the lead company. |
| Currency |
Currency related to the lead. |
| Default Language ID |
Language related to the lead. |
| Forms of Business |
The form of business of the lead or the relavent account. |
| Forms of Business ID |
The form of business of the lead or the relavent account. |
| Is from Existing Account |
Whether the lead is created related to an existing account or not. |
| Market ID |
Market of the lead company. |
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 |
| BUSINESS LEAD FACT |
FACT_BUSINESS_LEAD_TM |
FACT_BUSINESS_LEAD_BI |
FACT_BUSINESS_LEAD |
Data Mart |