In the previous blog in this series, you learned about adding, updating, deleting members in Analytics Designer. In this blog, we will learn how to integrate the Search to Insight feature with Analytics Designer by using various scripting APIs.

SAP Analytics Cloud offers a smart data search feature – Search to Insight. It is an intuitive feature that allows you to gain insights by querying your data using natural language. From version 2020.01, Search to Insight is available for integration into analytic applications.

Imagine you are building an analytic application for business users of all the divisions in your company. Each user’s requirement may vary, and those cases can be challenging. You can add a tab for ad-hoc analysis using the Search to Insight component to facilitate these requirements. This allows them to analyze data with a simple search. You can see the Search to Insight integrated application in action below.

SAP Analytics Cloud – Application Design Series 28 – Search to Insight integration

 

Prerequisites

  • Index Model – Enable Index Model option under General Settings in model preferences. This allows querying all dimensions and members of the model using the Search to Insight feature. Please note that acquired models have this option enabled by default.

    Enable Index Model to use Search to Insight feature

     

  • Create Search to Insight component – Add a Search to Insight component under the Search to Insights section to access the Search to Insight scripting APIs. Add the models required for Search to Insight analysis.

    Add Search to Insight component

     

Search to Insight APIs

The APIs used to integrate the Search to Insight feature are:

  • SearchToInsight.openDialog() – to launch Search to Insight dialog by passing values for the questionmodeclean history, and auto search parameters. The mode is of two types,
    • Simple- for simple queries without changing the model
    • Advanced- it allows you to switch models and select dimensions and measures based on your requirements to gain deep insights
  • SearchToInsight.applySearchToChart() – to apply insight findings to a chart

Detailed below are the steps in building this smart Search to Insight integrated application:

  1. Setting up canvas and widgets

As a first step, add the necessary widgets to the canvas. Here the application has input fields, dropdowns, buttons, charts, and text boxes for info.

Add widgets to the canvas

Bind elements to the Select Mode dropdown as shown below.

Bind elements to the mode dropdown

Bind elements to the Select Chart dropdown as shown below.

Bind elements to the chart dropdown

 

  1. Launch Search to Insight dialog

In the onClick event of the Search to Insight- Open dialog button, add the below script to trigger the Search to Insight dialog with the mode selected in the dropdown, the question typed in the input field, and the last two Boolean parameters to clean history and auto search, respectively.

Add script to the open dialog button

 

  1. Add chart for Search to Insight findings

In the onClick event of the Add chart for insight button, add the below script to apply Search to Insight finding to the selected chart and toggle that chart’s visibility to ‘true’.

Add script to the chart for insight button

 

There are also many interesting new updates to the Search to Insight feature. One among them is synonyms for measure and dimensions. From the Q3.2020 version, you can add synonyms for measures and dimensions available in your model to help business users who are not familiar with actual entity names in framing Search to Insight questions accordingly. We will keep you posted about new updates in the Search to Insight feature.

SAP Analytics Cloud – Application Design Series 28 – Search to Insight integration

Add synonyms for measures and dimensions

 

Click here to evaluate if SAP Analytics Cloud is right for you. To know about the analytic applications of SAP Analytics Cloud, please check out our blog series here.

 

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com