Updating counts for trimmed dimension values in report data

About this task

When the oldest values for a dimension are automatically trimmed, reporting data that uses the dimension values can be optionally updated, too. This updating involves replacing each instance of a trimmed value with the [others] dimension constant.

  • By default, the Dimension Trimming - Update Fact Counts setting is enabled. See "Settings" in the Unica Discover Administration Manual.

For a dimension trimming operation, the number of database changes is factored by:

Procedure

  1. The number of instances of a trimmed value in the reporting database
  2. The number of reports using the value
  3. The number of values that are trimmed for the dimension
  4. The number of dimensions being trimmed

Results

For data-intensive dimensions, such as URL (Normalized), it is especially important to manage the dimension values using white lists.

Note: Updating the event + dimension counts for trimmed values in the reporting data can take a few minutes to multiple hours to complete.