After completing this lesson, you will be able to:
You can use wildcards as placeholders for partial pattern searches.
When you create a query filter using a wildcard, you must use one of the following relational operators:
To find values that match the pattern you specify.
To find values different from the pattern you specify.
The optional prompt uses the between operator and allows the user to enter two values to set the limits of a range, but the user enters only the lower end of the range. As a result, the generated query updates the operator from between to greater than.
When a prompt is made optional, the user can choose to ignore the prompt. The result is that everything is returned in the report. For example, if you make a year prompt optional, all years are retrieved in the report if the user chooses not to answer the prompt.
For example, you can use the prompted query filter to produce a report that shows sales revenue per state and prompts the user to choose a product category at each refresh.
This way, you do not restrict the data displayed to a single product category, such as Jewelry. Instead, users choose the product category that interests them at that moment.
You can define prompts on any dimension, measure, or attribute object listed in the Universe outline in the Query Panel.
Note
To create a prompted query filter, use the Prompt operand.
After you choose the Prompt operand, choose Parameter Properties between the Prompt text field and Operand type to display the Parameter Properties dialog box.
The options you define for the prompt determine how the Prompts dialog box appears to users and how users can specify the values for their reports in the dialog box.
After you have run the query and reviewed the data displayed in the report, you may need to change the filter criteria.
By simply refreshing the document lets you change the filter values without needing to return to the Query Panel.
You can save a group of most used variable value sets as a prompt variant in the Prompts dialog box.
After the Web Intelligence document query is created, run, and saved for the first time, when you refresh or open the document, you can see the available prompt variants options in the Prompts dialog box. Once you have selected the values for each prompt in the Prompts Summary UI, you name and save the variable value set as a prompt variant. It is subsequently available in the Prompts dialog box from the available prompt variants list.
Note
"Prompts" dialog box features:
To produce a report that precisely focuses on certain data, you may need to apply more than one filter. When you specify more than one filter in a query, the relationship between the filters must use either the AND or OR operator. These are known as logical operators.
The types of logical operators are as follows:
You use AND when you want both conditions to be met to return a row from the database when you run a query.
You use OR when you want either of the conditions to be met to return a row from the database when you run a query.
See the following video to learn more about the operators.
A complex filter uses more than one filter in a single query. To ensure that the filters retrieve exactly the data you want, you need to prioritize the operators.
In the Query Filters panel, by positioning the query filter statements and deciding how to group them together, you define the filters that are processed first. The positioning and grouping of the filters depends on the logic of the information you are trying to retrieve.
Log in to track your progress & complete quizzes
