You can add data fields to the Case Analyzer store. Data fields that are added for case management activities are stored in the Content Platform Engine. Case Analyzer retrieves case data from the Content Platform Engine and places them in the Case Analyzer store for generating OLAP cubes and fact tables.
The changes that you make here are not reflected in reports until the next time the underlying cubes are processed. The work-in-progress cubes are processed based on the publishing interval. In addition, the historical and work-in-progress cubes are processed daily based on the schedule that you set. You can wait for the next scheduled processing, or you can process the cubes manually. For more information, see Processing the Case Analyzer cubes.
Alternatively, you can import one or more data fields from a text file. For more information, see Importing data fields.
To add a data field by using the Data Field Wizard:
The name that you enter cannot be longer than 128 characters, must begin with a letter, and contain only letters, numbers, or underscores.
You cannot use a name that is used internally by the Case Analyzer Engine. The following names are reserved:
Reserved name | Reserved name | Reserved name |
---|---|---|
Average Age Days | Avg. Wait Min Current | Route Percentage |
Average Age Hours | Avg. Wait Time Days | Status |
Average Age Minutes | Avg. Wait Time Hours | User |
Average Completion Time Days | Avg. Wait Time Minutes | Time |
Average Completion Time Hours | Case | Task |
Average Completion Time Minutes | Case Count | Task Count |
Average Days in Current Step | Case In Progress | Task in Progress |
Average Hours in Current Step | Case Load | TaskLoad |
Average Minutes in Current Step | CaseLoad | Task State |
Average Fail Time Days | Case State | Time Spent |
Average Fail Time Minutes | Completed Work Item Count | Time Usage Minutes |
Average Processing Time Days | Completed Workflow Count Cycle Time Minutes | Total Completion Time Minutes |
Average Processing Time Hours | Data Source | Total Processing Time Minutes |
Average Ready Time Days | Incoming | Total Route Count |
Average Ready Time Minutes | Incoming Adjusted | Total Step Count |
Average Wait Time Days | Incoming_InComp | Total Wait Time Minutes |
Average Wait Time Minutes | Incoming Work Load | TSCreation Time |
Avg. Completion Time Days | Outgoing | TSLastEvent |
Avg. Completion Time Hours | Proc Min Current | Wait Min Current |
Avg. Completion Time Minutes | Productivity Count | Work Item Count |
Avg. Proc Min Current | Queue | Workflow |
Avg. Processing Time Days | Queue Load | Workflow Count |
Avg. Processing Time Hours | Route | Workflow Definition |
Avg. Processing Time Minutes | Route Count | Workload |
Dimension: Any data type can be a dimension.
Measure: Define measures as aggregate values. A measure must be data type integer or float. The default aggregation function for a measure is Sum.
To add a boundary value to the list, enter the value in the Boundary field, and click Add. For example, for boundary values 500, 1000, 2550, you see the following ranges:
Boundary value | Description |
---|---|
< 500 | implicit range includes everything less than 500 |
500 - 1000 | range includes 500 - 999 |
1000 - 2550 | range includes 1000 - 2549 |
2550 > | range includes everything greater than or equal to 2550 |
Exposing a data field of a granular dimension that might yield many unique values (such as social security numbers) to an OLAP cube is not practical. A dimension of many members can also use a large amount of memory and processor time. If queries for this level of detail are necessary, then that data must be exposed to the fact table only and reports obtained from that fact table.
Use the following tables as a guideline.
Cube or Fact Table Name | Description |
---|---|
Case in progress | View up-to-the-moment information about all cases currently in the system. The information includes the number of cases, processing times, and status. You can break down the information by case or task. |
Case load | View information about the number of cases in process during a specified time period. |
Cube or Fact Table Name | Description |
---|---|
Tasks in progress | View up-to-the-moment information about all tasks currently in the system. The information includes the number of tasks, processing times, and status. |
Task load | View information about the number of case tasks in process during a specified time period. |
Cube or Fact Table Name | Description |
---|---|
Queue load | View information about the amount of work that is being done in each queue during a specified time period. |
Work in progress | View up-to-the-moment information about all work currently in the system. The information includes the number of work items, processing times, and status. You can break down the information by workflow or work item. |
Work item processing time | View information about processing time for work items during a specified time period. You can break down the information by user. |
Routing | View information about the number of work items that are taking a particular route between two connected steps in a workflow. |
Cube or Fact Table Name | Description |
---|---|
Work load | View information about the amount of work that is being done in the system during a specified time period. |
Workflow in progress | View up-to-the-moment information about all work currently in the system. The information includes the number of work items, processing times, and status. You can break down the information by workflow or work item. |
If you are exposing a data field as a measure, you can specify when the data field must be updated for the following cubes:
Queue Load | Work Load | Case Load | Task Load |
---|---|---|---|
Work item is queued | Workflow is created | Case is initiated | Task is initiated |
Work item is completed | Workflow is terminated | Case is completed | Task is completed |