Just Ask

Objective

After completing this lesson, you will be able to query Just Ask to search your data.

Contents

  • Prerequisites
  • Launch Just Ask
  • Search for Data
  • Explore Results in Data Analyzer
  • Summary

Just Ask is the new natural language query feature powered by AI. With Just Ask, users can query SAP Analytics Cloud data models by asking questions in everyday English, and Just Ask will instantly provide answers as charts and tables.

It supports SAP Analytics Cloud acquired data models and SAP Datasphere models. The latter works either with models from SAP Datasphere added by end users, or acquired data models that have been added by an admin user to the system.

Review the Help Portal for more information on Just Ask.

In this lesson, you use Just Ask to query your Sales Analytic Model, defined in the SAP Datasphere unit. The result is displayed as a chart or table, and refined. For further exploration, you use the Data Analyzer tool.

After completing the lesson, your Just Ask session should look similar to:

Prerequisites

You have completed one of the following to have your own Sales Analytic Model in SAP Datasphere.

  • Analytic Modeling unit to create the Sales Analytic Model
  • Import Analytic Model optional lesson to import the Sales Analytic Model template

Launch Just Ask

  1. Select Home in the side navigation panel.

    Note

    : If there is an open story from previous units, save and close the story first.

  2. Select the Just Ask icon from the main toolbar.

  3. Confirm the Welcome message popup.

  4. Just Ask appears with the model selection and the Ask a question input field.

    • You can search Just Ask without selecting specific models. The underlying artificial intelligence will search the most relevant models for your search prompt.

    • If you know what models you want to search, select the models in the model dropdown list to the left of the search field. The dropdown has a list of available models already indexed for Just Ask.

  1. Select the dropdown list to the left of the search field.

  2. Select Add Another Model to Search to add models to the current Just Ask session.

  3. Select the SAPDSP SAP Datasphere connection.

  4. Select your SAP Datasphere space in the result list.

  5. Select Sales_Analytic_Model, the analytic model that you created.

  1. [Alternative] Select 4OV_Sales_Analytic_Model, the analytic model that you imported.

Set the variables inherited from the Analytic Model.

  1. Keep the default variables and select Set.

  2. Confirm the Successfully Added popup.

  3. Open the model dropdown list and collapse it again.

    Note

    : Your selected model is listed under

Using Suggestions

In the query input field, type ahead suggestions appear in gray while typing and can be used to autocomplete a word by pressing the right arrow key. Other suggestions can also be selected from the dropdown using the mouse or keyboard: Use the down and up arrow keys and press enter for selection.

Selecting Measure and Dimension

By selecting the ‘+’ Add to Search icon at the left of the search bar, you can directly select from the list of available measures and dimensions of the data model, to populate the search field.

Search for Data

  1. In the Ask a question field, enter show grossamount by region, country, and select the Search icon.

By default, the results are displayed as a chart.

  1. View the generated chart and underlying model used.

    On the right-hand side of the screen, suggestions related to your previous question are shown.

You want to further refine your search to display year-specific data.

  1. Update the search, show grossamount by region, country in 2023 as pie chart, and press Enter or Search.

    Add in 2023 as pie chart to the search text.

Review the Help Portal for more information on Just Ask Search Inputs.

  1. Select the Edit Chart option.

    In the right panel, the chart type and the measure can be replaced or further dimensions added.

  2. Unselect the Edit Chart option again.

You have the option to switch the chart to a table.

  1. Select the Table option to display the results in tabular format.

    The result is generated with AI and the table structure may differ.

Explore Results in Data Analyzer

The data can also be analyzed further.

  1. Select the Analyze Data to display the results in the Data Analyzer.

  2. The Data Analyzer opens in a new tab. The tool is similar to the Analytic Model Preview tool of SAP Datasphere in terms of functionality and handling, which is introduced in the Analytic Model unit.

  3. Within the Data Analyzer, you can explore your data set. To add the product category ID:

    • A - Select the Builder icon on the right panel
    • B - Open the Available Objects if the measure and dimension selection panel is not displayed
    • C - Expand PRODUCTID and select PRODUCTCATEGORYID as rows

  1. Within the Data Analyzer, you can:

    • Save the results
    • Export the data as Excel, CSV, or PDF

  2. Close the Data Analyzer tab in your browser and go back to the Table format tab.

  3. Select the Chart format tab to return to the query visualization.

    Optionally, you can enter further queries in the Just Ask input field.

  4. Select Exit Just Ask to leave the session.

Summary

Congratulations! You have used Just Ask powered by artificial intelligence to provide answers in a chart or table format and integrated Data Analyzer.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn