SAP HANA BI Development - Webi Report


Advertisements

When the Universe is published to BO repository based on SAP HANA views, it can be directly used for reporting using the Query Panel. Universe contains data from SAP HANA/SAP BW or non-SAP data sources. Let us see how to build a query using the Universe.

Open Web Intelligence via BI Launchpad → Click New (Create a new Webi document). You will be prompted to select a Data Source.

BI Launchpad

Select a Universe as the data source and click 'Ok'. You will get a list of all available Universe. Select a Universe created on top of HANA view, which you want to use to create a Webi document. This will open a new window - Query Panel. In the query panel, on the left side of the screen, you will have a list of available objects. You will have Result Objects where you drag the objects from the left panel, which you want to add in a Webi document.

There will be Query Filter using which you can add different filters. Data Preview can be used to view data before it is added to Webi document. The Run Query tab at the top of the screen is used to run the query.

Query Filter

You can also add data from multiple sources in a single Webi document by adding multiple queries to the Query panel. You can add a new query by clicking the Add Query option. You again have the option of selecting a data source, from which you want to add a new query.

Multiple Sources

When you click the Run Query option on the top right corner of the screen, all the result objects will be added to the Webi document.

Run Query

Useful Video Courses


Video

SAPUI5 Online Training

25 Lectures 6 hours

Sanjo Thomas

Video

SAP Webi Online Training

Most Popular

26 Lectures 2 hours

Neha Gupta

Video

SAP Basis Online Training

30 Lectures 2.5 hours

Sumit Agarwal

Video

SAP C4C Online Training

30 Lectures 4 hours

Sumit Agarwal

Video

SAP MM Online Training

14 Lectures 1.5 hours

Neha Malik

Video

SAP WM Online Training

13 Lectures 1.5 hours

Neha Malik

Advertisements