Configuring Standard API in S/4 HANA Cloud

Generating OData of standard API:

First we have to login to SAP business accelerator hub account and go to SAP S/4 HANA Cloud Public edition.

SAC Content Transport (Migration) Using CTMS

Different ways to transport SAC Content

SAC Provides three ways to transport your content from one tenant to another,

File System mode - In this method, using the menu option Transport > Export > File System, you create a package of your SAC content & its dependencies and download it to your local system in a .tgz file format, and import this .tgz file in your destination environment using the menu option Transport > Import > File System. This option is as simple as downloading from one location and uploading to another location.

Integration Between SAP Datasphere and SAP Analytics Cloud

Introduction

This blog series discusses the integration between SAP Datasphere with SAP Analytics Cloud for data harmony. I aim to provide an overview of SAC, discuss the process of establishing both live and OData connections between SAC and Datasphere, explore Optimized Design Experience, delve into the current planning capabilities bridging these two products, and more.

 

In this introductory blog, I want to provide an overview of the following key aspects for integrating data between SAP Datasphere and SAP Analytics Cloud:

Unleashing the Power of Custom Widgets in SAP Analytics Cloud

In today's world where data is crucial, it's really important to have analytics solutions that fit our business needs perfectly. With SAP Analytics Cloud (SAC), we can create custom analytical applications that are just right for our needs. One cool thing we can do with SAC is develop custom widgets. These widgets help us add more functions to SAC beyond what it already offers. In this blog post, I'm excited to talk about my experience making a custom SAC widget using a JSON file.

Prerequisites:

1. Proficiency in JavaScript and JSON: Custom widgets in SAC are developed using JavaScript and defined using JSON files. Ensure that you have a good understanding of these languages and their syntax.

Import Data Connection to SAP S/4HANA in SAP Analytics Cloud: Technical Configuration

In this blog we’ll discuss complete steps for Import data connection from S/4 hana on-premise system to SAP Analytics Cloud. The Operating system we are using on which S/4 Hana system is installed is SUSE Linux SP 15.

Here, Our Data source is S/4 Hana from which the SAP Analytics Cloud is connected using the SAP Analytics Cloud Agent and SAP Cloud Connector.

Integrate C4P-Resource Management with SAP Analytics Cloud or SAP DataSphere

Summary

Embarking on the journey of leveraging SAP S/4HANA Cloud for Projects, Resource Management (C4P), this blog simplifies the process of accessing its APIs, with a focus on the Resource Request functionality. Beginning with preparations, where we gather key information like API URL and credentials, we then explore the capabilities of the Resource Request API in the Business Accelerator Hub. We break down how to find the right URL for accessing resource requests and demonstrate how to connect these APIs to tools like SAP Analytics Cloud or SAP DataSphere. By following these steps, users can seamlessly integrate data from C4P into their analytics workflow, enabling better decision-making and operational efficiency.

Connect & Visualize: SAP Datasphere with Qlik Sense

In this Blog, We'll explore how to consume data from SAP Datasphere through ODBC (Open Database Connectivity) and Visualize the data in Qlik Sense which is one of the leading Data Visualization Tools.

Why SAP Datasphere over others?

SAP Datasphere allows seamless connectivity with a wide range of data sources, including on-premises and cloud-based systems. SAP Datasphere is designed to handle large volumes of data efficiently, making it suitable for organizations of all sizes, from small businesses to large enterprises. Its scalable architecture ensures optimal performance even as data volumes grow over time. Graphical low-code/no-code tools to support self-service modeling needs for business users. It has Powerful built-in SQL and data flow editors for sophisticated modeling and data transformation needs.

Multiple Input parameter in Hana Calculation graphical view

Aim: To create a calculation view with multiple input parameter that should display data corresponding to the input parameter.

The entire calculation view is here,

Analyze SAP S/4HANA On-Premises Data using SAP Analytics Cloud Powered by SAP Data Warehouse Cloud

This simple blog post helps you get an understanding of how data from an SAP S/4HANA on-premises system can be Analysed using SAP Analytics Cloud which is connected using Data Warehouse Cloud in SAP Business Technology Platform (BTP).

This blog post covers –

◉ Connectivity of SAP S/4HANA On-premise system to SAP Data Warehouse Cloud.

◉ Creation of a View using SAP Data Warehouse Cloud Data Builder.

◉ Consume the View in SAP Analytics Cloud and create a story.

Jupyter Notebook and SAP HANA: Persisting DataFrames in SAP HANA

Introduction

Jupyter Notebook or R are often the tools of choice for data scientists. It makes using data operations, data exploration and sharing convenient. SAP HANA is the database of choice for the most important businesses around the globe. Connecting both worlds, Jupyter Notebook and SAP HANA provides an incredible potential which needs to be seized.

SAP HANA

Jürgen Müller already provided a great blogpost about SAP HANA. I want to shortly formulate what SAP HANA is also with my own words. SAP HANA is an in-memory database which provides a lot of benefits, especially for analytical use cases. It connects different aspects of databases within one database. Besides typical properties of relational databases, it also delivers properties of NoSQL databases, like column-based databases. Depending on use-case, it is possible to activate or deactivate specific properties so that you can get the best performance out of your system.

SAP Analytics Cloud – TroubleShooting – Timeline Traces

There are tons of different ways how you can performance traces on SAC for troubleshooting. In this blog I will talk about one of the tracing methods called (TIMELINE TRACES) that can be very helpful when there are performance problems being observed in SAP Analytics cloud (SAC) regardless if the connection is with BW or S/4HANA etc.

Step 1:

Log on to your SAC Tenant.

Step 2:

Once you are logged on to the SAC tenant open CHROME developer tools in the same browser window where you have the Tenant open.

Transforming Hierarchy using HANA Calculation view

Introduction:

This blog post is on usage of two powerful Nodes namely Hierarchy function and Minus Node in HANA Calculation view. Both Nodes are available in SAP HANA 2.0 XSA and HANA cloud.

Minus and Hierarchy function Node are available starting SAP HANA 2.0 SPS01 and SPS03 respectively for on premise and available in SAP HANA CLOUD version.

This use case will be helpful in business scenario where one wants to migrate from SAP BW 7.X to SAP HANA 2.0 XSA or SAP HANA Cloud. SAP BW is known for Data warehousing and strong reporting capabilities. While migration from SAP BW to SAP HANA 2.0 or SAP HANA cloud some of features are not available out the box. In this case HANA cloud is considered as backend for data processing and modelling purpose and Analysis for office for reporting.

Forecasting Intermittent Time Series with Automated Predictive (APL)

Starting with version 2203 of the Automated Predictive Library (APL) intermittent time series are given a special treatment. When the target value has many zeros, typically when the demand for a product or a service is sporadic, APL will no longer put in competition various forecasting models, but it will systematically use the Single Exponential Smoothing (SES) technique.

For SAP Analytics Cloud users, this functionality is coming with the 2022.Q2 QRC release in May.

Let’s take the following monthly quantity as an example.

SAP BTP End-to-End Demo: Integration of Qualtrics

Introduction

In this blog post I will demonstrate how to load Qualtrics Survey Data via a custom SAP Data Intelligence operator into a SAP HANA Cloud table for use in SAP Data Warehouse Cloud and SAP Analytics Cloud. I will show how solutions from unified data and analytics can be used together to get insights from a Qualtrics Survey by going step by step over how to integrate Qualtrics in them creating an End-To-End-Story.

This demo is split in the following parts:

Part 1: Creating a survey in Qualtrics that you can publish to gain valuable insights into customer opinions about a topic you are interested in

Part 2: Loading the survey data into a SAP HANA Cloud Table by creating and using a custom python operator in SAP Data Intelligence

RISE with SAP: ‘Defence in Depth’ Security Architecture with SAP S/4HANA Cloud (Public Cloud)

Introduction

The SAP S/4HANA Cloud is at the core of “Rise with SAP” offering. For a customer, it holds mission critical data used to implement business processes and data analytics. It is deployed in a public cloud as SaaS (Software-as-a-Service) offering. SAP S/4HANA Cloud is a “Multi-Tenanted” platform, delivering highly standardized content for various lines of business in an industry and for varieties industries. As digital transformation sweeps the IT industry, embracing cloud technologies is inevitable. In this context, cloud security is imperative to this transformation.

SAP S/4HANA Cloud runs on public cloud such as Google Cloud Platform (GCP), MS Azure and SAP Converged Data Centres around the world. SAP uses hyperscale providers who offer “Infrastructure-as -a-Service for greater flexibility, scalability, and security for the provisioning of cloud infrastructure. SAP S/4HANA Cloud tenant subscription includes provisioning of SAP Business Technology Platform (BTP) services such as Identity Authentication Services, Identity Provisioning Service, SAP Analytics Cloud, and In-App & Side by side via BTP / Extensibility Framework.

SAP & Dell Technologies – Transforming Data at the Edge, Cloud & Core

Organizations understand that, to thrive in the digital economy, they must derive better insights from the data they own — and do it in a more automated, reliable way. The faster this process, the faster the time to insights.

Enabling Dynamic Fiscal filtering in SAC (BW Live)

At time of writing, SAP Analytics Cloud (Q4, 2021.20) does offer dynamic calendar-based time filtering. This enables users to quickly analyse data for periods such as Current Year, Quarter and Month to Date. The same functionality is also exposed when working with SAP BW Live models containing a 0CALDAY dimension.

The limitation is that for BW Live models, the platform has no awareness of Fiscal / Financial periods. SAC offers no native mechanism to dynamically present common reporting scenarios such as Financial Year to Date, or even just Current Financial Year. All dynamic options Calendar based only.

How to assign one Selection screen input field value into another field [ Not input ready] in SAP analytics report [ BW Query] using SAP HANA Exit

Prerequisite

During the development of any SAP analytical report, we may required to access one 

selection screen variable value to be assigned to another selection screen variable.

So that the second variable will bring all the relevant information from the database.

Out of many, there is one scenario where users enter the value one selection screen field in the SAP analytics report. After input same value gets assigned into another selection screen field [ Not input ready]. See the below flow shows how the “ZVAR_WBS_HIER” value gets assigned into the “ZHE_WBS” variable.

Boost performance of SAP Analytics Cloud tables by using proper styling techniques

Does styling of my SAC table cause performance drawbacks?

In fact, every story designer can try out whether sophisticated styling is a performance driver of a table widget. Do the following to test whether performance issues of your table widget is caused by filthy formatting: Measure the performance of your table widget with styling and without styling and compare results. To remove all styling definitions of the table widget we can make use of table templates (figure 1) – switching the table template will prompt the story designer to eventually delete all styling definitions (figure 2) previously applied. In other words, styling will be reset after selecting a predefined template. Thereupon, we can use the refresh button at the toolbar to measure performance of the table widget without any applied styling. In case the table loads quicker without any formatting applied, this can be interpreted as a strong hint that previously applied styling definitions cause performance issues.

Blending Models with SAP Analytics Cloud

What is Blending?

Blending models lets you join a primary data source (such as ‘travel expenses’) with secondary data sources (such as ‘employee headcount’) that contain common linked dimensions (such as ’employee’). A new model is not created when you blend models, and the original models are not modified. Links between models that are blended only occur within a story. Blending can be done within individual tables and charts.

Some common uses for blending

◉ Comparing data of actuals from a corporate SAP source with plans stored from a non-SAP source.

◉ Comparing sales results against market benchmarks, or marketing campaign results available in .csv files, or data provided by a 3rd party consulting firm.

◉ Creating custom calculations based on key performance indicators from different data models like public census data.

◉ Using Smart Predict to output predictions in a dataset, and blend these predictions with other data sources, in the context of a story.