BLOGS
Unsere Blogs rund um SAP BW on/4 HANA und SAP Analytics Cloud
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…
An Approach for Strategic Planning with SAP IP
21 Sep 0 CommentsRequirement 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…
How-To insert an In-Cell-Chart into a SAC Story Table
17 Sep 0 CommentsIntroduction 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…
Into the world of SAP DataWarehouse Cloud series – Part 2
14 Sep 0 CommentsHi 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…
Will Analytics Cloud (SAC) put an end to the agony of choice?
07 Sep 0 CommentsSince 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…
How-To Master Data Planning in SAC with a BPC Live Connection
02 Sep 0 CommentsIntroduction 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…
How SAP Data Warehouse Cloud(DWC) consumes SAP HANA calculation views – Part 1
19 Aug 0 CommentsOne 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.
SAP ANALYTICS CLOUD (SAC) Planning write back to SAP BW with ODATA
14 Aug 0 CommentsSAP 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.
Into the world of SAP Data Warehouse Cloud series – Part 1
11 Aug 0 CommentsSAP 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.
How-to Master Data Planning in SAP BW/4HANA
10 Aug 0 CommentsIn 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.
A BW/4HANA Conversion in pictures
07 Aug 0 CommentsRecently 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
How to: SAP Analytics Cloud Performance Issues and Best Practices
02 Jun 0 CommentsCustomer/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…
How to: Load a CSV file into SAP BW/4HANA using the Planning function type 0RSPL_FILE_UPLOAD_AO
29 Mai 0 CommentsIntroduction 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…
How to: Trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection
25 Feb 0 CommentsSAP Analytics Cloud is a powerful tool to visualize data. Even though it is a cloud framework, it could be very helpful in some cases to get a look behind the scenes. Objective In that blog post we try to analyse a story build in SAP Analytics Cloud with HANA Life Data Connection to a SAP…
How to: Activate Master Data Hierarchies for SAP Analytics Cloud (SAC)
20 Feb 0 CommentsIntroduction 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…
How to: Create Dataflow within BW/4HANA
07 Dez 0 CommentsWhat 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…
How to: SQL statements for HANA DB maintenance
06 Dez 0 CommentsHello, 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…
How to create transitive navigation attributes in BW Modeling Tools
05 Dez 0 CommentsIntroduction 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 Modeling Tools InfoObject editor with BW 7.5 SP4. Here you can simply enable the required…
Which road to take to BW/4HANA?
06 Nov 0 CommentsIntroduction 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 process to BW/4HANA from any previous BW release is a completely new experience since it…
How to change/create Infoobjects with RSD1 as of BW 750 SP11 on HANA and BW/4HANA as of SP8
17 Okt 0 CommentsIntroduction 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 be helpful to change InfoObjects (for instance if you want to edit Master Data Read…
ZPARTNER S/4HANA Demo21 mit SAP Analytics Cloud Integration
10 Aug 0 CommentsHannes 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
18 Jun 0 CommentsWe 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 Web IDE for SAP HANA with quite some new features, we were excited at first.…
Usage of SAP HANA Exit Variables for a standard reporting scenario
04 Okt 0 CommentsThe 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 similar as a SAP BW Query. By using HANA Exit variables the Query can be…
SAP BW Hierarchien mit D3.js und BSP im ZPARTNER Style
01 Sep 0 CommentsHolger hat sich mal überlegt die Darstellung von SAP BW Hierarchien im graphischen 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 übergeben. Danach kann der User graphisch durch die Hierarchie navigieren – komfortable, schnell und graphisch ansprechend.…
Master Data Management with BPC Embedded
28 Jul 0 CommentsRequirement 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 compoarison between different approaches can be found. Within the next chapter we will go into the details of the BPC Embedded…
HANA Views & SQL – Technical Performance Optimization
07 Jul 0 CommentsBW 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 to quite some issues with performance. This blog is about a few basic technical tips,…
How to change/create InfoObjects with RSD1 as of BW 7.5 SP4 on HANA?
03 Apr 0 CommentsIntroduction 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 works. This change surprised the one or the other as this is the first existing…
Comments are closed.