What is BEx query in SAP BO?

BEx queries are a new data source option in SAP BusinessObjects BI 4. BEx queries are created from SAP Info Cubes in a SAP BW data warehouse. A BEx query will automatically map hierarchies, attributes, dimensions, and measures into data on your data provider in your Web Intelligence report.

What is structure in SAP BEx?

Structures are objects that you define in the BEx Query Designer. A structure forms the basic framework of the axes in a table (rows or columns). It consists of structural components. We differentiate between key figure structures and characteristic structures.

How do I connect BEx query to WEBI?

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.

How do I create a query view in BEx?

You can display query views in the following BEx tools:

  1. To display a query view in Microsoft Excel in BEx Analyzer, choose Open → Open Query in the analysis toolbar and select Query View as the type in the open dialog.
  2. In BEx Web Analyzer, choose New Analysis or Open to display a query view in the Web browser.

How do I create a BEx report?

Select (Click) the Business Intelligence tab. Select (Click) the role. Select (Click) the report. Select required and optional variables.

What is a universe in WEBI?

Universe contains data from OLAP and Relational data sources. Data in Universe can be a relational data or hierarchical data. Open Web Intelligence via BI Launchpad → New (Create a new Webi document). You will be prompted to select a Data Source.

How do I change the universe of a Web Intelligence Report?

Open the report and select DESIGN mode. Select the Data Access tab > Tools sub-tab > Change Source > then select the query whose data source you would like to change. The Change Source Wizard opens. Click Specify a new data source > Select a data source > Universe.