BLOGS

Unsere Blogs rund um SAP BW on/4 HANA und SAP Analytics Cloud

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

  • An Approach for Strategic Planning with SAP IP

    21 Sep 0 Comments

    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…

    Read More →

    Read More →

  • How-To insert an In-Cell-Chart into a SAC Story Table

    17 Sep 0 Comments

    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…

    Read More →

    Read More →

  • Into the world of SAP DataWarehouse Cloud series – Part 2

    14 Sep 0 Comments

    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…

    Read More →

    Read More →

  • Will Analytics Cloud (SAC) put an end to the agony of choice?

    07 Sep 0 Comments

    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…

    Read More →

    Read More →

  • How-To Master Data Planning in SAC with a BPC Live Connection

    02 Sep 0 Comments

    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…

    Read More →

    Read More →

  • How SAP Data Warehouse Cloud(DWC) consumes SAP HANA calculation views – Part 1

    19 Aug 0 Comments

    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 can create DWC models(views) from HANA calculation views.

    Read More →

  • SAP ANALYTICS CLOUD (SAC) Planning write back to SAP BW with ODATA

    14 Aug 0 Comments

    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.

    Read More →

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

    11 Aug 0 Comments

    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.

    Read More →

  • How-to Master Data Planning in SAP BW/4HANA

    10 Aug 0 Comments

    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 BW/4HANA 1.0 SP 08 there is a simple solution available, which I will show in a short use case.

    Read More →

  • A BW/4HANA Conversion in pictures

    07 Aug 0 Comments

    Recently we converted a SAP BW 7.5 (SP 16) on HANA system to a BW/4HANA 2.0 (SP 05). A BW4/HANA Conversion in pictures

    Read More →

  • How to: SAP Analytics Cloud Performance Issues and Best Practices

    02 Jun 0 Comments

    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…

    Read More →

    Read More →

  • How to: Load a CSV file into SAP BW/4HANA using the Planning function type 0RSPL_FILE_UPLOAD_AO

    29 Mai 0 Comments

    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…

    Read More →

    Read More →

  • How to: Trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection

    25 Feb 0 Comments

    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…

    Read More →

    Read More →

  • How to: Activate Master Data Hierarchies for SAP Analytics Cloud (SAC)

    20 Feb 0 Comments

    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…

    Read More →

    Read More →

  • How to: Create Dataflow within BW/4HANA

    07 Dez 0 Comments

    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…

    Read More →

    Read More →

  • How to: SQL statements for HANA DB maintenance

    06 Dez 0 Comments

    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…

    Read More →

    Read More →

Back to Top