About adjusted measures

Adjusted measures compensate for misleading statistics that occur when a dimension value changes during the processing of a step. Adjusted measures are not visible by default. To make the adjusted measures visible, use the Administration Console for Content Platform Engine to enable the option in the Case Analyzer store Configure Online Analytical Processing (OLAP) tab options.

Case Analyzer automatically creates an adjusted measure with "_Adjusted" appended to the name for each measure that is set to be updated on Work item is queued in the Queue Load cube, Workflow is created in the Work Load cube, Task in the Task Load cube, and Case in the Case Load cube.

For an example of how you can use adjusted measures, consider the following scenario:

  • The workflow system event log contains the data fields Amount and Region.
  • You expose Amount to the Work Load cube as Incoming Amount, to be updated when the workflow is created, and as Outgoing Amount, to be updated when the workflow completes.
  • A workflow is created in the western region with an amount of $200. During processing, the region changes from West to East, due to a corrected data entry error.
  • If you compare incoming and outgoing values based on Region when the workflow completes, Incoming Amount shows $0 and Outgoing Amount shows $200.
  • The adjusted value, contained in Incoming Amount_Adjusted, shows $200.