Some manufacturing process involves manufacturing products in steps spread over several days. Standard SAP creates the Supply to Production tasks for all the products in one go which is not viable as the raw materials need to be added to the production floor over a period of time. To gain efficiencies, would like to be....

In my previous blog “What is Mechanical Integrity”, I outlined how various codes and standards define and provide guidance on what should be included in a mechanical integrity program. In this post I would like to discuss, what it means to comply with these codes and standards? Compliance means different things to different regions or may....

You may remember the cringey performance of Steve Ballmer yelling “Developers!” on stage. Well, sometimes I would like to yell “APIs!” because they truly are at the heart of every cloud system and definitively deserve that shoutout. But I am not Steve, so I stay behind my keyboard and write blogs – lucky you. What....

This blog mentions the procedure to create a report to get the Competency average rating at the Legal Entity/Business Unit/Department/Section Level. Average Competency Rating at Legal Entity/Business Unit/Department/Section Level: Nowadays most companies are looking for competency ratings not only at the individual level but also at various organizational levels such as Legal Entity/Business Unit/Department/Section Level etc. Below are....

In Earlier Versions of HANA, to improve performance of the Model/Calculation view, it was suggested to stage the data in some physical table using a procedure and then create the calculation view on top of that staging table. This help us to fetch huge amount of data quickly as there are no calculations involved.To Avoid....

How can I consume an analytical query in ABAP ? Normally analytical queries are used with reporting tools like SAC, Analysis Office, WebDynpro Grid,  or RSRT in backend. This post show how to directly access and use the query within your own ABAP application by the use of Lightweight BICS API ( LBA ) . It’s really easy....

This blog aims to assist and complement the understanding of the Data Builder on a high level and is based on my personal learnings. SAP Data Warehouse Cloud’s Data Builder allows for technical personas to model underlying relationships of data from various sources and levels of granularity. It provides the ability of leveraging graphical interfaces....

So, you want to transfer group reporting transaction data from SAP S/4HANA Cloud to SAP Analytics Cloud? The good news is that you can do exactly this with the API Transaction Data for Group Reporting – Read (Version 2). But before you do this, you first need to create an Odata connection in SAP Analytics Cloud.....

Introduction Big Data is a term created in 1980 by American sociologist Dr. Charles Tilly in his article “The old-new social history and the new old social history” and although the context for the use of the term Big Data in this article was different at the time it was published in 1997 two NASA....

Have you ever wondered if your reporting rules are working how you expect? In SAP S/4HANA Finance for group reporting, reporting items and reporting rules are super useful features to help you out with all your analytics needs. You use them in reports to enable flexible data selection and aggregation. Reporting items are used as....

Hello World! Recently I worked on data-science challenges of my engineering team. During this work, I needed a way to persist a Pandas DataFrame (often known from Jupyter Notebook) in SAP HANA. In this blogpost, I want so share with you how this can be accomplished. The goal is to persist a Pandas DataFrame in....

Overview From a hosting point of view, a custom widget consists of two types of files: the custom widget JSON file (explained in more detail in previous blog) and the resource files. The custom widget JSON file contains the metadata of a custom widget. It defines all the ingredients of a custom widget and references its....

Embedded SAP Analytics Cloud in C4C Since 2105 Release SAP Cloud for Customer does not only have native Business Analytics to provide insights into your data but also offers embedded Analytics (based on SAP Analytics Cloud – SAC) functionality. This is part of the overall SAP Strategy to have a single analytics and reporting engine....

The latest release of the Automated Predictive Library (APL) introduces the capability to build several time series models at once from a segmented measure like Sales by Store for example or Profit by Product. No need any more to define a loop in your SQL code or Python code. Just tell APL what column represents....

Technical blog post on data lineage in SAP S/4HANA In this blog post we will lay out the technical aspects of SAP S/4HANA Embedded Analytics, specifically how to get from a process to the apps and eventually the underlying CDS-views and tables. This is called data lineage. This information can be helpful when an issue arises....

Common machine learning scenarios such as fraud detection, customer churn, employee flight risk, aim to predict Yes/No outcomes using binary classification models. But sometimes the target to predict has more than just two classes. This is the case of Delivery Timeliness that can have three categories: Early/On-time/Late. From this article you will learn how to....

1.    Introduction In this blog post I will share the experience and how to extract data from a third part API into SAP Data Warehouse Cloud. The solution is based on a micro-service concept that Christoph Christophersen explained on the blog post “Enrich Data in SAP Data Warehouse Cloud with Data from RESTful APIs | SAP Blogs “.....

  In my previous blogs I have brought you details of the many support and enablement materials and asset types we are bringing to you via the SAP Enterprise Support Value Maps. For your convenience I have added the links to those relevant blogs below. Today, I would like to reveal that we have reorganized....

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....

Bidgely is an AI-powered SaaS Company accelerating a clean energy future by enabling energy companies and consumers to make data-driven energy-related decisions. Powered by their unique patented technology, Bidgely’s UtilityAI™ Platform transforms multiple dimensions of customer data – such as energy consumption, demographics, and interactions – into deeply accurate and actionable consumer energy insights. Bidgely....

Federated Analytics is an architecture pattern that distributes queries directly to sources via the SAP Data Warehouse Cloud and helps to build richer live data analytics on SAP Analytics Cloud combining SAP and non-SAP data, thereby eliminating the need for data replication or duplication. SAP discovery center mission explaining  this architecture pattern  Related blog explaining Data Federation between SAP Data Warehouse Cloud and....

Camus Energy’s Grid Management platform empowers utilities and energy providers with system-wide visibility, forecasting, and advanced controls for a distributed, zero-carbon future. To tell us more about Camus Energy and how they are driving sustainability we have Michael who is the COO of Camus Energy.   What problem is Camus Energy trying to solve? Utilities....

Established in 2018, OilX combines advanced data science and satellite technology with extensive oil analytics knowledge to create the first digital oil analytics platform. OilX has more than 15 years of oil analytics experience across oil majors, investment banks, and hedge funds. To tell us more about OILX and how they are driving sustainability we....

Introduction: In this blog post, I will highlight the role of Machine learning in the current competitive environment and how ML is helping enterprises to respond to customers, competitors, regulators, and partners faster than their peers in transforming them as intelligent enterprises. According to Gartner (2020), 69% of routine work currently done by managers will....

If you have a business, you likely have a lot of data. It’s your one true source for insight to understand your customers, their needs, and what they want. In this blog, you’ll learn how you can monetize the data your solution generates with the data marketplace for SAP Data Warehouse Cloud and SAP BTP Startup Program from SAP.iO. To illustrate the....

If we travelled in a car that could take us to the future, where would we see FP&A? The future of FP&A would not be standstill. FP&A may borrow from many of the traditional planning and analysis processes, but will make them more dynamic and accessible to companies of all sizes. Instead of crunching numbers,....

As an administrator, you can select reports and embed them in the User Interface (e.g. add reports to the Ticket Thing Inspector). You can also map the data between the work center view fields and the embedded report fields so that the system filters the report data based on the supplied mapping. This blog will help you to understand how....

Walkthrough the new SAP Analytics Cloud design experience with me. Simplified Interaction and get you familiar with the tool by watching the below video.    

Data Crush COMING ON JUNE 28!!   PLAYING GAME WITH PRIZES  STARTS JUNE 28! SAP teams have been working on an interactive experience for you to learn more about SAP’s data & analytics solutions. I’m very excited to announce that the time has come to release the Data Crush 2.0 with four new levels for you to unlock. Data Crush....

Increase the Adoption of BI & Analytics with SAP Analytics Cloud Innovations for Businesspeople Save the date, register now, and join us for our upcoming #askSAP Analytics Innovations Community Call on June 24, 2021 at 11:00 AM Eastern Daylight Time The COVID-19 pandemic forced companies to respond to the crisis and then identify a clear path....

For Solution Advisors who occasionally receive customer datasets to analyze, running descriptive statistics to summarize, describe, and visualize the data is often the first step. In this blog, I will highlight two ways the hana_ml Python library can automatically generate visualizations your SAP HANA Dataset to help you quickly understand your data.  These can serve as handy....

Agility has become an increasingly important and more meaningful word for Finance, alongside other key words Responsiveness and Resilience, as I discussed in my earlier blog post concerning the impact of recent events on FP&A professionals. And while agility has been a word associated with Finance for some time, the events of the last year have placed....

Data is an asset that can be monetized in different ways that yield a high ROI. From consumable data sets and analysis results, businesses can go beyond reporting by incorporating the intelligence into existing products, digital platforms, or new business models. Take, for example, the SAP Analytics Cloud solution. When embedded in process and application workflows, the solution....

With 20.08 release of Cloud ERP SAP Business ByDesign customer and supplier ABC classification can be set directly from a report without the need to develop a custom analytical action using SDK. Here is a demo how you can embed the action and use it with the business analytics work center: With this customers can....

With release 20.08 of SAP Business ByDesign Cloud ERP marketing, sales and service employees can more flexibly analyze the sales forecast based on quotes and manually add a reference to presales and service documents. This allows more accurate sales forecasting on sales quotes with our without quote versions and to depict the relation to presales....