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.

enable_access_bex_query.jpg

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.

bics_connection_cmc.jpg

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

sap_netweaver_business_warehouse.jpg

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.

webi_rich_client_document.jpg

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.

select_bex_query.jpg

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

adding_objects_query_panel.jpg

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

webi_document_added.jpg

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

SAP Webi Topics