BLOGS
Unsere Blogs rund um SAP BW on/4 HANA und SAP Analytics Cloud
DATA FLOWS IN SAP DATASPHERE (DWC) – Part 3: Using SQL Table Functions and incorporate them into your Data Flow
22 Mrz 0 CommentsDisclaimer 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 within the post is…
How to use SAP UI5 Icons in SAC-Stories and SAC-Applications
15 Mrz 0 CommentsChallenge 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 icon library in…
DATA FLOWS IN SAP DATASPHERE (DWC) – Part 2: Comparing Performance – The Script Operator Performance vs. SQL View Functions in Data Flows
08 Mrz 0 CommentsDisclaimer 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 within the post is…
DATA FLOWS IN SAP DATASPHERE (DWC) – Part1: Introduction
22 Feb 0 CommentsDisclaimer 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 within the post is…
How Business Warehouse can help you in IBP Projects
16 Feb 0 CommentsIntroduction 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. This question is exactly…
Data Modeling with CDS Views – Part 3: Session Information, Case, Cast, Where, Input Parameter & Consumption filter
09 Feb 0 CommentsIntroduction 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 CDS Views – Part 1: Basics . Part 2 has handled the topics…
Data Modeling with CDS Views – Part 2: Currency/Unit Conversion & Date Functions
25 Jan 0 CommentsIntroduction 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 To create a currency or unit conversion there…
Data Modeling with CDS Views – Part 1: Basics
11 Jan 0 CommentsIntroduction 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: Of course, there are some…
Kennzahlen und Textvariablen mit ABAP CDS-Views – Query Design Teil 2
06 Dez 0 CommentsEinleitung 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 wird die vom User frei selektierbare…
Dynamische Befüllung von Variablen mit ABAP CDS – Query Design Teil 1
11 Nov 0 CommentsEinleitung 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) mit Beispieldaten erzeugt, welche unter anderem die…
Hierarchies in Core Data Services for ABAP Part 1: Annotation-based hierarchies
09 Nov 0 CommentsIntroduction 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, by aggregating key figures to hierarchy…
STEPZ @ ZPARTNER – Part 3
03 Nov 0 CommentsUnsere 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 für…
STEPZ @ ZPARTNER Part 2
10 Okt 0 CommentsUnsere 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
26 Sep 0 CommentsIntroduction 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: Much more available functions and…
Sync SAP BW Roles to SAC Team
10 Aug 0 CommentsChallenge 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…
SAP Analytics Cloud (SAC) – Workspaces
23 Jun 0 CommentsGeneral 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…
SAP Analytics Cloud (SAC) – Benchmark Tool
14 Jun 0 CommentsSAP 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…
End of BI-IP – What‘s next? A viewpoint on the SAP Planning Portfolio – 1
07 Jun 0 CommentsIntroduction 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…
SAP Analytics Cloud (SAC) Change Datasource – Development in a One-Tenant Environment
17 Mai 0 CommentsSAP 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 this could be a challenge.
Switch between themes in SAP Analytics Cloud
06 Mai 0 Commentsbecomes a common feature, that would also be a ‘nice to have’ in SAP Analytics Cloud Applications. This blog describes how to switch themes in an SAP Analytics Cloud Application and what you should be aware of while developing.
ABAP CDS – EINE EINFÜHRUNG IN DAS THEMA „ANNOTATIONEN“
26 Apr 0 CommentsEinleitung 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.…
SAC Analytic Application – Scripting for Beginners : Part 4 – How-to use results from charts
12 Apr 0 CommentsIn 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 Application and how parameters can be dynamically defined and handed over…
SAC Analytic Application – Scripting for Beginners : Part 3 – How-to handle and calculate Dates
31 Jan 0 CommentsIn 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 Application and how parameters can be dynamically defined and handed over…
Extended sorting of BEx Variable value help members in Story Filters in SAP Analytics Cloud (SAC)
16 Dez 0 CommentsChallenge 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…
SAC Analytic Application – Scripting for Beginners : Part 2 – How-to hand over Parameters for Data Actions
06 Dez 0 CommentsIn 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 can be used in Analytic Application and how parameters can be dynamically defined…
SAC Analytic Application – Scripting for Beginners : Part 1 How to read and change Master Data of Dimensions
29 Nov 0 CommentsWhen 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 also until you are familiar with scripting in SAC. With a lot of searches…
Dead end SAP Integrated Planning
03 Aug 0 CommentsSAP 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 or Analysis for Office, are ready to use without any further licenses. Having a looking in the glass sphere into the future of the SAP Integrated Planning, a very nebulous picture came up.
How-To make a SAC Story Mobile ready
08 Apr 0 CommentsIntroduction 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…
Value help of Bex Variables used in SAP ANALYTICS CLOUD via SAP BW Live Connection in with BADI „Refining Input Help in Variable Screen“
22 Feb 0 CommentsIn this blog I want to focus on the usage of the BAdI for “Refining Input Help in Variable Screen” in context of SAP Analytics Cloud to enable special context-based filtering. In our example I would like to restrict the time and another dimension to values I choose randomly.
SAC Analytics Cloud – Application Design
05 Feb 0 CommentsZPARTNER’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. Special Thanks to: https://twitter.com/mm_mikemeister/status/1321820254335586304?s=20
Comments are closed.