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
Below metadata objects are supported from BEx in Webi −
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.
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.
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.
SAP Webi Related Interview Questions
|SAP SD Interview Questions||SAP PM Interview Questions|
|SAP BASIS Interview Questions||SAP ABAP Interview Questions|
|SAP FICO Interview Questions||SAP HANA Interview Questions|
|SAP CO Interview Questions||SAP EWM Interview Questions|
|SAP Webi Interview Questions||SAP Web Dynpro Interview Questions|
|SAP RFC Interview Questions||SAP R/3 Interview Questions|
|Sap Hybris Interview Questions|
Sap Webi Tutorial
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.