Manually tracing where one field came from took us an entire Friday afternoon. We had about a hundred Analytical Models left to go. Here’s the tool we built instead — and what it took to get it right.
Have you ever wondered how to allow users to add custom values to a dropdown list in an SAP Dynpro Screen beyond its predefined options?In this step-by-step guide, we'll explore a practical approach to making dropdown lists more dynamic and flexible ...
Dynamic Top-N waterfall requirements can become complex when rankings must respond to multiple filters, versions, periods, and reporting frequencies. This article shares a practical approach for moving filter-aware aggregation, variance calculation, ...
Learn how to create your first SAP Datasphere Data Product from scratch with this beginner-friendly end-to-end implementation guide.This article explains the complete lifecycle starting from Space creation, loading data into tables, building graphica...
Currency conversion is a common requirement in SAP reporting, analytics, pricing, and planning scenarios. Whether you are developing SQLScript Table Functions in SAP HANA XSA, building reusable data models in SAP HANA Cloud, or creating analytical mo...
Explore learning opportunities to strengthen your skills in data and analytics as you prepare for SAP TechEd 2026. Learn how to contextualize data for better decisions and transform insights into measurable business outcomes. Build your expertise wi...
The world of SAP Data & Analytics is undergoing major change: With SAP Business Data Cloud and its new AI capabilities, modernizing established reporting landscapes is becoming increasingly important. For many companies, this raises a crucial questio...
SAP Datasphere has no native "where-used" list for Replication Flows in Task Chains — unlike BW's DTP/InfoPackage lookup. Here's a script-based workaround that gets you an accurate answer in minutes, no coding required.
Centralizing business logic in SAP Datasphere can deliver significant value, especially for shared KPIs, common definitions, and logic that must be consumed consistently across multiple applications. However, not every calculation benefits from being...
Want to control Story Filters beyond the standard SAC UI? This blog provides a deep dive into Story Filter APIs, demonstrating how developers can leverage scripting to automate filtering, personalize stories, and enhance user interaction.
Learn how to integrate SAP Datasphere Task Chains with Automic Workload Automation (UC4) using REST APIs. This article walks through a production-proven approach for securely authenticating, executing, and monitoring Datasphere Task Chains while main...
Before an AI can predict anything, it needs the right data in front of it, and getting there is harder than it sounds. Part 2 walks through how 100 comparable projects are assembled and governed in SAP Datasphere, why the pipeline is built in Python ...
After my previous blog: SAP Business Data Cloud - Create a custom Data Product based on a replication Flow , I want to share how to create a custom Data Product from a dataset from a HANA space that can be shared via BDC Connect.
Two recent acquisitions—Dremio and Prior Labs—are more than just additions to the SAP roadmap; they signal a fundamental pivot in BDC architecture and capabilities. From the rise of "MLOps-free" predictive AI to the object store’s new role as the def...
Looking for a way to refresh a Power BI Report Server dashboard automatically after your SAP BW data load? This article demonstrates a simple and reliable solution using an SAP BW process chain, ABAP, and SQL Server.
Inactive DTPs are a common cause of SAP BW process chain failures, especially after development changes or transports. In this article, I introduce an ABAP utility that scans a process chain, including nested chains, and identifies inactive DTPs befo...
Long-range financial planning in SAP Analytics Cloud often stretches 2 to 5 years into the future, and planning master data doesn't always keep pace with that horizon. In this blog, I'll walk through how I solved this using SAC's scripting capabiliti...
En BW4HANA (Image 1), se generaba el "Error SQL en código "2,048": Véase el siguiente mensaje SQL (Nº mensaje: RSDHA014)" (Image 2).Para solucionarlo, ejecuté el programa RSDDB_LOGINDEX_CREATE (Image 3) para recrear los índices en el ADSO fuente. Lue...
Hi, I am a Business Intelligence Analyst with a genuine enthusiasm for making data accessible and useful. SAP Analytics Cloud has become one of my favourite tools, and I enjoy sharing what I learn as I go. This series covers lessons from real builds,...
Hi, I am a Business and Intelligence Analyst with a genuine enthusiasm for making data accessible and useful. SAP Analytics Cloud has become one of my favourite tools, and I enjoy sharing what I learn as I go. This series covers lessons from real bui...
Hi, I am a Business Intelligence Analyst with a passion for making data work harder for the people who rely on it. SAP Analytics Cloud is my primary platform, and this series captures the lessons I wish someone had told me earlier. Hierarchies are on...
Hi, I am a Business and Intelligence Analyst with a genuine enthusiasm for making data accessible and useful. SAP Analytics Cloud has become one of my favourite tools, and I enjoy sharing what I learn along the way. If something I write saves you an ...
Hi,I have 4 SAC tables created on SAC import models, and each table contains a fixed grid of 308 cells (14 columns × 22 rows). All of these cells will have numeric values populated either with 0 or higher.I would like to add 3 input text boxes:Minimu...
Building fully integrated forecasting workflows without a single unnecessary data copy is where SAP Business Data Cloud has a clear advantage.This blog shows exactly that: an end-to-end scenario in which a planner can trigger an AI-generated Ice Crea...
Custom widgets can now offer the same rich filtering experience as native SAC charts — Filter by Range for date dimensions, and Filter by Condition with operators like Contains, Starts With, and Between.
Overview:This blog demonstrates how to leverage SAP Business Data Catalog (BDC) in conjunction with Enterprise Databricks to create custom data products, extend them with advanced analytics and transformations, and synchronize the refined data back t...
Calculate Date difference between standard Date dimension and a user selected Key Date
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.
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...
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.
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...
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.
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.
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...
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.
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.
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...
はじめに この記事は SAP Advent Calendar 2025 の12月6日分の記事として執筆しています。 SAP Analytics Cloud（以下SAC）導入時に困ることとの一つとして、S/4HANAのどのデータソース（OData）を使えばよいかということかと思います。SACのリリースからもう5年ほど経っていますが、なかなかどのODataを使うかということにフォーカスされた情報源がないということを薄々感じていました。もちろんContent Package User Guideは参...
Request votes for an Influence idea
Sometimes you want to use a measure as text (Dimension) but without Application Designer coding. See how.
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.
Concise, deep-dive technical info for hard-core DBAs
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...
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...
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...
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...
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...
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...
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...
nlock the future of business at SAP Business Unleashed on February 13, 2025, where AI, data, and innovation converge to transform your organization.
| User | Count |
|---|---|
| 19 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| Subject | Likes |
|---|---|
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
