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

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

This model dimension represents business activities 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)
Business Activity NumberThe ID of the business activity.
Business Activity SubjectThe description of the business activity.
Business Activity Connection IDThe connection (customer, supplier, lead etc.) which is the business activity is created for.
Main Representative-
Business Activity Connection TypeThe connection type (customer, supplier, lead etc.) related to the business activity.
Business Activity Connection Type DescriptionThe connection type (customer, supplier, lead etc.) related to the business activity.
Activity TypeThe Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail.
Activity Type DescriptionThe Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail.
Business ActivityThe ID of the business activity.
Business Activity Connection ID ActivityThe connection (customer, supplier, lead etc.) which is the business activity is created for.

USED BY MODEL(S)

Model Name
CRM

Data source Information

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 DIMDIM_BUSINESS_ACTIVITY_BIDIM_BUSINESS_ACTIVITYOn Line