SAP ANALYTICS BLOG
Aktuelles, Best Practices & How-tos
Road2BDC – Our way to SAP Business Data Cloud with SAP Analytics Cloud and SAP Datasphere
Road2BDC – Our way to SAP Business Data Cloud with SAP Analytics Cloud and SAP Datasphere In this little blog post we want to share our way to go, what difficulties we came across and also our lessons learned. Where we started Our setup before was a SAP Analytics Cloud Tenant and also a SAP Datasphere Tenant. As the SAP Business Data Cloud is a…
HTTP/2: Der Performance-Boost für SAP Analytics Cloud Dashboards
HTTP/2: Der Performance-Boost für SAP Analytics Cloud Dashboards Bei langsamen Ladezeiten in SAP Analytics Cloud (SAC) liegt der Fokus meist auf Datenmodellen, Abfragen oder Story-Design. Ein oft unterschätzter Aspekt ist jedoch die Netzwerkschicht – insbesondere das verwendete HTTP-Protokoll. HTTP/2: Mehr als nur ein technisches Detail HTTP/2 ist die moderne Weiterentwicklung von HTTP/1.1 und wurde entwickelt, um typische Performance-Engpässe von Webanwendungen…
Data Visualization with FIORI and SAC – PART 2
Data Visualization with FIORI and SAC – Part 2 1. Introduction As stated in the previous Blog “Data Visualization with FIORI and SAC – Part 1”, we created a Fiori Overview Page based on S/4 data from a virtual CDS data model. In this one the analytical overview page will be re-created as SAP Analytics Cloud dashboard, as closely as possible, using the same source data model. Based on…
Data Visualization with FIORI and SAC – Part 1
Data Visualization with FIORI and SAC – Part 1 1. Introduction In the SAP landscape, there are very different platforms and ways to visualize data. In the first part of this series, we will create a Fiori Overview Page based on S/4 data from a virtual CDS data model. In the second one this analytical overview page will be recreated…
Bulgaria is Switching to the Euro – What this Means for SAP BW
Bulgaria is Switching to the Euro - What this Means for SAP BW Introduction Bulgaria will officially adopt the euro on January 1, 2026, a fixed conversion rate at 1 EUR = 1.9558 BGN will apply. That sounds simple, but in SAP BW it affects master data, key figures, currency translation logic, historical reporting, planning, and data loads from your ERP,…
Harnessing Reporting Potential, by Thinking outside of the Box – Part 1/3 SAC Jump & Run Blog series
Harnessing Reporting Potential, by Thinking outside of the Box - Part 1/3 SAC Jump & Run Blog series Solving Reporting needs in SAP Analytics Cloud by passing limitations with workaround After years of experience within the area of SAC reporting, I cannot count how often I heard colleagues, business partners, or customers complain about SAC limitations which eventually hinder the…
SAP Analytics Cloud Q4 2025 – New Features: Composites, Variance Scripting, new KPI Widget, Live Versions, Performance Stats.
SAP Analytics Cloud Q4 2025 - New Features: Composites, Variance Scripting, new KPI Widget, Live Versions, Performance Stats. With the new Q4 2025 release of SAP Analytics Cloud, the first impression changes noticeably due to the switch from the Belize theme to the Horizon theme as the new default appearance. In your personal settings, you can also enable high-contrast versions of both the light and…
End-to-end data model in Datasphere and SAP Analytics Cloud – How to leverage the Business Content
End-to-end data model in Datasphere and SAP Analytics Cloud - How to leverage the Business Content 1. Introduction The SAP Business Data Cloud (BDC) combines and governs several SAP products into one unified SaaS platform, see architecture overview: Source: SAP With ever-growing capabilities and toolsets, you might wonder how you can build data models for different analytical use cases more…
Dear Christkind: My SAP Datasphere (DSP) Wishlist
Dear Christkind: My SAP Datasphere Wishlist Christmas is just around the corner, and, like any hopeful kid, I have a wish list for Christmas Eve. Mine’s a little different, though—it’s about SAP Datasphere. After working with it across several projects, I’ve put together a set of features, enhancements, and clarifications I’d love to see. Datasphere has come a long way,…
The Future of Planning in Excel: The SAP Analytics Cloud Add-in as a Strategic Frontend – Part 2/3: Data Validation
The Future of Planning in Excel: The SAP Analytics Cloud Add-in as a Strategic Frontend - Part 2/3: Data Validation In the first part of this series, we introduced the SAP Analytics Cloud (SAC) add-in for Microsoft Office and positioned it as the strategic successor to Analysis for Office. We covered its modern architecture, seamless integration, and how to build…
BexWeb to SAC Data Analyzer: How to Execute, What to Know, and Why It’s a Strategic Opportunity
BexWeb to SAC Data Analyzer: How to Execute, What to Know, and Why It’s a Strategic Opportunity With SAP ending support for BexWeb Tools in 2030, companies and users are being “encouraged” to transition to more modern SAP solutions. For organizations that have relied on BexWeb for reporting, this presents a unique opportunity to elevate their reporting capabilities to the…
From REST to Datasphere: A CAP-based Integration Approach
From REST to Datasphere: A CAP-based Integration Approach We recently wrote a blog about how we integrate data from a REST service into SAP Datasphere. For that we deployed a small service on SAP BTP, which used the OPEN SQL schema and FastAPI to write this data directly into Datasphere. That service could also be triggered via REST endpoint from…
Playing Data Football: Understanding SAP Datasphere, SAP Analytics Cloud, SAP Business Data Cloud, and Databricks
Playing Data Football: Understanding SAP Datasphere, SAP Analytics Cloud, SAP Business Data Cloud, and Databricks When talking about modern data and analytics, the landscape can feel confusing—different players, overlapping roles, and everyone claiming to be the “star striker.” To make it easier, let’s think of the data world as a football team. Each solution has a position, a purpose, and…
Rückblick auf den DSAG Jahreskongress in Bremen – SAP Analytics im Fokus
Rückblick auf den DSAG Jahreskongress in Bremen - SAP Analytics im Fokus Der diesjährige DSAG Jahreskongress in Bremen stand ganz im Zeichen von Transformation, Innovation und Künstlicher Intelligenz. Für mich als SAP-Analytics-Berater war es besonders spannend zu beobachten, wie intensiv Themen rund um Datenstrategie, Business Intelligence und Planung diskutiert wurden. Highlights aus den Vorträgen Ein zentrales Thema war der Weg hin zu einer zukunftssicheren…
Master Data Management via Business Data Cloud: Datasphere & Seamless Planning in combination
Master Data Management via Business Data Cloud (BDC): Datasphere (DSP) & Seamless Planning in combination SAP Datasphere (DSP) and SAP Analytics Cloud (SAC) Seamless Planning will play an increasingly important role in the future. Since Seamless Planning is still a relatively young product, its current interaction capabilities with SAP Datasphere are limited. Nevertheless, this example demonstrates how master data from…
Report Navigation in SAC with RRI
Report Navigation in SAC with RRI SAP Analytics Cloud (SAC) helps users explore data easily. I recently had the chance to try out its support for SAP BW’s Report-to-Report Interface (RRI), officially available since the Q3 2024 release. With this feature, moving between related reports becomes much smoother. In SAP BW, RRI has been a solid feature for many years.…
Streamlining REST API Integrations in SAP Datasphere with Task Chains and FastAPI Microservices on SAP BTP
Streamlining REST API Integrations in SAP Datasphere with Task Chains and FastAPI Microservices on SAP BTP Introduction With the recent introduction of API Tasks in Task Chains, SAP Datasphere now supports direct orchestration of external REST services (see SAP documentation). This enhancement unlocks new integration possibilities, particularly for scenarios where no standard connectors are available. In our use case, we…
This Is the Way: Rethinking Analytics Orchestration with REST in SAP Datasphere
This Is the Way: Rethinking Analytics Orchestration with REST in SAP Datasphere (DSP) Introduction SAP Datasphere Task Chains have recently been enhanced with a new capability: the ability to add a REST API Step, as documented by SAP. This addition significantly expands the integration potential of Task Chains, allowing them to trigger or interact with external systems via REST APIs—something previously…
Breaking New Ground: NCUM Data Modeling in SAP Datasphere vs. BW/4HANA – Part 3: NCUM in SAP Datasphere (DSP)
Breaking New Ground: NCUM Data Modeling in SAP Datasphere (DSP) vs. BW/4HANA - Part 3: NCUM in SAP Datasphere (DSP) In Part 2, we explored how SAP BW/4HANA handles non-cumulative (NCUM) key figures through inventory-enabled aDSOs, leveraging built-in features like record types, time references, and automated delta handling to calculate accurate stock levels. The system processes movements through inbound, active,…
AfO vs. AfO for SAP Analytics Cloud (SAC): Similarities, Differences, and Which One to Choose
AfO vs. AfO for SAP Analytics Cloud (SAC): Similarities, Differences, and Which One to Choose With Analysis for Office for SAC, an exciting new possibility opens up: accessing data from the SAP Analytics Cloud directly in Excel and working with it flexibly. But where exactly are the differences compared to the well-established and similarly named Analysis for Office? And, most…
SAC – Export native planning to SAP S/4HANA ACDOCP
SAP Analytics Cloud (SAC) - Export native planning to SAP S/4HANA ACDOCP Introduction SAC native planning works best when its planning capabilities are integrated with backend systems like SAP S/4HANA, particularly the ACDOCP table, which serves as the central storage for ERP plan data. In this blog, I will show how to export native planning data from SAC to SAP…
The Future of Planning in Excel: The SAP Analytics Cloud Add-in as a Strategic Frontend – Part 1/3: Introduction
The Future of Planning in Excel: The SAP Analytics Cloud Add-in as a Strategic Frontend - Part 1: Introduction For many business users in finance and controlling, Microsoft Excel is more than just software — it's the daily tool for analysis, reporting, and, above all, corporate planning. Its flexibility and familiar environment are unbeatable. But how do you combine this…
SAP BW und Business Data Cloud: Jetzt umsteigen oder noch warten?
SAP BW und Business Data Cloud: Jetzt umsteigen oder noch warten? In der sich schnell entwickelnden Welt von SAP Analytics stehen viele SAP BW Kunden vor einer entscheidenden Frage: Jetzt auf die SAP Business Data Cloud (BDC) setzen oder noch bei bestehenden BW-Lösungen bleiben? Die Antwort darauf ist komplex – sie hängt stark vom derzeitigen Setup, der strategischen Zielsetzung und…
Planning Modernization – Reflections on BW Modernization and Its Implications for Planning in the CloudPlanning Modernization
Reflections on BW Modernization and Its Implications for Planning in the Cloud Since the announcement of the Business Data Cloud (BDC) a few months ago, I’ve followed numerous discussions surrounding the topic of BW Modernization with great interest. Given my background in planning applications and analytics architecture, these conversations have sparked several ideas about how the principles of BW Modernization…
Breaking New Ground: NCUM Data Modeling in SAP Datasphere vs. BW/4HANA – Part 2: NCUM in SAP BW/4HANA
Breaking New Ground: NCUM Data Modeling in SAP Datasphere vs. BW/4HANA - Part 2: NCUM in SAP BW/4HANA In Part 1, we introduced the basics of inventory reporting with Non-Cumulative (NCUM) Key Figures and highlighted how record types help ensure accurate time-based aggregation. In Part 2, we focus on SAP BW/4HANA, exploring the technical setup for NCUM reporting. Using a…
Start unserer Testversion für SAP Business Data Cloud (BDC)
Start unserer Testversion für SAP Business Data Cloud (BDC) Die SAP Business Data Cloud (BDC) bietet viele neue Möglichkeiten – und wir möchten genau verstehen, wie sie im konkreten Einsatz funktioniert und einen Mehrwert für unsere Kunden bringen kann. Unser Fokus: Wie schaffen unsere Kunden damit mehr Transparenz, Effizienz und Entscheidungsstärke? Wir analysieren, bewerten und bereiten vor – damit wir…
Breaking New Ground: NCUM Data Modeling in SAP Datasphere vs. BW/4HANA – Part 1: Record Types
Breaking New Ground: NCUM Data Modeling in SAP Datasphere vs. BW/4HANA - Part 1: Record Types Stock and inventory data present unique challenges for reporting because they don’t aggregate over time like traditional transactional data. For example, summing up stock levels across multiple periods doesn’t yield meaningful insights since stock values depend on both historical reference points and subsequent changes.…
Not so Seamless S/4HANA Data Integration: How to Configure Replication Flows with Datasphere Using Cloud Connector
Not so Seamless S/4HANA Data Integration: How to Configure Replication Flows with Datasphere Using Cloud Connector Or: When Family has trouble talking to each other We've all been to those family gatherings where certain relatives just won't talk to each other without a mediator (or misunderstanding each other constantly). Setting up replication flows from SAP S/4HANA to Datasphere via Cloud Connector feels remarkably similar – it's about getting two…
From TikTok to Data Talk: Why SAP SAC Just Got a Whole Lot Cooler
From TikTok to Data Talk: Why SAP SAC Just Got a Whole Lot Cooler Let’s be honest — attention spans today are shorter than loading spinner on a slow dashboard. We are living in a world where a 15-second TikTok can teach you how to cook risotto, fix your Wi-Fi, and survive a bear attack. Meanwhile, your classic 75-slide data presentation? Snooze…
Planning the future with SAP Analytics Cloud (SAC) – How and Why
Planning the future with SAP Analytics Cloud (SAC) – How and Why While my colleague Andreas already wrote a blog post about SAC Planning with BPC Live connection, this blog covers the part of Planning with SAC Native Planning and can help you decide when this type of application could be suitable for your needs. SAP Analytics Cloud (SAC) has…
How to – Incrementing Versioning/Scenarios (in planning solutions using SAP BW)
How to - incrementing Versioning/Scenarios (in planning solutions using SAP BW) Versioning concept In many of my BW/SAC Planning projects, there are requirements for a versioning and scenario concept. Since there are several good ways to implement the Actual/Budget/Forecast and Time Component, there is often the requirement for an incrementing dimension. It can be called versions, scenario or “cases”. However,…
How to – Custom Status management in SAP BW / SAP SAC with aDSOs (using BW-IP / BPC)
How to - Custom Status management in SAP BW / SAP SAC with aDSOs (using BW-IP / BPC) Status Management - Introduction In BW there is often the need to track the status of a process. This can be a planning process or a regular data load/working process. In this Blog, I will show how a custom status aDSO for…
Comprehensive Overview: SCIM API for SAP Datasphere User Management
Comprehensive Overview: SCIM API for SAP Datasphere User Management Introduction In Q3 2024, SAP introduced the SCIM (System for Cross-domain Identity Management) API for SAP Datasphere to enhance user management through a consistent, REST-based protocol. This API currently supports the following operations: CRUD (Create, Read, Update, Delete) operations for users Assign users to existing roles (Note: Creating new roles via…
Road to Seamless Planning :: SAC Migration :: 4 :: Move and Test
Road to Seamless Planning :: SAC Migration :: 4 :: Move and Test Introduction After three weeks of migration, we now enter the final phase—moving content to the new SAP Analytics Cloud (SAC) tenant. We decided to use 5.3.8 (Content Network) to move our content, skipping 5.3.5 (Export Content) and 5.3.6 (Import Content), to save time and not facing limitations…
Generating and Importing Synthetic Sales Data Using ChatGPT, Python and Excel: A Step-by-Step Guide
Generating and Importing Synthetic Sales Data Using ChatGPT, Python and Excel - A Step-by-Step Guide In today’s data-driven landscape, access to high-quality, varied, and seasonality-aware datasets is crucial for training forecasting models, performing data analysis, and conducting simulations. However, real-world data is often incomplete, unavailable, or limited in scope. This is where generating synthetic data, tailored to specific reporting or…
Virtual Characteristics and Key Figures in BW/4HANA
Virtual Characteristics and Key Figures in BW/4HANA 1. Virtual Characteristics and Key Figures in BW/4HANA This blog covers the usage of virtual key figures and characteristics in BW/4HANA (BW4) utilizing the BAdI RSROA_OLAP_BADI. Virtual key figures and characteristics are InfoObjects that exist in the Composite Provider, but their values are not read from the included InfoProvider; instead, they are determined…
Road to Seamless Planning :: SAC Migration :: 3 :: Migration of content from the source tenant to the new tenant
Road to Seamless Planning :: SAC Migration :: 3 :: Migration of content from the source tenant to the new tenant Introduction Following our journey toward seamless planning, we now focus on the migration process itself. This chapter covers the key steps required to transfer content from the source tenant to the new tenant efficiently. 5.3.4 Migration of content from…
SAP Business Data Cloud (BDC)
SAP Business Data Cloud SAP hat soeben ihr neuestes Produkt, die SAP Business Data Cloud (BDC) vorgestellt. Mit der Einführung der SAP Business Data Cloud (BDC) vereinen sich SAP Datasphere (DSP), SAP Analytics Cloud (SAC) und SAP Business Warehouse (BW) zu einer leistungsstarken Plattform. Eine bahnbrechende Neuerung ist die Integration generativer KI, die die SAP Data & Analytics-Welt revolutioniert. Durch…
Road to Seamless Planning :: SAC Migration :: 2 :: Setup security settings
Road to Seamless Planning :: SAC Migration :: 2 :: Setup security settings Introduction As we move forward on our Road to Seamless Planning (https://www.zpartner.eu/road-to-seamless-planning-sac-migration-1-0-setup/), the next critical step in our SAP Analytics Cloud (SAC) migration is setting up security in the new tenant. Security configurations ensure the right users and roles are assigned, access is controlled, and Single Sign-On…
Road to Seamless Planning :: SAC Migration :: 1.0 :: Setup
Road to Seamless Planning :: SAC Migration :: 1.0 :: Setup Introduction As described in the Blog “Minimum Viable Product with Seamless Planning” (https://www.zpartner.eu/minimum-viable-product-with-seamless-planning/) a prerequisite for Seamless Planning is that the SAC tenant is running on HANA Cloud. Currently, our tenant is not hosted on HANA Cloud, making migration the first necessary step toward achieving Seamless Planning. You can…
Minimum Viable Product with Seamless Planning
Minimum Viable Product with Seamless Planning Introduction Seamless Planning was launched as a controlled release in Q4 2024. In this blog, we will develop a minimum viable product and share insights into how Seamless Planning could influence your SAP IT architecture. Distinction SAC Native Planning and Seamless Planning Many of you have likely worked with SAP Analytics Cloud (SAC), a…
Mastering Custom Integrations in SAP Datasphere: Leveraging Open Connectors for REST APIs
Mastering Custom Integrations in SAP Datasphere: Leveraging Open Connectors for REST APIs Introduction SAP Datasphere offers a wide range of pre-defined source system connectors. However, there may be instances where a standard connector is unavailable, such as with certain REST APIs. To address this, SAP provides the option to leverage Open Connectors. This blog outlines the process, including: Setting up…
A Practical Example of Remote Authorizations in SAP Datasphere
A Practical Example of Remote Authorizations in SAP Datasphere Introduction If you have a BW system and are interested in reusing your SAP BW Analysis Authorizations in SAP Datasphere, this blog is for you. The SAP documentation on this topic is extensive, so this blog aims to provide a practical implementation example along with our recommendations. The Analysis Authorizations from…
SAP Analytics Cloud (SAC) – Dynamic Time Navigation
SAP Analytics Cloud (SAC) - Dynamic Time Navigation Overview This document is a step by step guide on how to work with Dynamic Time Navigation Functions. At the model level, Modellers and Planners can now utilize a new formula called ToPeriod, which calculates a running total over flexible time granularities for a specified period. Additionally, it is now feasible to…
SAP Analytic Cloud (SAC) Story on SAP Datasphere (DSP)
SAP Analytic Cloud (SAC) Story on SAP Datasphere (DSP) 1. General SAP Analytics Cloud (SAC) is a powerful frontend tool and offers multiple options to collaborate between users. Data for SAC Stories are coming from different data sources. Either from BW live connections, Native Models, S3 buckets and many more as well as SAP Datasphere. SAP DSP is for data storage,…
Performance Monitoring in a SAP Analytics Cloud (SAC) Story
Performance Monitoring in a SAC Story 1 Introduction In SAP Analytics Cloud (SAC) it is now possible to analyse the performance from inside the story. This short blog gives an overview of how to use the new Performance Optimization tool. 2 How To: Performance Optimization Tool If the user experiences any performance issues with a story, use SAP built-in quick…
Fiori Development – Table maintenance with SAPUI5 application
Fiori Development – Table maintenance with SAPUI5 application 1. Introduction As a contrast to the last blog where we utilized Fiori Elements for an app creation, I would like to demonstrate in this one, how to create a freestyle SAPUI5 app for the maintenance of a custom parameter table, located in the backend system. The topic stems from the idea…
How To: SAP Analytics Cloud (SAC) Presentation Mode
How To: SAP Analytics Cloud (SAC) Presentation Mode General The Presentation mode is to display story content as a presentation. This feature replaces the Digital Boardroom. The Digital Boardroom is not available for Optimized Design Experience based stories anymore. This blog shows how to set-up a presentation in SAP Analytics Cloud (SAC) and the functions within the presentation mode. How…
Fiori Development – Creation of List Reports using Fiori Elements
Fiori Development - Creation of List Reports using Fiori Elements 1. Introduction In our previous blog, we demonstrated the creation of a simple 'Hello World' application and deployed it on an S4 on-premise system. Building on this post, this blog will introduce Fiori Elements and guide you through the creation of a List Report including an Object Page, showing further…
Transfer RSTT Traces between systems with RSDATA
Transfer RSTT Traces between systems with RSDATA SAP RSTT (Recording System Trace Tool) is important for performance analysis in SAP BW systems. However, RSTT traces, CATT traces, and associated job data cannot be transported directly between systems, presenting challenges in multi-system landscapes. RSDATA provides an effective solution, enabling trace transfers across environments. This guide details a step-by-step process for transferring…
Generate Combinations Function in SAP Analytics Cloud (SAC) Planning
Generate Combinations Function in SAC Planning In customer projects input queries are often restricted to only posted values to ensure optimal performance for the end-users. As business requirements are usually quite similar from year to year, this supports the end-user to easily plan their values in a well-arranged input form without thinking about validity of shown combinations. However, sometimes new…
A practical example of the three different types of Data Access Controls (DACs) in Datasphere
A practical example of the three different types of Data Access Controls (DACs) in Datasphere Introduction The SAP documentation on the topic is quite extensive, so our aim today is to give you an example of how the actual implementation looks and to provide our recommendations. Protecting your data with Data Access Controls In SAP Datasphere, you can protect your…
Automating SAP Datasphere Task Chains with CLI Wrapping: FastAPI Integration with SAP Analytics Cloud
Automating SAP Datasphere Task Chains with CLI Wrapping: FastAPI Integration with SAP Analytics Cloud Introduction When working with SAP Datasphere, triggering task chains is often a crucial part of automating data processes. SAP Datasphere provides the ability to start task chains using CLI (Command Line Interface) commands, which offer a powerful way to control these operations. However, one challenge we…
FIORI Development – Creation and deployment of a „Hello World“ App
FIORI Development - Creation and deployment of a "Hello World" App Introduction In our previous Blog - FIORI development – Connect BAS to On-Premise System - we established the connection between the SAP Business Technology Platform (BTP) and the On-Premise system. In this part, we will guide you through the process of creating and deploying a simple Fiori 'Hello World'…
FIORI Development – Connect BAS to On-Premise System
FIORI Development – Connect BAS to On-Premise System 1. Introduction In the upcoming blog series, we will focus on Fiori application development, starting with the first part where we will establish the prerequisites for it. We'll walk through the process of setting up a connection between the SAP Business Technology Platform, which includes the needed development environment, the BAS (Business…
SAP Datasphere – How to integrate Open SQL Procedures in a Task Chain
SAP Datasphere – How to integrate Open SQL Procedures in a Task Chain Introduction Within SAP Datasphere a task chain is a structured sequence of tasks or operations designed to be executed in a specific order or concurrently. It automates the process of running multiple related tasks, ensuring that they are executed in a predefined sequence or parallel, depending on…
SAP Analytics Cloud – „Search to Insight“ vs. „Just Ask“
SAP Analytics Cloud - "Search to Insight" vs. "Just Ask" SAP Analytics Cloud offers two options - "Search to Insight" and "Just Ask" - which are often seen as kind of AI. In the following Blog we will give a spotlight on this two options to find out what is really behind. We compare these SAC features and show how…
A Story of Reusability: Leveraging SAP Analytics Cloud Composites
A Story of Reusability: Leveraging SAP Analytics Cloud Composites Imagine you are building various reports, each with its own unique requirements, but still needing to maintain a cohesive look and feel. Most likely the header is standardized and keeps stable. Enter the hero of our story: SAP Analytics Cloud CompositesComposite header. The Power of a Composite Composites in SAP Analytics…
CDC data extraction Lessons Learned, Tips & Tricks – Part 4
CDC data extraction Lessons Learned, Tips & Tricks – Part 4 Introduction This blog series is about warnings and error messages that you may encounter with using CDC delta, even though pretty good documentation, and how to work around them. We share these experiences with you to save your valuable time. In Part 1 of the series we looked at a…
Future proof your SAP planning: BPC / IP transformation to SAC Planning with Live Connection – How and Why
Future proof your SAP planning: BPC / IP transformation to SAC Planning with Live Connection - How and Why Why change to SAC Planning with BPC live connection? Since more and more customers use SAC for reporting, planning applications are often left behind. But if SAC is in use anyway, there are several reasons to change from BW-IP or BPC…
Publishing in SAP ANALYTICS CLOUD as a replacement for SAP BO with APOS Publisher for Cloud
Publishing in SAP ANALYTICS CLOUD as a replacement for SAP BO with APOS Publisher for Cloud The distribution of analytic insights remains a crucial topic and a valid use case in analytics. Many customers are struggling with distribution in SAP ANALYTICS CLOUD as a replacement for SAP BO. Therefore, we embarked on our journey to solve this problem and discovered…
abapGit – Elevate Your SAP ABAP Development Game
abapGit - Elevate Your SAP ABAP Development Game Introduction Managing code within the SAP ecosystem can be quite complex. The introduction of abapGit brings new ways to how version control and collaboration in ABAP development may be handled. This blog aims to provide an overview of abapGit, its features and use cases within SAP development. By understanding and leveraging abapGit,…
ZPARTNER @ DSAG AG Business Analytics Treffen – Österreich
ZPARTNER @ DSAG AG Business Analytics Treffen - Österreich Beim gestrigen Präsenztreffen der Business Analytics Gruppe in Wien gab SAP uns die Gelegenheit einen ersten Einblick zum aktuellen Entwicklungsstand der Integration von SAP Datasphere (DSP) und SAP Analytics Cloud (SAC), im Bereich Planung, zu erhalten. Die Demo zeigte uns "die Richtung stimmt" :-). Ein weiterer, sehr spannender, Vortrag beschäftigte sich…
SAC Scripting- Part 2: Shadow Tables
SAC Scripting - Part 2: Shadow Tables 1. General In this detailed exploration, we contrast the efficiency of accessing dimension values through Input Control and a shadow table in scripting environments. We previously introduced array manipulation and now extend our focus to performance aspects of data retrieval. The shadow table, designed as a dedicated storage for dimension values, allows for hidden…
„Replace Model“ Feature in SAP Analytics Cloud with SAP BW Live Model
"Replace Model" Feature in SAP Analytics Cloud with SAP BW Live Model In the rapidly evolving world of data analytics, the agility to update and modify data sources directly within ongoing projects is crucial. SAP Analytics Cloud (SAC) offers a powerful feature known as "Replace Model," which allows users to swap out the underlying data model in a story without…
How to authorize for BPC Planning in SAC
How to authorize for BPC Planning in SAC 1. General When you want to plan with BPC Planning in SAC to BW, the authorization is set-up in three parts: 1. BPC Roles and authorizations 2. BPC Web Client (Data Access Profiles) 3. SAC set-up for planning and update access In the following document, the best practice set-up for planning with…
SAC Scripting – Part 1: Array Handling
SAC Scripting - Part 1: Array Handling 1 General In the ever-evolving landscape of business intelligence, SAP Analytics Cloud (SAC) stands out as a robust tool empowering organizations to make informed decisions through intuitive analytics and compelling visualizations. While SAC offers a user-friendly interface for building dashboards, there are instances where scripting become crucial to meet specific business needs. In…
Data Flows – The Python Script Operator and why you should avoid it
Data Flows - The Python Script Operator and why you should avoid it When using SAP Datasphere to transform data for persistence, the Data Flow provides the necessary functionality. We recently compared various basic transformation tasks using different modeling approaches. Therefore, we tried four different approaches to implement a certain logic: 1. Modelling with the Standard Operators in the Data…
ZPARTNER @ DSAG TT 2024
ZPARTNER @ DSAG TT 2024 Wir waren auch dieses Jahr wieder bei den DSAG-Technologietagen vertreten. Besonders hat uns natürlich die SAP Analytics Agenda interessiert. Aber auch Hamburg hat, abgesehen vom Wetter 😉 , viel zu bieten. Was nehmen wir also mit? Künstliche Intelligenz Beeindruckend waren die praktischen Anwendungsfälle zur Künstlichen Intelligenz. In den Vorträgen wurde schnell klar, dass sich das…
Planning Architecture with and without SAP Business Warehouse (BW)
Planning Architecture with and without SAP Business Warehouse (BW) Introduction Several customers are currently reconsidering their planning architectures. If you are one of those, this blog might be interesting for you. Let’s start with some building blocks you will find in almost every planning application: Frontend Data Modelling Extraction/Retraction In case a Business Warehouse is already established for reporting purposes,…
CDC data extraction Lessons Learned, Tips & Tricks – Part 3
CDC data extraction Lessons Learned, Tips & Tricks – Part 3 Introduction This blog series is about warnings and error messages that you may encounter with using CDC delta even though pretty good documentation, and how to work around them. We share these experiences with you to save your valuable time. In Part 1 of this series we looked at a…
CDC data extraction Lessons Learned, Tips & Tricks – Part 2
CDC data extraction Lessons Learned, Tips & Tricks – Part 2 Introduction This blog series is about warnings and error messages that you may encounter with using CDC delta even though pretty good documentation, and how to work around them. In part 1 of the series we looked at a warning you might run into when using automatic CDC. This…
CDC data extraction Lessons Learned, Tips & Tricks – Part 1
CDC data extraction Lessons Learned, Tips & Tricks - Part 1 Introduction Change Data Capture (CDC) delta extraction is actually quite simple, and there are already some good blogs out there explaining it pretty good. However, in practical project work with our customers, we have come across one or the other warning or error message that was not immediately self-explanatory.…
Goodbye CDS View, Hello CDS View Entity – Part 2
Goodbye CDS View, Hello CDS View Entity - Part 2 This article is the second part of a blog series. It focuses on optimizations and new features. The previous part one explained the differences of the CDS View Entity compared to the legacy CDS View. 1. Optimizations And Simplifications 1.1. Input Parameter Handling For a legacy CDS View which uses…
Goodbye CDS View, Hello CDS View Entity – Part 1
Goodbye CDS View, Hello CDS View Entity - Part 1 This article is the first part of a blog series. It explains the differences of the CDS View Entity compared to the legacy CDS View. Part two will focus on optimizations and new features. 1. Introduction The CDS view has been deprecated by SAP. It is still supported but will…
BW/4HANA: Plädoyer für die InPlace Konvertierung
BW/4HANA: Plädoyer für die InPlace Konvertierung Situation Die Uhr tickt. Die Wartung für 7.5 BW-Systeme (BW7x) endet im Jahr 2027 bzw. 2030. Es wird zunehmend dringlich, für jedes BW-System eine klare Zukunftsstrategie zu entwickeln. Die Zeit des Zögerns ist aus meiner Sicht vorbei, da SAP mittlerweile Klarheit darüber geschaffen hat, wie es mit BW/4HANA (BW4) weitergeht. Falls Sie bislang noch…
CDC Delta Series – Part 1: Loading behavior (Header vs. Joined Item)
CDC Delta Series – Part 1: Loading behavior (Header vs. Joined Item) Introduction This blog series will contain detailed topics with CDC Delta within a CDS-View. Part 1 will give you some information about the delta loading behavior between a header table versus an item table joined with the header table. Scenario CDS Views To understand the loading behavior, it…
Hierarchies in Core Data Services for ABAP Part 2: CDS hierarchies
Hierarchies in Core Data Services for ABAP Part 2: CDS hierarchies Introduction In our last blog post on hierarchies in ABAP CDS views, we covered annotation-based hierarchies. In this blog we will cover another way on how to implement hierarchies in ABAP CDS views, by using the hierarchy keyword. This feature was introduced with SAP S/4HANA 1809 and it enables…
Embedded Analytics with SAP Fiori – How to create analytical web dynpro apps and assign them by role based authorizations
Embedded Analytics with SAP Fiori - How to create analytical web dynpro apps and assign them by role based authorizations Introduction and Objectives In previous blogs we described the CDS data model and how ABAP CDS views are created and used for different purposes, whereby Analysis for Office was mainly used as reporting frontend. In this blog we will make…
How to survive with SAP GUI for support tasks under BW/4HANA
How to survive with SAP GUI for support tasks under BW/4HANA Intro Coming from SAP BW 7.50 to BW/4HANA you will recognize that some transactions are no longer accessible in SAP GUI and shifted as good as possible to Eclipse. User Interface to handle tasks especially within the support area are shifted too. Tasks like checking data (Query, ADSO, HCPR…),…
How to enhance comments on BW/BPC live Connections in SAP Analytics Cloud with full name of the owner
How to enhance comments on BW/BPC live Connections in SAP Analytics Cloud with full name of the owner Introduction A very nice feature of commenting on BW/BPC live Connections in SAP Analytics Cloud was described by the blog of Gerd Schoeffl (https://blogs.sap.com/2023/04/27/comments-on-bw-bpc-live-connections-in-sap-analytics-cloud/ ). This feature is amazing, especially in the context of analytics. In my opinion one missing part of…
Lifecycle Management in SAC – Transporting in SAC: Multi-Tenant Landscape
Lifecycle Management in SAC - Transporting in SAC: Multi-Tenant Landscape 1 General SAP Analytics Cloud is a powerful frontend and offers multiple options to share stories with consumers. When consumption is growing it is also very important that new developments are deployed smoothly for end users especially in a landscape with multiple tenants The following paper takes a deeper look…
Lifecycle Management in SAC – Content Network Storage: Multi-Content Network
Lifecycle Management in SAC - Content Network Storage: Multi-Content Network 1 General SAP Analytics Cloud is a powerful frontend tool and offers multiple options to share stories with consumers. When consumption is growing it is also very important that new developments are deployed smoothly for end users. Especially in a landscape with a tenant for development, testing and production, content…
Lifecycle Management in SAC – Content Network Storage: Single-Tenant Landscape
Lifecycle Management in SAC - Content Network Storage: Single-Tenant Landscape General SAP Analytics Cloud is a powerful frontend and offers multiple options to share stories with consumers. When consumption is growing it is also very important that new developments are deployed smoothly for end users. Especially in a landscape with one tenant, acting as development system, quality system and productive…
SAC Change Models in Stories
SAC Change Models in Stories General SAP Analytics Cloud is a powerful frontend tool and offers multiple options to create stories for various consumers for the available data. Stories/Dashboards are built on models. In some cases, it can be necessary to exchange a model in a story with a new one. For example: if the story was based on a…
Lifecycle Management in SAC: Transporting – Single -Tenant Landscape
Lifecycle Management in SAC - Transporting : Single-Tenant Landscape 1 General SAP Analytics Cloud is a powerful frontend and offers multiple options to share stories with consumers. When consumption is growing it is also very important that new developments are deployed smoothly for end users. Especially in a landscape with one tenant, acting as development system, quality system and productive system…
DATA FLOWS IN SAP DATASPHERE (DSP) – Part 4: Using Dataspheres HANA Cloud Instance with Table Functions and how to integrate them seamlessly
DATA FLOWS IN SAP DATASPHERE (DSP) - Part 4: Using Dataspheres HANA Cloud Instance with Table Functions and how to integrate them seamlessly Introduction In the final part of this series, we want show how to use the HANA cloud instance and its functionalities and consume them within SAP Datasphere and Data Flows. Therefore, we want to show how…
STEPZ @ ZPARTNER with Google Fit Integration
STEPZ @ ZPARTNER with Google Fit Integration Introduction If you follow ZPARTNER, you might have noticed that we have built a SAC Native Application for a Fitness Challenge (https://www.zpartner.eu/stepz-2023-zpartner/) for the company employees. As we still do this challenge on a regular basis, we recently enhanced this by integrating Google Fit data into it. The idea was to synchronize your…
STEPZ 2023 @ ZPARTNER
STEPZ 2023 @ ZPARTNER Der Countdown läuft - endlich ist es wieder soweit! Unsere STEPZ Challenge 2023 startet am 1.5.! Worum geht’s? Wir tun etwas für unsere Gesundheit und zeigen gleichzeitig wie SAP Frontend Tools funktionieren. In diesem Fall haben wir mit STEPZ eine SAC native Planungsanwendung in einer Analytic Application gebaut, mit der es uns möglich ist, Schritte und Aktivitäten zu…
Ausnahmeaggregation mit ABAP CDS-Views (Querydesign Teil 3)
Ausnahmeaggregation mit ABAP CDS-Views (Querydesign Teil 3) Einleitung Im Blog „Kennzahlen und Textvariablen in ABAP CDS“, wurde gezeigt wie eingeschränkte bzw. berechnete Kennzahlen in CDS-Views erstellt werden und man die aus dem BW bekannten Textvariablen zum Teil ersetzen kann. Aufbauend auf die Query aus dem letzten Blog, möchten wir in einem sehr kurzen Beitrag auf Ausnahmeaggregationen in CDS-Views eingehen. Durchschnitt…
SAP Analytics Cloud (SAC) Story 2.0 Authorization
SAP Analytics Cloud (SAC) Story 2.0 Authorization 1 General SAP Analytics Cloud is a powerful frontend application and offers multiple options to share enterprise data with employees, management information consumers. With the new wave update 2023.3, Story 2.0 is available for everyone to use. Story 2.0 is the union between Story and Analytic Application for creating an Optimized Story Experience.…
DATA FLOWS IN SAP DATASPHERE (DSP) – Part 3: Using SQL Table Functions and incorporate them into your Data Flow
DATA FLOWS IN SAP DATASPHERE (DSP) - Part 3: Using SQL Table Functions and incorporate them into your Data Flow Disclaimer SAP recently announced the launch of SAP Datasphere, which is the next generation of SAP Data Warehouse Cloud. Therefore, also the name from SAP Data Warehouse Cloud changed to SAP Datasphere. This blog, which was posted ahead of this…
How to use SAP UI5 Icons in SAC-Stories and SAC-Applications
HOW TO - Use SAP UI5 Icons in SAC-Stories and SAC-Applications Challenge Icons are immensely helpful when designing SAP Analytic Cloud Stories and/or Applications. It helps to give a consistent view on navigation elements. There are multiple ways of creating Icons for instance via uploading of images. This blog gives a “best practice” of having a consistent look and feel using the same…
DATA FLOWS IN SAP DATASPHERE (DSP) – Part 2: Comparing Performance – The Script Operator Performance vs. SQL View Functions in Data Flows
DATA FLOWS IN SAP DATASPHERE (DSP) – Part 2: Comparing Performance - The Script Operator Performance vs. SQL View Functions in Data Flows Disclaimer SAP recently announced the launch of SAP Datasphere, which is the next generation of SAP Data Warehouse Cloud. Therefore, also the name from SAP Data Warehouse Cloud changed to SAP Datasphere. This blog, which was posted…
DATA FLOWS IN SAP DATASPHERE (DSP) – Part1: Introduction
DATA FLOWS IN SAP DATASPHERE (DWC) - Part1: Introduction Disclaimer SAP recently announced the launch of SAP Datasphere, which is the next generation of SAP Data Warehouse Cloud. Therefore, also the name from SAP Data Warehouse Cloud changed to SAP Datasphere. This blog, which was posted ahead of this change, refers to SAP Data Warehouse Cloud. Everything which is mentioned…
How Business Warehouse can help you in IBP Projects
How Business Warehouse can help you in IBP Projects Introduction and Motivation Currently, there are different projects related to Integrated Business Planning ongoing. One motivation could be to have a successor for APO (Advanced Planning and Optimization). In case your system landscape contains a Business Warehouse system, you might be interested on how to utilize it in your IBP Projects.…
Data Modeling with CDS Views – Part 3: Session Information, Case, Cast, Where, Input Parameter & Consumption filter
Data Modeling with CDS Views – Part 3: Session Information, Case, Cast, Where, Input Parameter & Consumption filter Introduction This blog series will contain the basics of data modeling with CDS Views. The Part 1 will give you some information about the Syntax of a CDS view, Joins, Associations and Unions. You can find this blog here Data Modeling with…
Data Modeling with CDS Views – Part 2: Currency/Unit Conversion & Date Functions
Data Modeling with CDS Views – Part 2: Currency/Unit Conversion & Date Functions Introduction This blog series is about the basics of data modeling with CDS Views. Part 1 gave you an overview about the Syntax of a CDS view, Joins, Associations and Unions. Part 2 will give you a short overwiew about Currency/Unit Conversion and Date Functions. Currency/Unit Conversion…
Data Modeling with CDS Views – Part 1: Basics
Data Modeling with CDS Views – Part 1: Basics Introduction This blog series contains the basics of data modeling with CDS Views. The first Part will provide some information about the Syntax of CDS views, Joins, Associations and Unions. CDS Syntax Just to give a very brief overview of the syntax of CDS, here I listed some basic rules: Names…
Kennzahlen und Textvariablen mit ABAP CDS-Views – Query Design Teil 2
Kennzahlen und Textvariablen mit ABAP CDS-Views - Query Design Teil 2 Einleitung Im Blog „dynamische Variablenableitung mit ABAP CDS" wurde erklärt wie Parameter dynamisch befüllt und auf einen Queryfilter angewendet werden können. Auf dem selben Datenmodell aufbauend, zeigen wir im aktuellen Blog wie Parameterwerte für die Einschränkung von Kennzahlen verwendet werden die in einem Plan-\Ist Vergleich zur Anwendung kommen. Dabei…
Dynamische Befüllung von Variablen mit ABAP CDS – Query Design Teil 1
Dynamische Befüllung von Variablen mit ABAP CDS - Query Design Teil 1 Einleitung In diesem Blog wird anhand eines einfachen Beispiels gezeigt, wie mittels ABAP CDS dynamisch Variablenwerte abgeleitet und auf einen Queryfilter angewendet werden können. Die Funktion ähnelt somit der Customer Exit Variable aus der klassischen SAP BW Anwendung. Daten und Zielsetzung Für dieses Szenario wurde eine Tabelle (ZTKST_DVU)…
Hierarchies in Core Data Services for ABAP Part 1: Annotation-based hierarchies
Hierarchies in Core Data Services for ABAP Part 1: Annotation-based hierarchies Introduction Business data is often hierarchically structured e.g. hierarchies of organizational units, a reporting hierarchy, hierarchies of financial accounts in the balance sheet, product hierarchies, product types and others. These hierarchical structures make it easier to get an overview, especially when analyzing and processing of larger amounts of data,…
STEPZ @ ZPARTNER – Part 3
STEPZ @ ZPARTNER - Part 3 Unsere erste STEPZ-Challenge geht langsam zu Ende und es wurden schon fleißig Schritte gesammelt. Für einen modernen Look haben wir STEPZ im Dark Mode implementiert. Da der Dark Mode aber nicht jedem zusagt, gibt es für die User die Möglichkeit, die App in den Light Mode zu switchen. Die favorisierte Ansicht wird dann auch…
STEPZ @ ZPARTNER Part 2
STEPZ @ ZPARTNER Part 2 https://www.youtube.com/watch?v=NAoLGGwp58A Unsere ZPARTNER-Challenge STEPZ geht in die zweite Woche! Es wird geschwommen, gelaufen, geradelt, gewandert ... und in der SAP Analytics Cloud (SAC) Aktivitäten und Schritte erfasst. Um zu zeigen, wie das alles funktioniert, haben wir ein kurzes Video zusammengestellt. Viel Spaß dabei!
How To: Leverage Native HANA SQL-SCRIPT within ABAP CDS VIEWS
How To: Leverage Native HANA SQL-SCRIPT within ABAP CDS VIEWS Introduction ABAP CDS Views are SQL extensions, based on anyDB. There are several built-in functions (numeric, string, date/time, conversion) but, analogous to OpenSQL, that repertoire is limited and may not suffice for complex business requirements. In such situations, we may want to leverage the full HANA native SQLScript feature set:…
Sync SAP BW Roles to SAC Team
Challenge SAP Analytics Cloud is getting more important within SAP Landscape when it comes to visualizing data from the customer ecosystem. With that there is also a major increase in user administration and management. Especially if you want to synchronize your BW Roles with a SAC Team to easily maintain the rights to a functional folder structure, there is currently…
SAP Analytics Cloud (SAC) – Workspaces
General SAP Analytics Cloud is a powerful frontend and offers multiple options to collaborate between users. Creating stories in SAC can be done in the user individual folders and then shared with specific users or teams. Furthermore, there is the public folder structure where users are authorized to see/create/change stories depending on their authorization on folders via team assignments or…
SAP Analytics Cloud (SAC) – Benchmark Tool
SAP released the Benchmark Tool for analysing your system performance as part of the performance analysis tools with Wave 2022.08 and 2022.Q2 QRC Release. The Performance Benchmark helps to measure your client hardware score and network speed. These have a measurable influence on your SAP Analytics Cloud user experience. Accessible for all users per default under System/Performance/Benchmark Tool: With this…
End of BI-IP – What‘s next? A viewpoint on the SAP Planning Portfolio – 1
Introduction The SAP Portfolio for planning is changing. The system landscape for reporting and planning is enhanced by SAP Analytics Cloud (SAC). Or maybe you are in the middle of a S/4 HANA project or a BW/4 project is going on. However your current planning system landscape looks like, chances are high that you will be impacted by a SAC,…
SAP Analytics Cloud (SAC) Change Datasource – Development in a One-Tenant Environment
SAP Analytics Cloud (SAC) is a powerful Frontend and offers multiple options to share stories with consumers. When report usage is increasing it is also very important that new developments are deployed smoothly for end users. Especially in a landscape with one tenant, acting as development system, quality system and productive system, this can be a challenge. Changing the Data source…
Switch between themes in SAP Analytics Cloud
Introduction Switching between themes is very often part of modern applications. Especially switching to a dark mode becomes a common feature, that would also be a "nice to have" in SAP Analytics Cloud Applications. This blog describes how to switch themes in a SAP Analytics Cloud Application and what you should be aware of while developing. There is already a…
ABAP CDS – EINE EINFÜHRUNG IN DAS THEMA „ANNOTATIONEN“
Einleitung Dieser kurze Beitrag stellt ein paar grundlegende Informationen zu ABAP CDS Annotationen vor und soll den Aufbau, die Eigenschaften sowie die Wirkungsweise von Annotationen im Kontext von ABAP CDS anhand von Beispielen etwas verdeutlichen. Aufgrund der Vielzahl an Annotationen und deren Möglichkeiten, stellt der Beitrag natürlich nur einen kleinen Ausschnitt des gesamten Spektrums dar. Was sind Annotationen und welche…
SAC Analytic Application – Scripting for Beginners : Part 4 – How-to use results from charts
SAC Analytic Application – Scripting for Beginners : Part 4 – How-to use results from charts In the first part of this SAC Scripting blog series, I shorty explained how Master Data can be read and changed in SAC Analytic Application with the help of scripting. In the second part, I showed how Data Actions can be used in Analytic…
SAC Analytic Application – Scripting for Beginners : Part 3 – How-to handle and calculate Dates
SAC Analytic Application – Scripting for Beginners : Part 3 – How-to handle and calculate Dates In the first part of this SAC Scripting blog series, I shorty explained how Master Data can be read and changed in SAC Analytic Application with the help of scripting. In the second part, I showed how Data Actions can be used in Analytic…
Extended sorting of BEx Variable value help members in Story Filters in SAP Analytics Cloud (SAC)
Challenge SAP Analytics Cloud is a powerful frontend especially when working with SAP BW live connection. Reporting with SAP BW Live Connection especially in context of BEx Variables can be enhancement to optimize user experience. In our example we want sort the result of the variable help in SAP Analytics Cloud Story Filter linked to a BEx Variable to make…
SAC Analytic Application – Scripting for Beginners : Part 2 – How-to hand over Parameters for Data Actions
SAC Analytic Application – Scripting for Beginners : Part 2 – How-to hand over Parameters for Data Actions In the first part of this little SAC Scripting blog series I shorty explained how Master Data can be read and changed in SAC Analytic Application with the help of scripting. In this part, I am going to show how Data Actions…
SAC Analytic Application – Scripting for Beginners : Part 1 How to read and change Master Data of Dimensions
SAC Analytic Application - Scripting for Beginners : Part 1 How to read and change Master Data of Dimensions When working with SAC and setting up an Analytic Application, you will probably come across scripting. If you are not an expert in Java Script, it will probably take some time until you are familiar with this script language and therewith…
Dead end SAP Integrated Planning
Dead end SAP Integrated Planning SAP Integrated Planning is a mature application with a great framework enabling usage of global data warehouse objects out of SAP BW for planning. It integrates global objects and data such as master and transactional data into the planning application. Authorization out of the current system can be reused and frontends, like SAP Bex Web…
How-To make a SAC Story Mobile ready
Introduction This How-to Paper provides guidance for an end-user on which settings/changes are necessary to make a new/existing SAP Analytics Cloud Story usable for a mobile device. Being able to access stories and dashboards with a single click on smartphones allows end users an instant view of any business and daily improvement. Especially due to the constant growth of data…
Value help of Bex Variables used in SAP ANALYTICS CLOUD via SAP BW Live Connection in with BADI „Refining Input Help in Variable Screen“
Introduction Value helps for selections and navigations are on the one hand very simple but on the other hand could get very complex. One example is implementing context specific filtering. The aim of context filtering is to provide only those values to the users that are meaningful for his or her reporting needs and could speed up users analytics tasks.…
SAC Analytics Cloud – Application Design
ZPARTNER's Bernhard Sauerteig gave a presentation on SAP Analytics Cloud - Application Design at the SAP Online Track 2020. This session gives an Overview to SAP Analytics Cloud and its Capabilities (like Analytic Applications Scripting, Dashboarding, Data-aquisition) - including a Demo. https://youtu.be/1auoo0CbOAg Special Thanks to: https://twitter.com/mm_mikemeister/status/1321820254335586304?s=20
SAP Analytics Cloud Story development in a single tenant scenario
SAP Analytics Cloud is a powerful frontend and offers multiple option to share stories with consumers. When consumption is growing it is also very important that new developments are deployed smoothly for end users. Especially in landscape with one tenant, acting as development system, quality system and productive system this could get a challenging. Stories and their URLs are often…
SAP Analytics Cloud Story SAP with HANA Live Connection ABAP Cache Warmer
Next to most current and correct data, performance is another very important factor in analytics. In the blog "How to trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection" ( https://blogs.sap.com/2020/02/24/how-to-trace-widgets-in-sap-analytics-cloud-stories-connected-via-hana-live-data-connection/ ) it was already described how to grep performance data and link them to a widget in a SAP Analytics Cloud Story with SAP HANA…
Trigger SAP Analytics Cloud Data Management Schedule via REST API
Scope SAP Analytics Cloud offers many possibilities for reporting and planning. Especially SAP Analytics Cloud core planning includes features like “Generating Private Versions” and “Advanced Commenting”. To be able to use SAP Analytics Cloud core planning, data have to be imported into SAP Analytics Cloud Planning Models. SAP Analytics Cloud Planning Models can use global dimension importing data from different sources. In a hybrid scenario with SAP BW as source system it could be very useful to use existing InfoObjects as import source for SAP Analytics Cloud global dimensions and keep data in sync. Prepare In this example a SAP BW InfoObject ZEPPART is…
SAP Analytics Cloud – Performance Do`s and Don‘ts
There are many factors which can impact performance within SAP Analytics Cloud. For one thing, there is a given technical environment like local PC’s resources (CPU, memory, browser), network bandwidth or backend sizing and configuration. Source: SAP Those definitely affect runtimes but can hardly be influenced by an application developer. On the other hand, an efficient design of SAC models,…
BPC Live Planung mit SAP Analytics Cloud
BPC Live Planung mit SAP Analytics Cloud Einleitung Die SAP Analytics Cloud bietet neben der Analyse von Daten auch die Möglichkeit in der SAC selbst ein Planungsmodell zu erstellen und somit eine Planungslösung für den Endanwender zur Verfügung zu stellen. Ebenso gibt es aber auch die Möglichkeit bereits in einem SAP BW System erstellte Planungsmodelle mittels BPC und einer BPC Live Connection zu konsumieren. Dieser…
ABAP Toolbox – Generate ADSO from csv + Extraction
Introduction Loading flat files can be a bit time consuming with the “normal” approach by creating an Infopackage and prepare the settings with field list. Also, in times of LSA++ and BW4/HANA the PSA are outdated. Therefore, we have created a solution for directly creating a field based ADSO based on a flat file and load the data within one program without too much preparation. Program Set delimiter and escape character according your file you want to upload. Set InfoArea and ADSO name Check Generate Hana…
Into the world of SAP Data Warehouse Cloud series – Part 4
Hi everyone, today we present the last chapter of our SAP Data Warehouse Cloud introduction series. In this chapter, we will learn how to build a story using our created data model. So, let’s start by navigating to the menu story builder (see Fig 1 on the left panel). Fig. 1 Click on our space which showed up (Fig 2). Fig. 2 Maybe you remember from chapter 2, we named our analytical view VIEW_SALES, therefore only this view is available and can be used for our story. Fig. 3 The middle screen is showing our canvas…
Into the world of SAP Data Warehouse Cloud series – Part 3
Hi everyone, I hope you still follow along with our DWC blog series, today we present to you chapter 3. As a reminder in chapter 1, we have created a space, while in chapter 2 we created 3 views. And in this chapter, we will relate these 3 views together to make it as a source for our dashboard. As a starting point, let us navigate by clicking the menu data builder (see Fig 1 on the left panel). Fig. 1 The 3 views previously created, show up (Fig 2) and you can click on “VIEW_SALES”. Because it…
Transport ODATA Services – System Aliases
ODATA is very helpful common language that allows systems a standardized communication. Also in SAP BW Context data could be consumed via ODATA as described in https://blogs.sap.com/2016/02/08/bex-queries-and-odata-in-bw-74/. When transporting the service and checking /IWFND/MAINT_SERVICE the System Aliases are most likely not set. One option is to set this in target system directly. In case of system with restricted access to…
An Approach for Strategic Planning with SAP IP
Requirement To implement a strategic planning solution is quite a common requirement. Usually the time horizon for strategic planning is 3-5 years. In contrast to operational planning it is also quite typical to plan in percentage rather than in absolute numbers. For our example let us assume an existing planning solution for the current year with sales quantities and the…
How-To insert an In-Cell-Chart into a SAC Story Table
Introduction This How-to Paper provides guidance on how to display a deviation in a table in the SAP Analytics Cloud in conformity with the International Business Communication Standards. This type of visualization is very useful because you can visualize a table together with a bar/column chart. The possibility of combining two different forms of data analysis/visualization in a table shows…
Into the world of SAP DataWarehouse Cloud series – Part 2
Hi everyone, today we are continuing this blog series with chapter 2. As you remember in chapter 1, we have created a space. In this chapter, we will have a look on how to create a data model with SAP Data Warehouse Cloud. As a starting point, let us navigate by clicking the menu data builder (see Fig. 1 on…
Will Analytics Cloud (SAC) put an end to the agony of choice?
Since Business Explorer (BEX) Suite was introduced, back in 1998, SAP’s portfolio of Business Intelligence (BI) tools has continued to grow. The first major boost came in 2007 with the acquisitions of BusinessObjects (BO) as well as Outlooksoft (BPC) and their software products. In 2015 the now called Analytics Cloud was introduced enhancing the portfolio once more. By then, however,…
How-To Master Data Planning in SAC with a BPC Live Connection
Introduction Since BW/4HANA 1.0 SP 08 Master Data Planning is available, which I shortly showed in a use case in the blog “How-to Master Data Planning in SAP BW/4HANA”. Based on this use case, I will shortly show how the master planning can be done in SAC with a BPC Live Connection to a BPC 11.1 Embedded. Scenario In this use…
How SAP Data Warehouse Cloud(DWC) consumes SAP HANA calculation views – Part 1
Introduction One of the good features of DWC is its flexibility to consume data from both SAP and Non-SAP Data Sources. Amongst those SAP Data Sources, we have SAP BW 4/HANA, SAP HANA etc but how can SAP HANA Objects, particularly the calculation views be consumed in DWC? In this blog post, we would want to show you how one…
SAP ANALYTICS CLOUD (SAC) Planning write back to SAP BW with ODATA
Introduction SAP Analytics Cloud offers you the possibility to build your own Planning Model and Application within SAC natively. At a certain point you might want to think about, how to get this data exported to an On-Premise SAP Business Warehouse. This document covers the solution to export the Data from a SAC Data Model back to BW with an OData connection. OData Writeback to SAP BW SAP is offering…
Into the world of SAP Data Warehouse Cloud series – Part 1
SAP goes cloud, who didn't hear about that yet? It is the future product portfolio strategy from SAP, therefore SAP built an enterprise-ready data warehouse in the cloud namely SAP Data Warehouse Cloud. It provides an end-to-end data warehouse that has capabilities to combine data management processes with advanced analytics. SAP Data Warehouse Cloud is meant to be a brand-new Data Warehousing solution, that can unite…
How-to Master Data Planning in SAP BW/4HANA
How-to Master Data Planning in SAP BW/4HANA Introduction In a BW project a typical requirement is that business wants to change or enrich Master Data. Until now this was mostly done with customized solutions like having a special aDSO working as control table with a class for master data update or doing it in the BPC Master Data Administration. Since…
A BW/4HANA Conversion in pictures
Introduction Recently we converted a SAP BW 7.5 (SP 16) on HANA system to a BW/4HANA 2.0 (SP 05). SAP provides you with three conversion paths, the so-called “In-place Conversion”, “Remote Conversion”, and “Shell Conversion”. Here we followed the “In-place Conversion” path as the system was already almost BW/4 ready. This document provides a rough idea how the different steps look like. This was a demo system of ZPARTNER, doing the same for a productive system could…
How to: SAP Analytics Cloud Performance Issues and Best Practices
Customer/Developer Point of View “Once upon a time there was an SAP Analytics Cloud (SAC) analytics model (based on an external-SAP Hana-view) published in SAP Analytics Cloud. And it was doing great. It grew and grew and grew, till the MDS (1) statement was so big it crashed every time someone wanted to execute the statement. The master story (and all other stories) with over…
How to: Load a CSV file into SAP BW/4HANA using the Planning function type 0RSPL_FILE_UPLOAD_AO
Introduction The requirement to upload a CSV file into a SAP BW system is something a lot of people have come a across every once and a while. There the well-known solution by Marc Bernard is provided. In SAP Note 2053696 it is now stated that this How-to Paper is obsolete and should not be used anymore. Therefore, the new Planning Function type File…
How to: Trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection
Beitrag bearbeiten Es gibt eine automatische Speicherung dieses Beitrags, die aktueller ist als die unten stehende Version.Die automatische Speicherung ansehenTitel hier eingebenHow to: Trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection SAP Analytics Cloud is a powerful tool to visualize data. Even though it is a cloud framework, it could be very helpful in some cases…
How to: Activate Master Data Hierarchies for SAP Analytics Cloud (SAC)
Introduction SAP Analytics Cloud enables to create dynamic visual stories based on key business areas with trusted data that is managed by IT. (Source: https://www.sapanalytics.cloud/product/#businessintelligence ) There are many introductions and learning materials for creating powerful reports and dashboards for SAC. All the information shows how to visually deal with data derived from various sources. Since the BW live connection via BW…
How to: Create Dataflow within BW/4HANA
What is a DataFlow Object? The Dataflow object is a way to model your dataflow within SAP BW/4HANA within the Eclipse world. It is a graphical feature which also enables you to create a dataflow from start to finish. All created objects eg Datasource, ADSOs, InfoObjects etc are available for re-use within other dataflows. The Dataflow object is transportable. Another…
How to: SQL statements for HANA DB maintenance
Hello, quite often it’s necessary to fix issues related to HANA model execution – e.g. defective views, troubles with authorizations etc. There are some SQL statements that are quite handy for that purpose and I like to share those: –Check invalid custom DB views select * from “SYS”.”VIEWS” where schema_name not like ‘SAP%’ and is_valid = ‘FALSE’; –Check inactive…
How to create transitive navigation attributes in BW Modeling Tools
Introduction In traditional BW, modeling of transitive attributes (attribute of attribute) has been quite time consuming and also led to duplication of data, see explanation here. Transitive attributes – as an out-of-the-box feature – have been introduced in the BW Modeling Tools InfoObject editor with BW 7.5 SP4. Here you can simply enable the required transitive attribute, there is no…
Which road to take to BW/4HANA?
Introduction BW/4HANA is available now for more than 2 years and I got the feeling that more and more BW users are starting to think how to get there. If you do not start from scratch with BW then the process to BW/4HANA from any previous BW release is a completely new experience since it is much more application driven…
How to change/create Infoobjects with RSD1 as of BW 750 SP11 on HANA and BW/4HANA as of SP8
Introduction Before SAP BW 750 SP 11 it was possible to edit/maintain InfoObjects in RSD1 with the help of value nohdb in ok-code (see https://www.zpartner.eu/how-to-changecreate-infoobjects-with-rsd1-as-of-bw-7-5-sp4-on-hana/) . This was switched off with SAP BW 750 SP11. In some cases, it could be helpful to change InfoObjects (for instance if you want to edit Master Data Read Access - perhaps not available in…
ZPARTNER S/4HANA Demo21 mit SAP Analytics Cloud Integration
Hannes Kröner und Stefan Witteck haben zusammen erfolgreich die S/4HANA mit SAP Analytics Cloud Integration aufgesetzt. Gratulation und vielen Dank für den Einsatz!