Case and Event Attributes in QPR ProcessAnalyzer
There are two types of attributes: Case attributes and Event attributes.
Event Attribute values can vary from event to event inside a case. For example, you can have the Flowchart Analysis show the top three users in each separate event type to see easily which users are part of which event types.
When using Event Attributes in Profiling Analysis, you can show which values are found for an event attribute, and also create a filtered view based on an event attribute. For example, you can show processes where a particular user has been involved.
Case Attributes hold the same attribute value for all event types in a case. For example, you can show the top three order types, product categories, or manufacturing plants for each alternative process flow in the Flowchart Analysis.
Date and Time Format in Attribute Values
The date and time format for attribute values follows the ISO8601 format yyyy-mm-ddThh:mm:ss.fff. The maximum year is 2030 and the minimum year is 1970. 'fff' stands for fractions of seconds and it is given in 3ms accuracy and the last digit must be 0, 3 or 7.
Limitations to Numbers in Attribute Values
There are some known limitations for numbers in Excel which are relevant for attribute values:
- Numeric precision: only the first 15 digits of a number are accurate and if the number has more than 15 digits, the digits after the first 15 will be changed to zeroes.
- The smallest allowed negative number is -2.2251E-308.
- The smallest allowed positive number is 2.2251E-308.
- The largest allowed positive number is 9.99999999999999E+307.
- The largest allowed negative number is -9.99999999999999E+307.
These limitations apply also to case cost and event cost.
Null and Empty Attribute Values
The values for null values (i.e. no value has been given for the case or event attribute) and for empty values (i.e. the value for the case or event attribute exists but it is empty) are represented in QPR ProcessAnalyzer Excel client as shown in the table below:
Escaping for Attribute Values
Escaping is used for certain characters when they have to be interpreted differently from the same characters occurring without the prefixed escape character. In QPR Process Analyzer the backslash (\) is used as an escape character. For example, when using attribute values in ETL scripts and these values contain characters that need escaping, you need to enter the \ character before the value.
The table below lists the characters for which you must use escaping when entering them in e.g. ETL scripts:
The table below lists the characters that are escaped automatically by QPR ProcessAnalyzer in the generated views, such as A1 cell (for more information, see QPR ProcessAnalyzer Analysis Parameters) and ID columns which have been hidden in Excel: