Reuse the Context Information Template
This is the table where you will rename the case-related fields. We distinguish the event log from the CaseInformation in order to create a clearly understandable data model. The CaseInformation table basically behaves like the EventLog table. There are CaseDimensionX fields that must be replaced.
⚠️ Warning: Never delete "CaseID" because this is the connection between the CaseInformation and EventLog tables.
-
Replace the CaseDimensionX fields (as in the Helpdesk example) with your case names.
-
If you don't have enough data for all fields, e.g. no data for CaseDimension5, then replace the respective row with ProcessFinished, CaseStartDate, ProcessStartsWithActivityType, or ProcessEndsWithActivityType as CaseDimension5.
If you need more fields than the template provides, simply insert them as new CaseDimension6 with the respective data field name.
For example, if you want to add a department, create a new row with a field named DepartmentName and name it as you like (e.g. "Department Name").
Left Join(\[CaseInformation\_$(mvProcessDescription)\])
LOAD distinct
CaseID, // don't delete it
CaseDimension1,
CaseDimension2,
CaseDimension3,
CaseDimension4,
CaseDimension5,
Geofield // for example: city
FROM \[$(DataConnection)/mpmXData.qvd\] (qvd);
Helpdesk example:
Left Join(\[CaseInformation\_$(mvProcessDescription)\])
LOAD distinct
PurchaseOrderItem as CaseID,
Supplier,
Company,
SpendArea,
ProductClass,
ProcessPathUniqueNo,
City
FROM \[lib://helpdesk/HelpdeskEventlog.qvd\] (qvd);