SAP NetWeaver BI 7.0

Design in No Time with New BEx Analyzer Control Objects

  • by Anurag Barua, Independent SAP Advisor
  • November 1, 2007
Find out how to implement the new BEx Analyzer slice-and-dice features in SAP NetWeaver BI 7.0.
Key Concept

BEx Analyzer in SAP NetWeaver BI 7.0 allows users to insert control objects, such as check boxes, buttons, and drop-down menus, with simple drag-and-drop functionality. The ability to use these control objects adds value to interactive end-user analysis, especially for ad-hoc querying.

BEx Analyzer looks significantly different in SAP NetWeaver BI 7.0 compared to its predecessor in SAP BW 3.5. For instance, this release offers control objects that you can drop into your Microsoft Excel worksheet to create and analyze queries. Let me show you how to add these controls. In the interests of space, I’ll look at two of them: the drop- down menu and the radio button group. Then I’ll show you an important Visual Basic setting that you need so you can ensure that the queries and filters run properly.

NoteNed Falk’s article, “SAP NetWeaver 2004s: What’s New in the BI Front-End: Part II,” (Volume 4, Number 5) introduced you to the concept of adding design items and controls in BEx Analyzer. This article provides a deeper look at the updated design and analysis modes available with SAP NetWeaver BI 7.0.

When you open a query in BEx Analyzer, you are in analysis mode. Three buttons appear at the top: Chart, Filter, and Info. I prefer to use the Filter view because it’s easier to add control objects to the query from this view. Figure 1 displays the Filter view for an open accounts receivable (AR) amounts query, which shows data from InfoCube 0FIAR_C03. The various examples in this article use this AR query.

Anurag Barua

Anurag Barua is an independent SAP advisor. He has 23 years of experience in conceiving, designing, managing, and implementing complex software solutions, including more than 17 years of experience with SAP applications. He has been associated with several SAP implementations in various capacities. His core SAP competencies include FI and Controlling FI/CO, logistics, SAP BW, SAP BusinessObjects, Enterprise Performance Management, SAP Solution Manager, Governance, Risk, and Compliance (GRC), and project management. He is a frequent speaker at SAPinsider conferences and contributes to several publications. He holds a BS in computer science and an MBA in finance. He is a PMI-certified PMP, a Certified Scrum Master (CSM), and is ITIL V3F certified.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.