This blog post is the third part on how to integrate SAP Cloud for Customer with your Central Analytics solution and focuses on Monitoring the data replication. The complete blog consists of the following parts: Technical Connectivity Data Integration / Data Load Monitoring (this blog) Monitoring Monitoring can be done on both....
This blog post is the second part on how to integrate SAP Cloud for Customer with your Central Analytics solution and focuses on the Data Integration / Data Load part. The complete blog consists of the following parts: Technical Connectivity Data Integration / Data Load (this blog) Monitoring Data Integration / Data Load....
This is a step by step guide on how to integrate SAP Cloud for Customer (C4C) with your central analytics solution (SAP BW/BI). SAP Cloud for Customer allows to expose analytical data to central analytics solution like SAP BW / SAP BI via ODP or analytical OData. While the OData API allows to directly access....
When comes to SAP BW upgrade many companies may have many questions but the most asked question is should we upgrade to BW4HANA or BW ON HANA. I would like to explain briefly the difference between both and what should be the approach and what are the most important steps to take care after the....
First we will discuss about why analysis for office is useful for Business intelligence reporting and what are the advantages and the steps to create a report, scheduling it to specific users. SAP Analysis for Office is a plugin from Microsoft which can be used with excel and power point. When Excel plugin with SAP....
For all those who are in a hurry, this picture might explain everything: Comments on BW/BPC live connections in QRC2.2023 All those who are interested in a little more information we would like to invite to continue reading to find out the details of this exciting new feature… Introduction In many reporting or planning....
In 2021, SAP has published the SAP BW Birdge. Is it a SAP BW/4 HANA in the Business Technology Platform? Does this give the SAP BW a cloud SaaS perspective? What is the BW Bridge? There are already many blogposts and information material on the subject, so I’ll treat the topic only briefly here. The....
There are several blogs showing how to organize interaction between SAC and S/4HANA using OData services. However, one cannot ignore the fact that SAC, as an analytical tool, often uses data from SAP BW or BW/4HANA. This blog provides a simple example of how an OData Service can be used to exchange information between a....
The problem of an obsolete extractor in an SAP system refers to the challenge of accessing data from a legacy system that is no longer supported or compatible with the latest version of the SAP system. This can impact decision-making, reporting, and analysis, and lead to data integrity issues. The solution is to check if SAP....
Today, I am going to discuss about a basic Standard BW/BI Project Dataflows which you can consider as a starting base of a BW/BI project. In the last blog the ADSO concept will help here. 1.BW 7.5 on HANA Basic Dataflow – In this design we followed Queued delta Mechanism in CC side for Delta update. Design....
Today I will discuss about a scenario where I try to extract data from a BAPI extractor named BAPI_IM_HERE from ECC. if you put the BAPI FM as a source of a generic data extractor you will get the error of E_T_DATA table mentioned below – Solution : You can not take data directly from BAPI. write a functional module and put the BAPI extracted....
Introduction and Motivation Currently, there are different projects related to Integrated Business Planning ongoing. One motivation could be to have a successor for APO (Advanced Planning and Optimization). In case your system landscape contains a Business Warehouse system, you might be interested on how to utilize it in your IBP Projects. This question is exactly....
What is Update Behavior of End Routine? The original blog was posted by me back in 2010 which can no longer be edited and its missing all the screenshots. I am re-posting it here with some minor updates. This blog is for developers who are still using SAP BW and have now migrated to BW....
How can I consume an analytical query in ABAP ? Normally analytical queries are used with reporting tools like SAC, Analysis Office, WebDynpro Grid, or RSRT in backend. This post show how to directly access and use the query within your own ABAP application by the use of Lightweight BICS API ( LBA ) . It’s really easy....
Als SAP BW Berater weiß man die Vorzüge eines ad-hoc-Reportings zu schätzen. SAP S/4HANA Embedded Analytics führt ein breites Spektrum an CDS-Views mit sich. Daneben lassen sich mit selbst erstellten CDS-Views vielfältige, unternehmerische Anforderungen abdecken. Wie aber lassen sich solche CDS-Views möglichst einfach in einem ad-hoc-Reporting nutzen? SAP S/4HANA Embedded Analytics nutzt dabei das SAP....
Fields hidden by SAP in Standard BW Data Sources Many a times you would have observed that there are a few fields present in the extract structure of the SAP BW datasource but are not available in RSA6 or the data source which is replicated in BW. This blog talks about all steps as to....
In one of my earlier blogs, I put a spotlight on BW Transformations in HANA Runtime from ODP sources. The trigger came from lessons learned during an in-place conversion to SAP BW/4HANA were my team ran into situations causing some headaches. The reason was, that there is no HANA Runtime for transformations on ODP sources in....
In this blog, I am going to tell about some Tips and best practices of SAP BW and ECC you can utilize in your work – 1. While transporting a Composite provider after adding one field from underlying ADSO getting the error every time that the added field (Key) is missing in the CP node....
As planning data in SAC is often changed by business users, these changes need to be replicated to the target systems like BW/BPC, S/4 HANA or Data Warehouse Cloud. This is a feature highly demanded by many customers. The Data Export Service API is already GA in Q2.2022 with full data. With SAC QRC4 2022 the Data....
The business process that involves tracking of materials be it raw items or finished goods is termed Inventory management. It involves multiple stages such as ordering, storage, and utilization. In FMCG or manufacturing industry, Inventory management is the focus as it directly affects profitability and in return defines the sustainability factor. However, working in silos....
System copy configuration of SAP Business Warehouse (SAP BW and BW/4HANA) system landscape is highly complex due to the many connections between the involved application systems. Typically such a system landscape contains SAP BW (incl. BW/4HANA) systems, BI Java systems and SAP BW source systems such as SAP ERP, SAP CRM and SAP SCM etc.. ....
Below a list of some of the important standard SAP tables in a SAP Business Warehouse (BW) system with their description. Also there are some recommendations with reference SAP note on how to perform housekeeping and cleaning up of these BW tables. For more information you can see SAP note 2388483 – How-To: Data Management for Technical Tables. ....
1. Introduction This simple tutorial should give you an idea of how to consume SAC APIs in ABAP and post the result to BW ADSO. SAP exposes a few data-export APIs. API documentation can be found in the following links; https://api.sap.com/package/SAPAnalyticsCloud/rest https://help.sap.com/docs/…SAP Analytics Cloud REST API 2. Use-case Store changelog for SAC metadata Enhance existing....
You want to do a mass deletion of bookmarks, how do you achieve this? The following 3 ways are what I am aware of to clean up activity related to bookmarks. There probably are more ways to address this issue but in this blog I just highlight 2 ways on how you can reorganize/delete bookmarks.....
Most the business model cost center or profit center are located in different country and with different currency profit and cost is generated. At the end of the year finance team try to calculate total cost or profit against a target currency(USD,EUR or different one) which is the headquarter of the company located to generate....
Knock knock! Anyone else also looking for handy illustrations of the hierarchy functions introduced with HANA 2.0? Well count me in then ;). While trying hard not to write SQLs with recursive self joins to flatten a hierarchical data format presented in parent-child relationship, the hierarchy functions in HANA can be a saviour for sure. Let’s....
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 folder....
This article aims to get a one-stop solution and an overview of the various SAP FICO standard reports for techno-functional consultants, especially reporting consultants. The quick comparisons will help consultants solve most of the ambiguities raised when analyzing reconciliation issues. Overview of FICO: FICO, an abbreviation for Finance and Controlling, is a vital module....
In this blog, I am going to discuss about some of those best practices you can utilize – 1.Removing special character from data load : Most of the times the data load fails for unwanted source data. Execute T code RSKC and put the special character which you want BW to ignore during data load(DTP).....
There are tons of different ways how you can performance traces on SAC for troubleshooting. In this blog I will talk about one of the tracing methods called (TIMELINE TRACES) that can be very helpful when there are performance problems being observed in SAP Analytics cloud (SAC) regardless if the connection is with BW or....
Life is forcing you sometimes to change the context of composite provider. Many times I had a situation when I have to replace the ADSO to CalcView. But what if somethings goes wrong and you have to recreate assignments for all object once again ? It is not simple, in perfect world there should be....
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....
Hi Today I am going to discuss about the different type of commonly used date type implementation for customer exit. I feel from my experience that offset of a date variable not always give you the exact result expected for your requirement. In those scenarios we will go to go with the customer exit variable.....
Switching between themes is very often part of modern applications. Especially switching to a dark mode 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 a SAP Analytics Cloud Application and what you should be aware of while developing.....
How to run native SAP HANA objects (e.g., procedures) in SAP BW Process Chains (PC) Have you ever considered running HANA artifacts such as HANA Flow Graphs, Procedures etc. direct in BW Process Chains? Instead of using the BW scheduling and HANA scheduling tools separately and trying to get things synchronized between the systems.....
In this blog we will discuss about LO Data source enhancement using SAPI. The scenario is same. For a Particular Order we need to have material Status and other fields in our data flow for which Material Number is available in our datasource 2LIS_04_P_MATNR. But before going to the implementation I want to discuss about....
In this blog we will discuss about LO Data source enhancement using BAPI. The scenario is same. In one of the scenario I was involved, where we need to replicated purchase order fields which is available in standard Purchase Order Item datasource but we need customer and his address in Dashboard which needs to....
@BW/BI Transport Best Practices (use of TOC) : When transporting the BW objects it is always best practice not to move the original transport request to Quality in the initial stage when QA or testing not done. Because if there some issue found in the objects in testing, we do not have create a new....
Dear all, as the name implies, SAP BW/4HANA or SAP S/4HANA are fully integrated with the underlying SAP HANA platform. This also means, that the physical data model changed compared to their predecessor products (for example in FICO area). Some tables are removed, changed or consolidated which makes a lot of sense to leverage the full power....
Summary of what we achieved: We have recently migrated and upgraded the BW/BI system from Netweaver 7.0 to Netweaver 7.5 using the SAP’s robust tool SUM 2.0’s DMO feature for one of our customer. The database size was nearly 3 terabyte and the resultant HANA database was around 250 Gigabyte. The existing infrastructure was having....
Introduction In this blog we will explain you how we can create a Pareto chart in SAP Analytics Cloud using a Live Data connection to BW. A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending bars and the cumulative total is....
Abstract Innovate your IT landscape with SAP Data Warehouse Cloud, which is SAP’s strategic target solution for all data warehousing use cases in the puplic cloud, in line with SAP’s data-to-value portfolio strategy. This blog post provides SAP BW and SAP BW/4HANA customers an overview of how existing on-premises investments can be converted to the cloud. More importantly,....
Summary This Document explains about handling ADSO Inbound Table deletion in SAP BW Author : Bala.G.Reddy Company : Cognizant Technology solutions. Created on: 8TH Dec 2014. Author Bio I am Bala.G.Reddy working as Technology Architect at Cognizant Technology Solutions, India. I joined Cognizant Technology Solutions in 2014 and I have extensively worked on multiple SAP....
Introduction A customer of mine came up with the question, if we could do some variance reporting on the SAC in the context of line charts. Though there are settings which allow for variance reporting with line charts, they add another bar chart below the actual line chart, which then provides the positive or negative....
Dear Experts, I have a delta enabled LO extractor 2LIS_12_VCITM, upon change of delivery document the data source captures the before image with -ve figures but the after image is not appearing in the delta PSA. e.g. Upon initialization following record pulled in PSA through Full load Doc Line Actual GI Date Qty 80102614 10....
HANA is next generation, it will probably replace SAP BW. To me, it is probably, not definitely. Why? If we review the foundation of SAP BW, we will realize the brilliance and great work contributed by SAP engineers in the past. What is SAP foundation? I think it is LIS. We all know BW process....
Introduction: While checking the ‘Where-used List’ of any Info-Objects in SAP-BW, the result shows the relevant Infocubes, DSOs, Queries, Transformations, etc. where the Info-Object is used. However, it doesn’t show the Transformation routines/codes (Start Routine/End Routine/Field Routine/Expert Routine) where the Info-Object tables are referred to. For example, the 0MATERIAL master data table /BI0/PMATERIAL might be....
