Using Explorer and Smart Insights
SAP Analytics Cloud provides powerful tools to let you explore and gain insights into your data. These tools are used in both stories and analytic applications with some minor differences in usage. Only the usage specific to the analytics designer is described here.
When you run an analytic application, you can launch the Explorer for a chart or table to select different dimensions and measures, experiment with filters, and more.
Before running an application and initiating the explorer, you need to enable the explorer for the charts or tables in the Builder tab of the Designer panel as you do for an ordinary story.
There are two ways to launch the explorer:
-
Save the application and choose Run Analytic Application. Just as you do in a story, select the chart, and then select
(Explore). -
Leverage the script API to launch the explorer mode in the application to generate charts or tables for data exploring. The script API can set additional dimensions and measures to the current data source in explorer mode and trigger launching of explorer. For example:
Sample Code//Add Travel_Date and Traveler dimensions to current dimension scope for data exploration. Chart_1.getDataSource().getDataExplorer().setAdditionalDimensions([“Travel_Date”, “Traveler”]);
For more detailed information about the APIs, refer to Analytics Designer API Reference in the SAP Help Portal.
In the Explorer, you see a faceted view of your data, which
you can manipulate to generate charts for preview. To be able to save a chart to a
new story directly from the Explorer, select the option Create Story from
Widget in the section Quick Menus of the
chart widget's Styling panel when you design the analytic
application. You'll then be able to select the
icon in the
Explorer's visualization area and choose
Create a New Story.
To trigger applying data explorer’s results to a table or chart widget, you can add custom menu items to the Explorer's visualization dialog as below:
-
In Scripting section of the Outline panel, from
Data Explorer Configuration, add a new
configuration.The Data Explorer Configuration panel is opened on the right side.
-
In this panel, add custom menu items in the Menu Settings.
-
Write script for the onMenuItemSelect() function of this DataExplorerConfiguration scripting object to define the activities you want to trigger when selecting these menu items.
Sample CodeSay you want to apply the changes you’ve done to Chart_1 in data explorer’s dialog to another chart Chart_2, write the script below:var explorer = Chart_1.getDataSource().getDataExplorer(); if (Chart_2.isVisible() === false) { DataExplorerConfiguration_1.applyToWidget(Chart_2); Chart_2.setVisible(true);}NoteResults of a chart can only be applied to a chart widget, so does the table widget. We don’t support carrying over all the Show/Hide settings in the Data Explorer as well as the original widget styling settings to the target widget.
-
Save and run the analytic application.
-
Select the
icon in the
Explorer's visualization area and choose the menu
item you’ve defined.
At last if you want to save the updated table or chart, you can bookmark the application or publish it to PDF.
Smart insights automatically discovers key insights, including correlations, exceptions, clusters, links, and predictions of data, and brings you straight to the results instead of requiring time-consuming manual data exploration.
In an analytic application, smart insights is only available if Explorer is enabled.
You also need to make sure you have selected Smart Insights in the Quick Menu section of the Styling panel of the corresponding chart or table widgets.
There are two places you can trigger smart insights for a chart or a table:
-
After you run the analytic application, trigger smart insights by selecting a data point in a chart or right clicking a data cell in a table.
-
After you run the analytic application and enter the Explorer mode of a certain data point, go to the visualization area and trigger smart insights by selecting a certain data point in the chart or right clicking a data cell in a table.
You cannot trigger smart insights for charts and tables in a popup.
Furthermore, you can continue to run smart insights with generated data in the smart insights panel or create a story based on the visualization generated in smart insights if you've enabled creating story for the chart or table widget when designing the application. To do this, in the Quick Menus section of the chart or table widget's Styling panel, select the option Create Story from Widget.