Skip to Content
Author's profile photo Former Member

Text Search Filtering in Webi Reports

We can filter report results based on Text search strings.

  1. Create a new input control that sets a variable to whatever the user types.
  2. Create a second variable that searches the dimension we want to filter on for the string contained in the first input control variable
    • The variable will output 1 if the search string is found, 0 otherwise
    • The variable should force the search string and the dimension we are searching to be all upper or lowercase
    • The variable should check the POS function for a non-null value to determine if the search string exists.
  3. We can search 1 or more fields by duplicating the search condition for each dimension to search
  4. Insert the variable as a column in the tables you want to search and mark it as hidden (optional), and apply a filter based on the variable to the table or report.


=If Pos(Upper([ValueToSearch]); Upper([SearchString])) > 0 Then 1 Else 0

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo wang zhanhui
      wang zhanhui

      Sorry,I don't understand。