LOV Settings

The user can enable the filter and lookup for specific dimensions via the Data Type Definition step for a Data Store. All the selected (enabled) dimensions list with the sub-values, while for the disabled ones, no sub-values appear. This operation applies to both Local and Global filters.

• Navigate to the Data Type Definition page for a Data Store (the image displays the Data Type Definition page for the Data Store where Dimensions like gender, skills, and ename are enabled for the filter lookup function, but source, previous_organisation, and team are disabled from the filter lookup.

Selecting LOV filtering

• Create a story based on the same Data Store and save it with relevant views.

• Access the global filter panel.

• Select any of the disabled Dimension values (E.g., the State dimension is selected from the Filter panel in the following image).

  • The sub-values for the State dimension do not get displayed.

  • Only Like and Not Like options can be applied to the disabled dimensions.

LOV disabled Dimension Value

• Select any of the enabled Dimension values (E.g., the division as Dimension value has been selected in the given image).

  • The sub-values for the division dimension get displayed.

  • It displays all the filter operations In, Not In, Like, and Not Like options for the enabled dimension.

LOV enabled Dimension Value

Please Note:

• The disabled Dimension values from the LOV do not display the sub-values and there will be only Like and Not Like options available for the disabled dimension.

• The enabled Dimension values from the LOV display the sub-values and there will be In, Not In, Like, and Not Like options available for the enabled dimension.

Applying Like & Not Like filter options

The user can successfully apply the Like or Not Like option.

• Open the Global Filter panel.

• Select a disabled dimension value.

• Select an option out of or Not Like choices (E.g., Like option has been selected in this case).

• Manually provide a sub-value to filter the Story (E.g., C19_75 is the selected sub-value from the vehicleId dimension).

• Click the Apply icon.

Applying Like option on a disabled value

• The Story Views get filtered by the selected sub-value.

• Select the Not Like as the filter operation for the same sub-value.

• The concerned views get filtered, excluding the entered values (E.g., The Story displays filtered data with the values except the C19_75 vehicleId data).

The Report Views get filtered except the filter value selected as Not In option

Please Note: The Like and Not Like operations are available in the View Filter panel as well.