LOV: Enabled vs Disabled Dimension Values
This page displays scenarios when List of Values (LOV) option is enabled or disabled for a Data Store.
In Reports, the LOV (List of Values) configuration determines how dimension values appear in the Filter panel. Dimensions can be either enabled (displaying sub-values with all filter operations) or disabled (restricting available filter options).
This functionality applies to both View Filters and Global Filters.
Accessing the LOV Option
You can access the List of Values (LOV) option from the Data Store within the Center module. Enabling or disabling this feature for a specific data store will take effect when creating a report based on that same data store.
Navigation Path: Data Center > Data Store > Data Type Definition
Behavior of LOV Dimensions
Disabled Dimension Values
No sub-values are displayed.
Only Like and Not Like filter operations are available.
Users must manually provide sub-values for filtering.
Enabled Dimension Values
All sub-values are displayed.
All filter operations are available:
In
Not In
Like
Not Like
Example
Disabled Dimension (e.g., State)
From the Global Filter panel, select State.
No sub-values are displayed.
Only Like and Not Like options are available.
Example: Apply Like = Jaipur → Report displays only Jaipur data.
Example: Apply Not Like = Jaipur → Report excludes Jaipur data.
Enabled Dimension (e.g., City)
From the View Filter panel, select City.
Sub-values are displayed in the list.
All operations are available: In, Not In, Like, Not Like.
Example: Apply In = Delhi, Mumbai → Report shows only Delhi and Mumbai.
Example: Apply Not In = Kolkata → Report excludes Kolkata.
Steps to Apply Like / Not Like on Disabled Dimension
Open the Global Filter panel.
Select a disabled Dimension (e.g., State).
Choose Like or Not Like from the drop-down.
Manually enter a sub-value (e.g., Jaipur).
Click Apply.
Like = Jaipur → Report shows Jaipur data.
Not Like = Jaipur → Report shows all data except Jaipur.
Last updated