EventInformation

 

In this part of the EventLog table, you will rename the event-related fields in the table event log (previously you have renamed the process analyzer information fields). As you can see in the code below, there are EventDimensionX fields which take dimensions describing the events context (like users, machines, ressources, ...).

 

1.Replace the EventDimensionX fields (as in the Helpdesk example) with the event names according to your data.

2.If you don't have enough data for all fields, i.e. no data for EventDimension3 or EventValue2, replace the respective row with dummyX as EventDimension3.

If you need more fields than the template provides, simply insert them as new EventDimension4 with the respective data field name.

 

//Event information

//Here you can add other event-related information (dimensions and values)

 "UserName" as ActivityUserName,

 if(WildMatch("UserName", '*batch*'), 0, 1) as RealUser, //delete if no user available

 if(WildMatch("ActivityName", '*Change*','*Delete*'), 0, 1) as ReworkEvent, 

  EventDimension1,

  EventDimension2,

  EventDimension3

FROM [lib://Data/MPMData.qvd] (qvd)

where len(ActivityName) > 1;

 

 Helpdesk example:

 

//Event information

//Here you can add other event-related information (dimensions and values)

 ActivityUserName,

 if(WildMatch("UserName", 'Value 6'), 0, 1) as RealUser, //delete if no user available

 if(WildMatch("ActivityName", '*Change*'), 0, 1) as ReworkEvent, 

  Seriousness,

  Service_type,

  'dummy3' as EventDimension3

FROM [lib://helpdesk/HelpdeskEventlog.qvd] (qvd)

where len(ActivityName) > 1;

 

 

Tutorial

 

Start the video below to see a short tutorial about how to use the sheet.

 

 

CaseInformation

 

In this table of the script tab 1B. Load EventLog, 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.

 

 

3.Replace the CaseDimensionX fields (as in the Helpdesk example) with your case names.

4.If you don't have enough data for all fields, e.g. no data for CaseDimension5, replace the respective row with dummyX 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 Keep([pa_activity_log_$(mvProcessDescription)])

CaseInformation:

LOAD

 CaseID, // don't delete it

 CaseDimension1,

 CaseDimension2,

 CaseDimension3,

 CaseDimension4,

 CaseDimension5,

 Geofield // for example: city

FROM [$(DataConnection)/MPMData.qvd] (qvd);

 

 Helpdesk example:

 

Left Keep([pa_activity_log_$(mvProcessDescription)])

CaseInformation:

LOAD

 [Case ID] as CaseID,

 Variant,

 Customer,

 Product,

 Workgroup,

 'dummy1' as CaseDimension5,

 City

FROM [lib://helpdesk/HelpdeskEventlog.qvd] (qvd);

 

 

Tutorial

 

Start the video below to see a short tutorial about how to use the sheet.