BLOGS
Unsere Blogs rund um SAP BW on/4 HANA und SAP Analytics Cloud
Dynamische Befüllung von Variablen mit ABAP CDS
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
SAP Analytics Cloud Story development in a single tenant scenario
19 Jan 0 CommentsWhen working with a single SAP Analytics Cloud tenant version should be handled carefully. Especially handling of shared URLs including storyIds could lead to unintentionally negative impacts for end users. Keeping the URL/storyid and be able to develop without pressure is in my opinion very helpful for developers and consumers of a story.
SAP Analytics Cloud Story SAP with HANA Live Connection ABAP Cache Warmer
23 Dez 0 CommentsNext 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…
Trigger SAP Analytics Cloud Data Management Schedule via REST API
16 Nov 0 CommentsScope 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…
SAP Analytics Cloud – Performance Do`s and Don‘ts
10 Nov 0 CommentsThere 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. Those definitely affect runtimes but can hardly be influenced by an application developer. On the other hand, an efficient design…
BPC Live Planung mit SAP Analytics Cloud
29 Okt 0 CommentsEinleitung 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 Blog soll…
ABAP Toolbox – Generate ADSO from csv + Extraction
19 Okt 0 CommentsIntroduction 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…
Into the world of SAP Data Warehouse Cloud series – Part 4
14 Okt 0 CommentsInto the world of SAP Data Warehouse Cloud series
Into the world of SAP Data Warehouse Cloud series – Part 3
30 Sep 0 CommentsHi 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). The 3 views previously created, show up (Fig 2) and you can…
Transport ODATA Services – System Aliases
27 Sep 0 CommentsODATA 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…
Comments are closed.