SAP Analytics Cloud – Application Designer – Tab Strip + Timer Widgets:

SAP Analytics Cloud ( SAC )  has introduced new widgets in Application designers such as  Timer, Tab Strip, Panel etc. Here in this blog , we will be talking about the tab strip and timer widget and it’s use case.

Tab Strip:

As name implies, Tab Strip is a container widget that is used to view tabbed pages. We can add multiple tabs and place widgets within each tab. It acts as its own separate canvas. By default, the tab strip comes with 2 tabs but we can add as many from the builder panel and change text for each Tab.

Tab Script has scripting events onSelect which will be executed whenever the end-user changes the tab.

Timer:

Timer object enables you to start a timer to trigger timing events. By leveraging the feature of a timer, you can realize different scenarios such as:

  • create animations
  • send notifications to end users regularly
  • refresh your analytics application in a certain interval of time

In this blog, we will add a tab strip widget and create 4 tabs. In each tab we will add charts. And then we will create an application where its tabs/pages change automatically when user clicks on Play button and stops whenever he/she wants by clicking on stop button.

Addition to this we will add two right and left helper button for manually changing the tabs from left to right or right to left.

Now, lets go and see how it can be used in SAC:

I hope you have basic understanding of SAP Analytics cloud , application designer and how applications can be created in it.

Pre-requisite for learning SAP Analytics designer is to have understanding of Javascript.

Step 1: Open SAC, From the top select Create and then go to Analytic Application.

Step 2: Add a tab strip widget into Canvas area of application. Add multiple charts in each of the tabs.

** I have used a shape to hide the  header of the tab strip.

Step 3 : I have added 4 images in the canvas :

  1. Play Button
  2. Stop Button
  3. Right Button
  4. Left Button

Step 4 : create the timer object : Timer_1 :

Step 5 : Now Create  functions leftToRight() and rightToLeft() which will be invoked when pressing the above buttons that will change the tabs from left to right or right to left.

function leftToRight() { var key = TabStrip_1.getSelectedKey(); if (key === "Tab_1") { TabStrip_1.setSelectedKey("Tab_2"); } else if (key === "Tab_2") { TabStrip_1.setSelectedKey("Tab_3"); } else if (key === "Tab_3") { TabStrip_1.setSelectedKey("Tab_4"); } else if (key === "Tab_4") { TabStrip_1.setSelectedKey("Tab_1"); } } Function rightToLeft() { var key = TabStrip_1.getSelectedKey(); if (key === "Tab_4") { TabStrip_1.setSelectedKey("Tab_3"); } else if (key === "Tab_3") { TabStrip_1.setSelectedKey("Tab_2"); } else if (key === "Tab_2") { TabStrip_1.setSelectedKey("Tab_1"); } else if (key === "Tab_1") { TabStrip_1.setSelectedKey("Tab_4"); } }

Step 7 : Add scripts for each of the buttons to perform actions:

Play Button :

Start the timer object which will invoke the Timer_1 function.

Timer_1.Start(0);

Stop Button :

Stops the timer.

Timer_1.Stop();

Left Button :

triggers the function leftToRight() in order to change the tabs manually from left position to right.

PageHelper.leftToRight();

Right Button :

triggers the function rightToLeft() in order to change the tabs manually from right position to left

PageHelper.rightToLeft();

Now in the timer function, we need to define the interval for which the tabs changes automatically.

Here is the demo :

Conclusion :

With SAP Analytics Cloud Analytics Designer you can create applications for data analysis to meet sophisticated business requirements. It provides a dedicated development environment with advanced scripting capabilities.

Serverless Extensions – Part 5: Bring it all together – Testing the extension end to end

Now that we have configured and connected all the services required for our scenario, let us test out the two additional functionalities we set out to achieve.

Scenario 1

Create a promotion applicable for all the customer groups.

The application sends a message to the ‘promotions’ queue we set up (refer part 1)

 The message sent is picked up by the trigger to the ‘Master’ function(refer part 4). This function gets the contact number for the priority customers from the backend service and sends the WhatsApp message using the open connectors (refer part 1)

 

Since this promotion applies for all the customers, it gets published on twitter as well.

SCP functions service records execution logs which you can access from the dashboard.

 

Scenario 2

Let us try to create a promotion applicable only for the priority customers. 

 

In this case, the priority customers receive the promotion information through WhatsApp. The promotion does not get published on twitter.

I hope this blog series proves helpful to any of you planning to extend the legacy application using the services offered by SAP Cloud Platform.

SAP Data Intelligence 3.0 Walk Through

We recently released SAP Data Intelligence 3.0. My colleague Tobias Koebler  presented new features included in this 3.0 release in his blog https://blogs.sap.com/2020/03/20/sap-data-intelligence-development-news-for-3.0/.

In this blog, I will demonstrate SAP Data Intelligence, showing several aspects of SAP Data Intelligence 3.0 with a series of 7 videos, including the launchpad, connection management, metadata management, pipeline modeling, and ML scenario manager.

SAP Data Intelligence Launchpad

In our first video, we show you SAP Data Intelligence Launchpad. SAP Data Intelligence Launchpad is a browser-based application that provides a single point of access to a range of user-facing applications. The applications displayed in the Launchpad vary for different users and depend on the user logon credentials, which are dependent on user roles or personas, such as data engineer, data scientist, business analyst, IT user, data steward, and so on. The Launchpad enables you to organize, personalize, and launch the SAP Data Intelligence applications including grouping applications, ordering applications, removing applications, creating quick links, etc.

SAP Data Intelligence Connection Management

Before you can do anything with SAP Data Intelligence, SAP Data Intelligence administrators or other business users with necessary privileges use the SAP Data Intelligence Connection Management application to create and maintain connections. A connection represents an access point to a remote system or a remote data source. The connection management video shows connection management functionalities, including a list of connections available in your SAP Data Intelligence instance and the type of connections that SAP Data Intelligence supports. You can create a new connection, delete an existing connection, or check the status of the connection.

After your administrator(s) created connections and provided you access to the SAP Data Intelligence instance and to the connections, you can perform a series of operations and, based on your persona, the order will be different.

SAP Data Intelligence Metadata Explorer

As a data steward or a business analyst, you can use Metadata Explorer to perform metadata management functionalities available in SAP Data Intelligence. The use cases supported by Metadata Explorer include three use cases.

The first use case is data discovery and governance. It is not easy to find the dataset that you need for your uses. Even after you find a potential dataset, you may not trust the data itself for several reasons. In many cases, you will need to evaluate the data quality based on the source of the data, you may need feedback from other users, or the vocabulary to describe the attributes of the data may not conform your understanding. With a metadata catalog, along with a set of services including a business glossary, search, fact sheet, lineage, rating, and tagging, we support data discovery and governance in SAP Data Intelligence.

The second use case is data quality monitoring. The easy to use business rules and scorecards allow users to monitor data quality continuously.

The final use case is self-service data preparation, where business users and business analysts can leverage the data pipelining capability in an easy-to-use spreadsheet UI to enhance and enrich datasets.

In the third video of this series, we navigate all of the functionalities to perform the above three use cases in Metadata Explorer.

Data Preparation within SAP Data Intelligence Metadata Explorer

We demonstrate data discovery and data preparation in this video, where a easy-to-use search bar helps you find the dataset, filters search results based on additional knowledge, acquires data from a structured source, and enhances the dataset. Then we further enrich the data with another dataset from a Hadoop data lake and perform an inner join without doing any coding.

SAP Data Intelligence Modeler

In our 5th video, we show how a data engineer can create a data pipeline to replicate data from a non-SAP SaaS, here Salesforce using SAP Open Connector to SAP HANA and a cloud storage and also how to push data processed by data preparation to SAP Analytics Cloud for visualization.

Data Visualization with SAP Analytics Cloud

In our 6th video, we demonstrate how easy it is for a business user or a data engineer to use SAP Analytics Cloud to visualize data processed with SAP Data Intelligence.

ML Scenario Manager

In this series, we conclude showing navigation of ML Scenario Manager available in SAP Data Intelligence with the 7th video of this series.

I hope you have a chance to discover the SAP Data Intelligence product with these 7 videos.