On this page you will find the specifications regarding the Model: CRM and Dimension Table: BUSINESS ACTIVITY FACT.
| Attribute | Description (where applicable) |
| Activity Cc | - |
| Activity From | - |
| Business Activity Sub Type | Activity Sub Types are used to specify the nature of an activity. |
| Activity To | - |
| Business Activity Type | The Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail. |
| Business Activity Type ID | The Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail. |
| Count of Business Activity | Number of business activities. |
| Business Activity Action No | The campaign action number if the activity is a campaign activity. |
| Business Activity Business Object Type | The type of the business object that is connected to the business activity, business opportunity, sales quotation etc. |
| Business Activity Campaing Target | The marketing campaign target which is the business activity is created for. |
| Business Activity Connection Category | The category of account or supplier the business activity is linked to. |
| Business Activity Connection Type Decsription | The connection type (customer, lead, supplier etc.) related to the business activity. |
| Business Activity No | The ID of the business activity. |
| Business Activity Priority | The importance of the business activity. |
| Business Activity Status ID | The status of the business activity. |
| Business Activity Status | The status of the business activity. |
| Count of Activity BO Connected | Number of business activities which has a business opportunity connected to it. |
| Count of Activity Completed | Number of business activities where the business status is completed. |
| Count of Activity in Progress | Number of business activities where the business status is in progress. |
| Count of Activity Not Started | Number of business activities where the business status is not started. |
| Count of Activity Calls | Number of business activities where the business activity type is Call. |
| Count of Activity Chats | Number of business activities where the business activity type is Chat. |
| Count of Activity Emails | Number of business activities where the business activity type is e-mail. |
| Count of Activity Meetings | Number of business activities where the business type is Meeting. |
| Count of Activity Tasks | Number of business activities where the business type is Task. |
| Business Activity Direction | Whether the activity is inbound or outbound when the activity type is a call, e-mail etc. |
| Business Activity Duration | The duration of the activity when the activity type is a call etc. |
| Business Activity Subject | The description of the business activity. |
| Model Name |
| CRM |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| BUSINESS ACTIVITY FACT | FACT_BUSINESS_ACTIVITY_BI | FACT_BUSINESS_ACTIVITY | On Line |