To use the values of case and workflow data fields in Case Analyzer reports, you must identify which data fields will be exposed, specify their properties as dimensions or measures, and specify the appropriate OLAP cube to store the data. The values for case and workflow data fields are stored in the Case Analyzer store.
Before you make a case or task property or a data field available to those who will use this information to analyze workflows and cases, the property or field must be captured in the workflow system event log or object store audit log.
To make case or task properties available from Case Manager systems, see Integrating IBM case analytics tools
If a data field that you want to make available occurs in both the event log and audit log, then you need to create only a single Case Analyzer data field to retrieve the data values from both logs. To enable this, the data field name and type must be the same in the event log and audit log. For example, if a data field named LoanAmt of data type float is exposed in the event log and audit log, then you will create a single Case Analyzer data field of type float named LoanAmt to pull the data from both sources to the Case Analyzer database.
Data fields can be created as dimensions or measures:
Any data field type can be a dimension. For data fields of type float, integer, and time, you have the option of aggregating the data. For example, if a data field is an amount, you can categorize the amount field into ranges of 0-10, 10-100, 100-1000, and above 1000. Aggregating dimension data saves on storage space; if you choose not to aggregate the data, all the values are stored as members in the dimension, which yields large dimensions.