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
- The number of instances of a trimmed value in the reporting database
- The number of reports using the value
- The number of values that are trimmed for the dimension
- 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.