Enabling Case Analyzer with multi-valued property data fields

Edit online
Draft comment:
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-03-13 12:15
You can enable multi-valued property data fields to the Case Analyzer store.

About this task

Adding a multi-valued property is similar to adding a single-value data field. For detailed instructions, see https://www.ibm.com/docs/SSNW2F_5.6.0/com.ibm.p8.pe.taskmgrui.doc/pa_data_fields_wizard.html External link opens a new window or tab

Procedure

To add a data field by using the Data field wizard

  1. Stop Case Analyzer.
  2. To add new fields, select the Data Fields folder, then select Action > New.
  3. To modify an existing data field, select the data field and then select Action > Edit.
  4. To browse for data fields, from Select a Method for Configuring the Data Field, use Content Engine field as a template.
  5. From the Field list, select a multi-value property field.

    For more details, see Multi-value property field types

  6. In the Unique Name field, enter a name for this data field. This name differs from the data field's name in the Content Platform Engine but must be unique among all the other datadisplayed fields in Case Analyzer.
  7. Click Next.
  8. Choose how to display the data field: select Dimension.
  9. Define value ranges for dimensions with data types integer, float (required), or time. Each range has two boundary values, from the lower value+1 to the upper value.
  10. From the Reporting Source window, select Fact tables only (for detailed reports from the Case Analyzerdatabase) to display the data field.
  11. Choose the fact tables where the data field is displayed.
  12. Click Finish.

Multi-value property field types

Edit online

The Multi-value property field types have the suffix "List." The table lists the multi-value field type for various data types.

About this task

Multi-Valued property data types Filed Type in Process Task Manager
Integer IntList
String StrList
Float FloatList
DateTime TimeList
Boolean BoolList

Limitations of multi-valued property data fields

Edit online

The multi-valued property data fields have certain limitations regarding the fact tables and compression wizard.

Procedure

  1. Multi-valued property data fields are available only on the following fact tables:
    • F_DMCaseWIP
    • F_DMCaseLoad
    • F_DMTaskWIP
    • F_DMTaskLoad
  2. Case Analyzer Compression wizard:
    • When an MVP UDF (Multi-Valued Property User-Defined Field) is displayed, compression does not include the compression or rollup of the tables F_DMCaseLoad and F_DMTaskLoad.
  3. Multi-valued properties are supported only as dimensions.
  4. For reporting purposes, only fact tables (detailed reports from the Case Analyzer database) can be selected as the data source for multi-valued properties.