Data configuration filtering option: Suppress list of values
Article ID: KB0082580
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.0 and later versions |
Description
While enabling filtering in a data configuration in Statistica Enterprise Manager there is an option to enter SQL statement and Suppress list of values. What are the implications of having a query in this SQL Statement and what are the implications of selecting "Suppress list of Values"
Resolution
Enabling Filter options for field in Statistica Enterprise's data configuration does not "require" the user to define a SQL statement for the filtering to work. Statistica will usually process a "Select distinct [column name] from table" to list the values for the column.
The SQL Statement:
The SQL Statement should be entered only when there is a need for the list of values prompted to be more specific. For example, a SQL statement can be used to add a where clause to the SQL statement to restrict the list of values (Select distinct TestName from Performance where location ='Paris' ) or getting a list of values that join to another table (Select distinct Name from Employees inner join Departments on Employees.DEPTID = Departments.ID where DeptName='HR') or while using hierarchical filtering in Statistica
A SQL statement entered in this box will be used for displaying the list of values while running the data configuration rather than the default select distinct. Exploring the data configuration will bring back a list of values that are result of the query entered in the SQL statement box.
Suppress list of values:
The "Suppress list of Values" box need not be clicked on for every time a SQL statement is entered for reasons aforementioned. Enabling the Suppress list of values option can be used in scenarios where it might be easier to type than to choose from a list of values.
For example, if the field being queried is a Batch_ID(or other field) column that has a lot of values, it might be easier to type in these scenarios. Enabling this option will bring back a Enter a label dialog when you click on the button with 3 dots next to values (...) that will give you an option to enter the value to be filtered on rather than choosing from a list of values. Note that this option can be useful in scenarios where the end user has to know the right format to be able to access information.
For example, in the below scenario : A user has to know the right format for the column Room below to be able to access this data.
Note: The suppress list of values is not the only way a user can type values. They may also enter it in the Values field in the above dialog directly.
The SQL Statement:
The SQL Statement should be entered only when there is a need for the list of values prompted to be more specific. For example, a SQL statement can be used to add a where clause to the SQL statement to restrict the list of values (Select distinct TestName from Performance where location ='Paris' ) or getting a list of values that join to another table (Select distinct Name from Employees inner join Departments on Employees.DEPTID = Departments.ID where DeptName='HR') or while using hierarchical filtering in Statistica
A SQL statement entered in this box will be used for displaying the list of values while running the data configuration rather than the default select distinct. Exploring the data configuration will bring back a list of values that are result of the query entered in the SQL statement box.
Suppress list of values:
The "Suppress list of Values" box need not be clicked on for every time a SQL statement is entered for reasons aforementioned. Enabling the Suppress list of values option can be used in scenarios where it might be easier to type than to choose from a list of values.
For example, if the field being queried is a Batch_ID(or other field) column that has a lot of values, it might be easier to type in these scenarios. Enabling this option will bring back a Enter a label dialog when you click on the button with 3 dots next to values (...) that will give you an option to enter the value to be filtered on rather than choosing from a list of values. Note that this option can be useful in scenarios where the end user has to know the right format to be able to access information.
For example, in the below scenario : A user has to know the right format for the column Room below to be able to access this data.
Note: The suppress list of values is not the only way a user can type values. They may also enter it in the Values field in the above dialog directly.
Issue/Introduction
This article describes the filtering option in Statistica Enterprise data configuration: Suppress list of values
Feedback
Yes
No
Powered by
