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…
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…
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…
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),…
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…
„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…
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…
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…
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.…
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…
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…
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…
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. …
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…
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…
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…
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…
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…
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…
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…
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.…
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…
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…
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…
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…
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…
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…
DATA FLOWS IN SAP DATASPHERE (DWC) – Part 4: Using Dataspheres HANA Cloud Instance with Table Functions and how to integrate them seamlessly
DATA FLOWS IN SAP DATASPHERE (DWC) - 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…
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…
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…
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…
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…
DATA FLOWS IN SAP DATASPHERE (DWC) – Part 3: Using SQL Table Functions and incorporate them into your Data Flow
DATA FLOWS IN SAP DATASPHERE (DWC) - 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,…
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…
DATA FLOWS IN SAP DATASPHERE (DWC) – Part 2: Comparing Performance – The Script Operator Performance vs. SQL View Functions in Data Flows
DATA FLOWS IN SAP DATASPHERE (DWC) – 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…
DATA FLOWS IN SAP DATASPHERE (DWC) – 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…
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…
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…
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,…
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…
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…
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…
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.…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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…
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 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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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: …
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…
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…
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…
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!
HDB modeling in WebIDE – and why we are staying in HANA Studio for the time being
We are working with lots of mixed-scenarios, meaning that our data is stored in BW and exposed as Calculation Views for further HANA native processing. When we became aware that HANA modeling is moving away from HANA Studio and into…
Usage of SAP HANA Exit Variables for a standard reporting scenario
The scope of the document is to show how SAP HANA Exit variables are working for column selection for standard YTD reporting and delta calculation using native SQL. As a result the native SQL statements on generated calculation views work nearly…
SAP BW Hierarchien mit D3.js und BSP im ZPARTNER Style
Holger hat sich mal überlegt die Darstellung von SAP BW Hierarchien im grafischen Sinne ein wenig zu optimieren. Dabei ist ein kleines Framework zur Darstellung von SAP BW Hierarchien mit D3.js und BSP geworden. Per URL Parameter wird die Hierarchie…
Master Data Management with BPC Embedded
Requirement A typical requirement within a BW Project might be to offer Master Data Maintenance to End Users. E.g. to maintain specific global BW hierarchies. Overview of Possible Approaches In the following figure a comparison between different approaches can be…
HANA Views & SQL – Technical Performance Optimization
BW on HANA can easily enable SQL data access for third party tools, using the “External SAP HANA View” flag to automatically generate Calculation Views out of BW objects. However, Consuming multidimensional BW scenarios through relational SQL paradigm can lead…
How to change/create InfoObjects with RSD1 as of BW 7.5 SP4 on HANA?
Introduction InfoObject maintenance in the BW Modelling Tools (BW-MT) was made mandatory starting with SAP BW 7.5 SP4 on HANA. Since then it is not possible to maintain/create InfoObjects from the SAP GUI using the transaction RSD1. Displaying though still…
ZPARTNER (Stefan Witteck) hat seine S/4HANA Demo21 erfolgreich aufgesetzt
#zpartner hat nun mit der #S/4HANA Demo21 eine super Sandbox zum Testen und Implementieren von neuen Ideen. SAP-ZPARTNER-DEMO21-CONFIRM ZPARTNER, S/4HANA
RSEC*-Tables and IO AUTH_HASH
Old or Pre BW 7.4 Database-Tables for Hierarchy Entries within Authorizations RSECHIE Status of Authorization Hierarchies RSECHIE_CL Authorization Hierarchies Changes Change Log Database-Table after Upgrade to BW 7.4: All newly created Hierarchy Authorizations will be saved within this new table.…
Alternative Usage of RSDG_TRFN_ACTIVATE
Stefan Witteck hat einen neuen Blog gepostet, welches das BW-Leben erheblich erleichtern kann: http://scn.sap.com/docs/DOC-74131
Enhance technical content with BEx 7.x Bookmark calls
The scope of the document is to show a possible way to track BEx 7.x Bookmark execution and integrate the results into the technical content. Integration is done with the help of quite new SAP BW objects, like Open ODS…
BW system restore and one way to save the delta from source systems
This blog can help you to save the delta in case of a system restore. Read the full blog on SAP SCN: http://scn.sap.com/community/data-warehousing/bw/blog/2014/01/20/bw-system-recovery-and-one-way-to-save-the-delta-from-source-systems What happened? The productive BW system of one of our clients had a serious problem. Some tables…
Comparison of SAP BEx Query Designer and eclipse BW Modeling Query
Comparison of SAP BEx Query Designer and eclipse BW Modeling Query This blog tells you about the differences between SAP BEx Query Designer and the eclipse based BW Query on BW 7.4 and should help you to understand how query…
SAP HANA – SQL Execution Performance
BW can effortlessly expose data for external consumption e.g. by a third party tool, using the checkbox “External SAP HANA View”. Those automatically generated Calculation Views which are based on Composite Providers or even BW Queries are usually quite complex,…
SAP HANA – Advanced DSO Features
This blog post describes the features of ADSO’s and how to use them. View details on http://scn.sap.com/community/bw-hana/blog/2015/07/10/sap-hana--advanced-dso-features SUMMARY Our experience with Advanced DSO’s is good; we did not encounter severe problems. Everything worked after we gain the knowledge how to…
SAP HANA Security – Create Roles and Privileges from BW System in SAP HANA
This blog post explains how to create roles with privileges for SAP HANA Studio from BW for DBMS profiles in order to give the users the possibilities to see views on generated SAP HANA BW content (like calculated views generated…
Key figure selection in variable screen
If there is a requirement to restrict the key figures in the variable screen of a BEx Query, you have to work with some sort of workarounds ( formula variables, zero suppression and so on). With BW 7.4 SP8 another…
Hierarchical Display of Calculated and Restricted Key Figures in BEx Query Designer
Calculated (CKF) and restricted (RKF) key figures are often used in BW mainly for re-usability and maintenance reasons. However, the handling in the Query Designer is not optimal in case of huge number of CKF or RKF. Finding a certain…