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…
Kategorie: BWBLOG
Into the world of SAP Data Warehouse Cloud series …
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…
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…
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…
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…
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…
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…
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…
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.
…