BW Business Explorer (SAP BEx)

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 »

Summary: This article contains step by step process how to suppress columns based on input filter in SAP BEX query designer. Introduction: In BEX query designer is no standard function to suppress rows/columns based on input filter. There is only... Read More »

Purpose and target audience:  This blog explains the scenario to create BW Query on top of CDS View (Transient Provider).  includes how it can be created and the values for doing it. By using this scenario, sophisiticated calculations are... Read More »

Scenario : To read BW-BEx query report output into R/3(any other SAP system) Conventionally, it is being achieved by reading BW query via function module such as WREX_GET_DATA in R/3 or any other SAP system. The performance with this approach on... Read More »

This was an SAP webcast last week given by SAP’s Eric Yew. Please join us at 2018 ASUG Annual Conference, ASUG10040 session, and check out the grid here.  We also have several upcoming ASUG webcasts on this topic – they can be... Read More »

Summary This article contains the step by step process to differentiate null/blank value from the original 0 values. Author:         Mitul Jhaveri Company:     Accenture Created on:  02 March 2018 Summary:     I am having 5 years of... Read More »

Hi  All, Scope :  how to enable Virtual Char and KF in BEx query without adding our required fields in the desired cube . Assumption : The reporting is done over Multiprovider i.e. BEx Query is created over multiprovider. If the BEx Query is... Read More »

Hi, community! In the post I’d like to share my experience and thoughts about automation of testing BW(Bex) queries. During upgrade/migration projects customer wants to be sure that its BW(Bex) queries return the same result before and after... Read More »

In the previous two blog posts (here and here) I’ve introduced the basic concept of working with shortcuts and some applications of it in accessing SAP systems and BW applications. This time around I’ll show a few other applications in BW for... Read More »