SAP Webi Queries using BEx - SAP Webi

How to build queries using BEx?

Webi documents can be created based on BEx (Business Exchange Queries) and created by BEx Query Designer, which is based on InfoCube in SAP BW system. You can connect to a BEx query in Webi with the use of BI Consumer Service (BICS) connection. You don’t have to create Universe for BEx queries, and all attributes, hierarchies, dimensions and measures will be automatically mapped in Webi document.

Documents can be edited, created and refreshed based on BEx using Web Intelligence Rich Internet Application Interface (Applet based) or Webi Rich Client. If you are using Webi DHTML web interface, you can only view or refresh a Webi document based on BEx but you cannot edit them.

Below important points about BEx should be taken in to consideration

  • Only BEx queries can be used which are flagged with “Allow External Access to the Query”.
  • For managing object mapping, refer to restriction and equivalent pages to ensure correct use of queries.

Below metadata objects are supported from BEx in Webi −

  • Hierarchies
  • Characteristics
  • Navigation Attributes
  • Display Attributes
  • Basic Key Figures
  • Calculation figures and formulas
  • Restricted Key figures
  • Variables
  • Customized Structure

How to Enable Access to BEx Query?

Open BEx Query Designer and select the query you want to use in BO tool. Go to Properties → Advanced tab and select Allow External access to Query. Save the query.


BICS Connection in CMC

You can create a BICS connection in CMC or also in Information Design Tool. A connection can be created to a single BEx query or to an Info Provider.

Login to CMC console → Select OLAP connection from the dropdown list.


Click on a New Connection → In Provider list, select SAP NetWeaver Business Warehouse.


Similarly, you can define a BICS connection in IDT. Select an OLAP connection and choose SAP NetWeaver Business Warehouse → SAP BICS Client Middleware driver.

How to Use BEx as Data Source in WebI Rich Client?

Open Webi Rich Client → New Document.


Click on select a BEx query as data source. In the new window, select BICS connection in the right pane and corresponding BEx query → Ok.


All the objects from BEx will be added to Query Panel on the left side. You can drag the objects to Result Objects.


Once you click on Run query, all the result objects will be added to a new Webi document as shown in the following snapshot.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

SAP Webi Topics