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 Comments

    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) mit Beispieldaten erzeugt, welche unter anderem die…

    Read More →

    Read More →

  • Hierarchies in Core Data Services for ABAP Part 1: Annotation-based hierarchies

    09 Nov 0 Comments

    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, by aggregating key figures to hierarchy…

    Read More →

    Read More →

  • STEPZ @ ZPARTNER – Part 3

    03 Nov 0 Comments

    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 für…

    Read More →

    Read More →

  • STEPZ @ ZPARTNER Part 2

    10 Okt 0 Comments

    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!

    Read More →

  • HOW TO LEVERAGE NATIVE HANA SQL-SCRIPT WITHIN ABAP CDS VIEWS

    26 Sep 0 Comments

    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: Much more available functions and…

    Read More →

    Read More →

  • Sync SAP BW Roles to SAC Team

    10 Aug 0 Comments

    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…

    Read More →

    Read More →

  • SAP Analytics Cloud (SAC) – Workspaces

    23 Jun 0 Comments

    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…

    Read More →

    Read More →

  • SAP Analytics Cloud (SAC) – Benchmark Tool 

    14 Jun 0 Comments

    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…

    Read More →

    Read More →

  • End of BI-IP – What‘s next? A viewpoint on the SAP Planning Portfolio – 1

    07 Jun 0 Comments

    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…

    Read More →

    Read More →

  • SAP Analytics Cloud (SAC) Change Datasource – Development in a One-Tenant Environment 

    17 Mai 0 Comments

    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 this could be a challenge.

    Read More →

  • Switch between themes in SAP Analytics Cloud

    06 Mai 0 Comments

    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 an SAP Analytics Cloud Application and what you should be aware of while developing.

    Read More →

  • ABAP CDS – EINE EINFÜHRUNG IN DAS THEMA „ANNOTATIONEN“

    26 Apr 0 Comments

    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.…

    Read More →

    Read More →

  • SAC Analytic Application – Scripting for Beginners : Part 4 – How-to use results from charts

    12 Apr 0 Comments

    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 Application and how parameters can be dynamically defined and handed over…

    Read More →

    Read More →

  • SAC Analytic Application – Scripting for Beginners : Part 3 – How-to handle and calculate Dates

    31 Jan 0 Comments

    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 Application and how parameters can be dynamically defined and handed over…

    Read More →

    Read More →

  • Extended sorting of BEx Variable value help members in Story Filters in SAP Analytics Cloud (SAC)

    16 Dez 0 Comments

    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…

    Read More →

    Read More →

  • SAC Analytic Application – Scripting for Beginners : Part 2 – How-to hand over Parameters for Data Actions

    06 Dez 0 Comments

    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 can be used in Analytic Application and how parameters can be dynamically defined…

    Read More →

    Read More →

  • SAC Analytic Application – Scripting for Beginners : Part 1 How to read and change Master Data of Dimensions

    29 Nov 0 Comments

    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 also until you are familiar with scripting in SAC. With a lot of searches…

    Read More →

    Read More →

  • Dead end SAP Integrated Planning

    03 Aug 0 Comments

    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 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.

    Read More →

  • How-To make a SAC Story Mobile ready

    08 Apr 0 Comments

    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…

    Read More →

    Read More →

  • 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 Comments

    In 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.

    Read More →

  • SAC Analytics Cloud – Application Design

    05 Feb 0 Comments

    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. Special Thanks to: https://twitter.com/mm_mikemeister/status/1321820254335586304?s=20

    Read More →

  • SAP Analytics Cloud Story development in a single tenant scenario

    19 Jan 0 Comments

    When 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.

    Read More →

  • SAP Analytics Cloud Story SAP with HANA Live Connection ABAP Cache Warmer

    23 Dez 0 Comments

    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…

    Read More →

    Read More →

  • Trigger SAP Analytics Cloud Data Management Schedule via REST API

    16 Nov 0 Comments

    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…

    Read More →

    Read More →

  • SAP Analytics Cloud – Performance Do`s and Don‘ts

    10 Nov 0 Comments

    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. Those definitely affect runtimes but can hardly be influenced by an application developer. On the other hand, an efficient design…

    Read More →

    Read More →

  • BPC Live Planung mit SAP Analytics Cloud

    29 Okt 0 Comments

    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 Blog soll…

    Read More →

    Read More →

  • ABAP Toolbox – Generate ADSO from csv + Extraction

    19 Okt 0 Comments

    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…

    Read More →

    Read More →

  • Into the world of SAP Data Warehouse Cloud series – Part 4

    14 Okt 0 Comments

    Into the world of SAP Data Warehouse Cloud series

    Read More →

  • Into the world of SAP Data Warehouse Cloud series – Part 3

    30 Sep 0 Comments

    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).    The 3 views previously created, show up (Fig 2) and you can…

    Read More →

    Read More →

  • Transport ODATA Services – System Aliases

    27 Sep 0 Comments

    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…

    Read More →

    Read More →

Back to Top