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

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

Attributes

Attribute Description (where applicable)
Activity CcNot Needed
Activity FromNot Needed
Activity ToNot Needed
Business Activity Action NoThe campaign action number if the activity is a campaign activity.
Business Activity Business Object TypeThe type of the business object that is connected to the business activity, business opportunity, sales quotation etc.
Business Activity Campaing TargetThe marketing campaign target which is the business activity is created for.
Business Activity Connection CategoryThe category of account or supplier the business activity is linked to.
Business Activity Connection Type DecsriptionThe connection type (customer, lead, supplier etc.) related to the business activity.
Business Activity DirectionWhether the activity is inbound or outbound when the activity type is a call, e-mail etc.
Business Activity DurationThe duration of the activity when the activity type is a call etc.
Business Activity NoThe ID of the business activity.
Business Activity PriorityThe importance of the business activity.
Business Activity StatusThe status of the business activity.
Business Activity Status IDThe status of the business activity.
Business Activity Sub TypeActivity Sub Types are used to specify the nature of an activity.
Business Activity SubjectThe description of the business activity.
Business Activity TypeThe Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail.
Business Activity Type IDThe Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail.
Count of Activity BO ConnectedNumber of business activities which has a business opportunity connected to it.
Count of Activity CallsNumber of business activities where the business activity type is Call.
Count of Activity ChatsNumber of business activities where the business activity type is Chat.
Count of Activity CompletedNumber of business activities where the business status is completed.
Count of Activity EmailsNumber of business activities where the business activity type is e-mail.
Count of Activity MeetingsNumber of business activities where the business type is Meeting.
Count of Activity Not StartedNumber of business activities where the business status is not started.
Count of Activity TasksNumber of business activities where the business type is Task.
Count of Activity in ProgressNumber of business activities where the business status is in progress.
Count of Business ActivityNumber of business activities.

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 FACTFACT_BUSINESS_ACTIVITY_TMFACT_BUSINESS_ACTIVITY_BIFACT_BUSINESS_ACTIVITYData Mart