Filtering in QPR ProcessAnalyzer: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
Line 15: Line 15:


To open a filter, select it from the list and click '''OK'''.
To open a filter, select it from the list and click '''OK'''.
Each time a filter is changed, for example when elements are filtered, the filter is saved to the Manage Filters list.
To change the '''Name''', '''Description''', '''Filter Rules, '''Sample Size''' or '''Publish Mode''' of a filter, select the filter from the list, click '''Properties''', and modify the properties in the dialog that opens.
To delete a filter, select the filter from the list and click '''Delete'''. Note that you cannot delete the Model Default filter but you have to first set another filter as Model Default before you can delete the filter that used to be the Model Default. Also, you cannot delete a filter if there are bookmarks using that filter in benchmark settings.
To create a new filter from the one that is selected, click the '''Create Filter''' button, and select one of the options:
* '''Copy''': will create a copy of the selected filter.
* '''Negation''': will invert the Event Types Hidden and Cases Hidden selections in the filter.
* '''Union''': when multiple filters are selected, combines the cases from the filters.
* '''Intersection''': when multiple filters are selected, will create a new filter that contains only those events that exist in all of the selected filters.


== Case Sample Size ==
== Case Sample Size ==

Revision as of 10:06, 23 December 2019

Filters define a subset of cases and events in the process analysis model. This subset of data is used for all analysis. Filters consist of a list filter rules, which are applied in the defined order. Cases/events are excluded if there is a single filter rule, that excludes the cases/events (AND type of logic, instead of OR logic).

There are two types of filtering available in QPR ProcessAnalyzer Excel Client: Runtime Selection and Include/Exclude Filters (more information below).

Manage Filters

The Manage Filters dialog is used for selecting and managing filters in the current model. The following information about the filters is provided:

  • Name: shows the name of the filter.
  • Publish Mode: shows whether the filter is available only foryou (Private), everyone (Public), or if the filter is the default filter for the model (Model Default). The default filter is also a public filter. If you have Administrator rights to the model, you can set any configured Public filter to be the Model Default. This change will then affect all users of the model and the filter previously set as Model Default will become Public. Note that you cannot directly change the Publish mode of the default filter, because there needs to be a default filter in the model. To change the default filter, change the Publish Mode for the new default filter.
  • Created On: the date and time on which the filter in question was applied.
  • Created By: the ID of the user who created the filter.
  • Bookmarks: the number of bookmarks that have been made from the filter.
  • Filter Rules: the number of filter rules the filter has.
  • Opens: the number of times the filter has been opened.
  • Last Modified On: the date and time on which the last modification to the filter was made.
  • Last Modified By: the user who made the last modification to the filter.

To open a filter, select it from the list and click OK.

Case Sample Size

Sampling is used limit the number of cases in a filtered dataset. Sample Size is defined for a filter. If there are more cases in the filtered dataset than the defined sample size, part of the cases are randomly dropped out so that there are exactly the sample size number of cases in the filtered data. To disable sampling, select the All radio button. To change the sample size, enter a number into the Limit To box or use the arrows to decrease or increase the number of cases. Note that the sample is selected randomly every time the filter is calculated, and thus it may contain different cases.

Filter Publish Mode

You can also define whether to set the filter to be published only to you (Private), everybody (Public), or if the filter is the default filter for the model (Model Default).

Other Operations in Filter Properties

Clicking the Export... button gives you the option of exporting the filter to a .pacm file or the events to an Excel sheet. Note that when exporting a filter, only visible cases, events and attributes are included in the destination. That is, if the filter has any filter rules, then only cases, events and attributes visible for that filter will be exported.

Clicking the Save As New Model button will save the filtered data as a new model. Only the filtered cases, events and attributes are included to the new model.

Filter Rule Types

Following filter rule types are available:

  • Include/exclude cases based on case attribute values: For example, include only those cases where case attribute "Account Manager" is "Patricia White" or "Mary Wilson".
  • Include/exclude cases having certain event type(s): For example, include cases that have event types "Invoice Created" or "Invoice Paid" (either or both).
  • Include/exclude cases having certain flow(s): For example, include cases that have a flow from "Outbound Delivery" to "Handling unit". To match, there must not be other events between those two events.
  • Include/exclude cases based on case duration: For example, include cases the case duration is over 50 days. Case duration is the last event timestamp minus the first event timestamp.
  • Include/exclude cases based on flow duration: For example, include cases the flow from "Sales Order" to "Outbound Delivery" is over 5 weeks.
  • Include/exclude cases belonging to certain variation(s) (sequence of events): For example, include cases belonging to variation "Sales Order sent" -> "Invoice Created" -> "Invoice Paid".
  • Include/exclude cases having certain event attribute value(s): For example, include cases having event(s) with event attribute "Organization" is "Finance".
  • Include/exclude cases having certain part of variation: For example, include cases where variation starts with "Sales Order sent" -> "Invoice Created" -> "Invoice Paid".
  • Include/exclude event types: For example, include event types "Sales Order sent", "Invoice Created" and "Invoice Paid".

There are two kinds of filter rules: case filter rules and event type filter rule. Case filter rules filter out cases, and the number of cases decreases. The event type filters filter out events, so the number of cases doesn't decrease but the process flow in individual cases may change as event types are left out. Note that event type filter rules may filter out all events of a case, which results in cases that don't have events at all. It's not possible to show those cases in flowcharts or calculated durations for them.

A case has a Flow between events A and B means that the case has both events A and B and there are no other events between them. A case may have the same flow multiple times. Flow duration is the event B timestamp minus A timestamp. Note also that flows always has a direction: flow from A to B is different than flow from B to A.

Variation means a sequence of events that a case goes through. A case always belongs to a certain variation. If another case has different events or they are in different order, the case belongs to a different variation. Duration between events doesn't matter in terms of which variation a case belongs.