Model: CRM - Specifications for Dimension Table: BUSINESS ACTIVITY REFERENCE

On this page you will find the specifications regarding the Model: CRM and Dimension Table: BUSINESS ACTIVITY REFERENCE.

Attributes

Attribute	Description (where applicable)
Activity No	Not Needed
Business Activity Start Date	Not Needed
Count Business Activity	Number of Activitis.
DIM_ACTIVITY_NO	Not Needed
Is Activity Created from Object	Whether the Activity is created from Reference Object.
Is Activity Created from Object Description	Whether the Activity is created from Reference Object.
Is Object Created from Activity	Whether the Reference Object is created from Activity.
Is Object Created from Activity Description	Whether the Reference Object is created from Activity.
Opportunity Value Estimated	Not Needed
Reference ID	Reference Object connected to Activity.
References Type Description	Type of Reference Object connected to Activity.
References Type Description Description	Type of Reference Object connected to Activity.

USED BY MODEL(S)

Model Name

CRM

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 ACTIVITY REFERENCE	FACT_BUSINESS_ACTIVITY_REFERENCE_TM	FACT_BUSINESS_ACT_REF_BI	FACT_BUSINESS_ACTIVITY_REFERENCE	Data Mart