Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
francois_imberton
Product and Topic Expert
Product and Topic Expert

Just ask is the new natural language query feature powered by AI. With just ask any user can query SAC data models by asking questions in everyday English. It supports SAP Analytics Cloud acquired data models and SAP Datasphere models

The initial release of just ask is version 2024 Q1 QRC or 2024.02.

Just ask is available in tenants running in Google Cloud Platform, Microsoft Azure, and Amazon Web Services data centers. Just ask is enabled for end-users through a tenant administration toggle. It is turned off by default. When turned on end-user will access just ask instead of search-to-insight.

Access to Just Ask

just ask is accessed directly from the SAP Analytics Cloud home page using the search bar and from light bulb icon in the main toolbar.

The search bar on the home screen is optional and can be enabled from the home screen settings.

SAC Home Screen.pngLaunching just ask from the home screen and the main toolbar

francois_imberton_1-1706453980559.pngJust ask main screen

Before Asking a Question

Selecting Models

Before asking a question, best is to narrow down the query by selecting one or more models. The available models are acquired data models that have been added to just ask and indexed by administrators.

francois_imberton_2-1706454980835.png

To query an SAP Datasphere model, end-users need to select a data model by selecting  Add Model to Search. Browse SAP Datasphere connections and spaces and pick an SAP Datasphere Analytic Model or Analytical Datasets. Once selected, the SAP Datasphere model will remain available for the duration of the session.

francois_imberton_3-1706455002679.png

Using Suggestions

Type ahead suggestions appear in grey while typing and can be used to autocomplete a word by hitting the right arrow key. Other suggestions can also be selected from the drop-down using mouse or keyboard: down & up arrow key and hit enter for selection.  Type ahead suggestions appear in grey while typing and can be used to autocomplete a word by hitting the right arrow key. Other suggestions can also be selected from the drop-down using mouse or keyboard: down & up arrow key and hit enter for selection.

francois_imberton_0-1706457838154.png

On the right-hand side of the screen suggested questions are based on the previous question.

francois_imberton_1-1706457838159.png

Measure & Dimension Picker
By pressing the + icon at the left of the search bar, the user can directly select the measures and the dimensions from the data models.

francois_imberton_2-1706457838162.png
Sample Questions

In addition to generated suggestions, administrators can define sample questions. These are available from just ask main screen.

francois_imberton_3-1706457838166.png

 

Exploring the Answer

From the natural language question just ask generates a technical analytical query and returns an answer as a visualization. At the bottom of the visualization the filters inferred from the query are displayed. In this example “How did client visits impact travel expenses last year in Denmark?” Last year generates a filter on year 2023 and in Denmark generates a filter on Country Denmark.

francois_imberton_4-1706457838172.pngAt the top of screen, buttons enable to switch to table, to open the visualization in Data Analyzer for further analysis and to copy to clipboard that can be pasted in an optimized story, (classic stories are not supported).

The ellipsis menu provides access to filters, sort, rank, csv export and additional options for tables and charts.

francois_imberton_5-1706457838176.png

 

 

Administration

Just ask administrators are accounts that are assigned a role with the just ask Managed permission. Built-in roles such as Admin, BI Admin, BI Content Creator or Modeler include this permission.

francois_imberton_6-1706457838181.png

 

Administrator Tasks

The main task of just ask administrator is to add models so that it can be queries by end users.

francois_imberton_0-1706463273847.png
Access to just ask model management via the “Managed models” button

francois_imberton_1-1706463273855.pngJust Ask model management area 

In addition, for indexed models. Once a model is indexed administrators can define synonyms and rules see details in the rollout section.

In this initial release only acquired models can be indexed. 

Indexed versus non-indexed models

Just Ask enables to query indexed models and non-indexed models  The table below summarizes the differences

 Indexed modelNon Indexed
Administrator not required to query model✔️
Administrator can define synonyms & rules✔️
Initial NLQ Scope✔️
Acquired models✔️✔️
SAP Dataspheres models✔️
Model selection by users required✔️
End user can narrow down query to selected models✔️✔️

Turning Just Ask On

Initially just ask is not active, end-users will keep using search-to-insights. This lets administrators prepare just ask before exposing it to end-users. To turn it on just ask for end-users, administrators will turn on the tenant wide Conversational Analytics toggle located in the Default Appearance tab in System Administration page.

francois_imberton_7-1706457838188.png

 

SAP Datasphere

In order for an end-user to select SAP Datasphere analytic models and analytical datasets, an SAP Datasphere connection must be created. End-user must be assigned an SAP Analytics Cloud role with the Connection:Read permission. End-user must have an SAP Datasphere user account, and to be a member of at least one space and permission to read models

More detail please refer to the documentation:
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/ad4281e2875949f0b4d45...

Preparing for Rollout

Data Modeling

Before turning on just ask, administrators need to work with end-users, to identify relevant data and add to just ask the corresponding data models. In some scenarios, existing data models - that have been designed for professional story creators - may not be suited for end-users. Dedicated modeling work for end-user consumptions may be required. For instance, models may expose too many entities, entities with a meaning that require expert knowledge or conversely model may not include measure or calculations that are expected by end-users.

Synonyms

To complement modelling work, to tailor just ask to the terms end-users use and are familiar with, administrator can define synonyms to model entities and to dimension values,

Defining synonyms to a dimension name

francois_imberton_9-1706457838193.png

Defining synonyms to dimension values.

Rules

Rules may be used to provide relevant answers when end-user questions carry an implicit context not included in the question. For instance, a user may ask about the relationship between client visits and travel expense:” show me client visits and travel expenses” but he or she is looking for:” show me client visits and travel expenses by sales agents

Rule conditions are based on the terms used in the question, when condition is met and action can be to sort results, add a filter, and or remove an entity.

Define Rules.png

Auhorization

A data model together with its synonyms and rules target a specific audience. Such data model may be irrelevant and may confuse other end-users. Great care should be taken to ensure that only the target users have access to a given model. Firstly, by adding to just ask only models that are relevant for Natural Language Query and secondly by ensuring that model access rights are defined appropriately in SAP Analytics Cloud and in SAP Datasphere.

Rollout

Rollout may occur using a  phased  approach per audience and data models. In addition to the steps before rollout described above, a good practice to ensure successful adoption is to organize training sessions and material to help users grow their understanding of the data models.

 

17 Comments