Update Dimension Values with Auto-Delete Feature

Metric Insights allows Users to automatically remove Dimension Values sourced from a Dataset if, during update, these Values are not found in the results set.

While this article details how to activate and use the auto-delete for Dimension Values sourced from a Dataset, this feature can be used to update Dimension Values sourced from any Configurable Data Source.

PREREQUISITE:

A sample Use Case is described below.

1. Select the Trigger to Update Dimension Values

Before enabling the auto-delete for Values of a certain Dimension, specify the Data Collection Trigger that will run updates for that Dimension.

Access Dimension Editor and open Info tab

Select the Data Collection Trigger that will update the list of Dimension Values at set time intervals. Alternatively, create a new Data Collection Trigger by clicking the "plus" icon and defining the details.

For more details, see Create a Data Collection Trigger article.

2. Activate auto-delete for Dimension Values

Open Advanced tab

 

In the Delete Dimension Values not found in result set field select "yes" option.

Don't forget to [Save] the changes.

NOTE: For the auto-delete setting to work correctly the Dimension Values Data Collection Trigger should run data collecting AFTER the source Dataset Data Collection Trigger.

3. Review the Dimension Values Update

As illustrated by the image above, the "Australia" Value has been removed from the Values list after the Values Source (Dataset) has been updated.