Using NLQ On Your Data in WebFOCUS Designer

How to:

Natural Language Query, or NLQ, lets you ask questions of your data using everyday language. This provides you with valuable insights and allows you to make informed business decisions.

NLQ translates natural language into SQL code that can be executed against a database. The natural language phrases are matched with relevant database schema columns within your data, and your query results display as a table.

Examples of natural language queries include:

Procedure: How to Use NLQ in WebFOCUS Designer

You can access NLQ from WebFOCUS Designer and make natural language queries against your data to gain insights.

  1. From the Hub, click the plus menu.
  2. Click Assemble Visualizations.

    The Template dialog box opens.

  3. Select a page template.
  4. Click Container on the sidebar.

    The Container tab opens.

  5. Drag-and-drop or double-click on the Explore Data widget in the Container tab to add it to the canvas.

    The Explore Data Sources dialog box opens, as shown in the following image.

  6. Click the data source icon .

    The Select Data Source dialog box opens.

  7. Navigate to your data source.
  8. Click the Select button.

    Your data source is added to the Explore Data Sources dialog box.

    You can click Add Source to select another data source.

  9. Click OK.

    Your data displays in the canvas container, as shown in the following image.

    You can click Edit data sources in the container to return to the Explore Data Sources dialog box.

  10. On the visualization toolbar click the Run icon .

    Your data runs in a new window. The column names of your selected data source are displayed when you click inside the text field, as shown in the following image.

  11. Type a query about your data in the text field. Relevant column names that match your phrase display as you type.
  12. Click Ask.

    The result of your query displays as a table, as shown in the following image.

  13. Click the output options button .

    You can run your query results in a new window by selecting the Run in a new window option.