BW Business Explorer (SAP BEx)

Local Web App to execute BEx query (All environment)

Hey All, Generally any business/Client has 3 or more SAP BW environment in their landscape. Namely Development -> Quality -> Production Development -> Integration -> Quality -> Production   Problem Statement : To check some requirement or do some testing or identify an issue/bug, we might need to execute multiple queries in all the system available in landscape. For the same, we need to either login to BW system and …

Read More »

AMDP based BEx Customer HANA Exit

Hello Everyone, With the release of the AS ABAP 7.4 many new capabilities were introduced, one of them is the AMDP methodology. This methodology is transformational as developers can leverage the best of both ABAP and SQL programming language to build models and applications. SAP BW on HANA, S/4 HANA embedded BW and BW/4 HANA can also take benefit from this framework. Traditionally, BW developers process the BEx variable processing …

Read More »

Replace BW-query with two structures with CDS-view

Hi! In the blog, I’d like to share with you some thoughts about remodeling BEx-reports to equivalent ABAP CDS-view. To be concrete, I’ll tell about BW-reports with 2 structures: one is with key figures, and another one is with restricted and calculated elements. Let’s consider simple example. Initial information. Let’s we have ADSO ZSALES and BW-report on top of it. BW-report has 2 structures. Structure in the rows contains 3 …

Read More »

BI Transformation Journey – Automated mass conversion from BEx to AO 2.X workbook

HI All, As SAP customers are advancing their landscape towards BW/4HANA they will have to transition from their traditional BEx Reporting to the latest SAP Analytics offerings. please refer to following blog for support and strategies – https://blogs.saphana.com/2017/04/11/sap-bw4hana-and-the-bexit-strategy/ and  https://blogs.sap.com/2016/10/13/sap-business-explorer-maintenance-support-policy/ In this blog I would like to highlight one such scenario where the BEx Workbooks would be replaced by SAP Business Objects Analysis for Microsoft Office (referred as AO). One of the biggest hurdles …

Read More »

Automatically create new BEx transport request on release of the old one

Problem In SAP Standard, after the BEx transport request is released, there is no new BEx transport request automatically created by the system and you have to manually create a new one via transaction RSOR (see this blog for details). However, the person who released the old BEx transport often forgets to do this, so the error message RSO 827 with message text ‘BEx transport request ‘&1’ is not available …

Read More »

SAP Business Explorer Maintenance and Support Policy

SAP Business Explorer (SAP BEx) – Maintenance and Support Policy For all SAP Business Explorer customers that are interested in the future of BEx, here is what you need to know: M A I N T E N A N C E BEx 7.x BEx 7.x continues to be supported with BW 7.50. Customers moving to SAP BW/4HANA from SAP BW should transition their SAP BEx reports and applications to SAP Analytics. SAP …

Read More »

Text Description for OFISCPER in BEx Report

Issue: While running Query, when We put Fiscal Period   = 010.2013 its description showing Jan 2013 instead of Jan 2014. Using V3 variant where January 2014 month is equals to 010.2013 period. Month                Period Jan 2014         010.2013 Feb 2014          011.2013 Mar 2014          012.2013 Apr 2014          001.2014 User wants to see the data as per calendar year. Solution: Go to this T-Code – RSRHIERARCHYVIRT in BW Check – Text Fiscal …

Read More »

BEx Analyzer conflicts with third-party Add-Ins

BEx Analyzer and Analysis for Office are tools created to visualization of query results. The purpose of these tools are the same, but also share some restrictions and limitations. One of these limitations is a intermittent issues with unpredictable pattern, when BEx Analyzer is running at same time with third party Add-In on MS Excel. Same is valid for Analysis for Office. SAP already documented issues while using Essbase Hyperion, …

Read More »

Error: ‘403 Access Denied’ | SAP BW Web Template

Introduction: Recently I worked on a project where we upgraded our WAD components from 3.x to 7x and encountered numerous issues, In this technical blog I have listed one of the interesting issue related to WAD Problem Statement:Upon upgrading the web templates from 3x to 7x we came across scenarios where customizations were done to call ABAP Class and BSP applications. As we know not all ABAP classes can be …

Read More »

BEx vs. Excel Average

Hi here is a problem, which I had recently at a client and I want to share this with you. I also posted this post on my blog (www.reyemsaibot.com). When I was recently creating a new query at a customer, I have found a strange phenomenon. The query should show the average ticket number of a department. First you see the explanation and then I provide the solution of the …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration