BW Business Explorer (SAP BEx)

Introduction: The importing parameter “I_S_RKB1D”(query attribute) is not getting filled for authorization variable(I_STEP=0) in the FM “EXIT_SAPLRRS0_001″(FM for customer exit variable). Recently I have faced this issue in... Read More »

After upgrading to BW on HANA and Suite on HANA, the scenario for providing real time reports from BW is greatly simplified. (See blog: https://blogs.sap.com/2019/12/13/cds-based-data-extraction-part-i-overview/). Even with HANA everywhere, you... Read More »

We all know BEx queries have been the traditional Sap BW reporting method to analyze the dataset of the BI system. Info Objects are combined in a query and data is evaluated in a tabular report. Now Enterprise Reporting can be taken to the next... Read More »

In part 1 and part 2 we reviewed the option to create a model and a currency conversion table in SAP Analytics Cloud. …. but what if you are a customer using SAP Analytics Cloud in combination with SAP BW or SAP BW4HANA and you have already... Read More »

Some of you might have the need to create a currency conversion in SAP Analytics Cloud because the backend doesn’t provide all the required information. In such a scenario we can easily create a Currency Translation table in SAP Analytics... Read More »

After spending some time in S/4HANA Embedded Analytics building Queries in CDS views I came to a realization that it is a painful exercise. While in some (simple) cases it does, indeed, make a good sense, for real analytical queries probably a Query... Read More »

Dear All,   Just a simple approach for a requirement to calculate date difference in BEx query without using Formula Variable with Replacement Path. Eg : We need to find the difference of posting dates( Stock Age ) of material in inventory with... Read More »

Introduction: Hello everyone I am back with another idea that might help you through your day to day processes. Let me start by quickly walking you through what this post will be about, every business warehouse consultant gets loading errors in... Read More »

Introduction: How many times did a user come to you and tell you something is wrong with the report or the dashboard, then you go to check on the source infoproviders and find out that they have failed for some reason? In a fast paced environment... Read More »

Precalculated Value Sets (Buckets)   Applies to: SAP BW   Summary : To make SAP BW BEx queries more flexible & interactive, SAP Has given numerous functionalities in BEx Designer and Analyzer. BEx variables is one of those. There are... Read More »