Data and Analytics Blog Posts

How to create an Aging Analysis report using a User selected Key Date leveraging SAC Date difference

Calculate Date difference between standard Date dimension and a user selected Key Date

From Numbers to Narrative: Building an AI Analytics Assistant in SAP Analytics Cloud

Planning reviews should focus on decisions, not data prep. This SAC custom widget uses one data binding to surface forecasts, variance drivers, AI insights, and ready-to-share outputs — helping finance teams move faster from numbers to action.

Adding a Decomposition Tree to SAP Analytics Cloud with D3.js

A practical walk-through of building a Power BI-style decomposition tree as an SAP Analytics Cloud custom widget. We will take it from a blank canvas to a smooth, data-bound, production-feeling visualization. This post is written for SAC analytics de...

Building a Production-Ready SAC Custom Widget with Claude AI — From Zero to Four Widgets

How I used Claude as an AI development partner to design and ship a full suite of Decomposition Tree story widgets for SAP Analytics Cloud 2026.8.0 — as a product manager with no coding background.

From Dashboards to Decisions: Extending SAP Analytics Cloud with Custom Widgets

SAC is already a powerful platform — and custom widgets are one of the many ways you can extend it to fit your specific business needs. Custom widgets are not a new feature in SAC. What is new is what becomes possible when you pair them with AI tools...

SAP BW Bridge or Data Product Generator (DPG): What would you choose

If you are shifting the BW system to Datasphere, this is a common confusion.In this Blog, I have explained the differences simply and practically so you can decide whether you want to migrate your BW system or explore your data for a modern approach.

Display a user selected input parameter value in a column header in SAC Live Reports

If you've ever tried to show a user-entered input parameter value in a SAC column header, you already know the problem — there's no standard way to do it. Here's a clean 4-step workaround that gets you there without overcomplicating things.

Why Solid Data Foundations Matter More Than Flashy AI

From all the conversations I have been having the past years since the release of ChatGPT, AI is totally underhyped and overhyped at the same time. From doomsday speculations to AI being useless, I have heard it all. We all have heard it all. But wha...

DI API – Unable to Map Project Stage ID in Sales Order

We have developed a add-on loading data into a Sales Order from Project screen. Most of the fields are loading correctly; however, we are facing issues while mapping the Stage field in the Sales Order → Details tab.

How to Implement KeyFigure based Validation Rules in SAP Analytics Cloud Planning Templates

Lot of times users have requirements when they want to restrict the value of a certain measure to allow users to only input certain values. Eg. You have a quantity measure and you want to restrict users from entering a negative value.

The consequences of implementing strictly Shift-left architectures

TL;DR:The Core Concept "Shift Left" moves the responsibility for data quality and governance from downstream analytics teams (the "cleanup crew") to the upstream source systems where data is created. Instead of fixing data later, it is treated as a h...

S/4HANA‐SAC連携時のODataリスト

はじめにこの記事は SAP Advent Calendar 2025 の12月6日分の記事として執筆しています。 SAP Analytics Cloud（以下SAC）導入時に困ることとの一つとして、S/4HANAのどのデータソース（OData）を使えばよいかということかと思います。SACのリリースからもう5年ほど経っていますが、なかなかどのODataを使うかということにフォーカスされた情報源がないということを薄々感じていました。もちろんContent Package User Guideは参...

C_PURCHASEORDERITEMDEX - Add the creation date field of the purchase order item

Request votes for an Influence idea

SAP analytics cloud - Convert a measure to text without coding

Sometimes you want to use a measure as text (Dimension) but without Application Designer coding. See how.

Extracting/Splitting Json String in SAP HANA using Table Function(SQL)

Json String extraction/splitting into columns and looping into same ID's.Since String Split function is not available in SAP Hana(2.3.78). A custom function is required to split the Json string.

SAP ASE Internals

Concise, deep-dive technical info for hard-core DBAs

Get Ready for SAP TechEd with Data and Analytics Learning Opportunities

SAP TechEd is right around the corner- the perfect time to strengthen your data and analytics skills. Explore learning paths designed to help you connect, model, and analyze data with confidence, and discover how to transform insight into real busin...

SAP Business Data Cloud - Create a custom Data Product based on a replication Flow

In this Blog, we'll demonstrate how to create a custom data product from a replication flow that can be delta-shared with SAP Databricks or BDC connect.There are few steps to follow:1- Create a SAP HANA Data Lake Files (HDLF) Space in Datasphere2- Cr...

Open Source - Apache Superset™ and SAP HANA Comes together to help you

https://superset.apache.org/ In today’s data-driven world, organizations need powerful tools to explore, visualize, and act on their data. Apache Superset™, an open-source data visualization platform, combined with SAP HANA, a high-performance in-mem...

Fixing the “More Members Available” Issue in SAP Analysis for Office based on Custom CDS Views

While working with SAP S/4HANA Embedded Analytics and SAP Analysis for Office (AFO), you may encounter the message: "More Members Available"This typically appears when filtering or selecting values in prompts, and it indicates that the number of avai...

Data Lineage – Do it Yourself with SAP HANA and SAC

Bring transparency to your data landscape with real-time, interactive data lineage in SAP.Using SAP Analytics Cloud (SAC) and existing SAP HANA metadata, this approach enables automated and intuitive data lineage visualizations—without extra tools or...

Enhancing Filter Visibility in SAP Analytics Cloud Numeric Pointer Charts

In scenarios where the Numeric Point chart is utilized within SAP Analytics Cloud, it is often unclear if any fixed filters were applied during the chart’s design phase. Typically, Stories incorporate Page-level or Story-level filters, which influenc...

New AWS option for SAP ODP data extraction

In November 2024, AWS updated its guidance for SAP Data Extraction with a Glue connector.This adds to the previous guidance using Amazon AppFlow service. But when to use what? lets dive in Amazon Appflow ApproachAppFlow is the AWS pre-configured in...

Unleash the Future of Business: Join SAP Business Unleashed on February 13, 2025

nlock the future of business at SAP Business Unleashed on February 13, 2025, where AI, data, and innovation converge to transform your organization.

Exporting comments in SAC stories based on live models

Commenting for BW live models was delivered for SAC as part of 2023 Q2 release. By using this feature users can add edit or modify comments on a data cell to a Table in SAC story in read mode

Knowledge Graphs - Datasphere vs HANA Cloud

SAP HANA Cloud graph allows for custom graph algorithm development and analysis, the SAP Datasphere knowledge graph is an automated capability that provides a rich context for generative AI use cases by capturing complex data relationships and metada...

Khan_Data-Unleashed_March-2024_Image-1-Knowledge_Graph_JOULE.jpg

What happens when a Data Flow fails?

You are using DSP as a Data Fabric to load multiple data sources, and all works great, and you can enjoy life (you know, teleworking from some heavenly place) ... until something goes wrong. You receive an email that a Data Flow has failed. That SFTP...

SAP Data Analyst Certification

Certificates won’t get you a job in data analytics.But you know what might?The real world skills you gain in the process of getting that certification.I fell into the trap of certification collecting earlier on in my data career, thinking the more th...

Why Don't We Use Data and Analytics Group on SAP Community?

Here is already available group called Data and Analytics Group

Sign up for the SAP Data & Analytics Newsletter!

Become part of the thriving community of SAP customers and partners who have already subscribed and get the scoop on the latest and greatest around SAP Data & Analytics.

Welcome to the Data & Analytics Community Group!

We are thrilled to have you join our community of data enthusiasts, analysts, and professionals. This group is meant to connect everyone who is passionate about all things data, and is dedicated to fostering discussions, sharing knowledge, and promot...