Creating Webi Reports

Open the Java BI Launch Pad which can be found in below path on your desktop-

Start – All Programs – SAP Business Intelligence – SAP Business Objects BI Platform 4 – SAP Business Objects BI Platform Java BI Launch Pad

Create1.png

Internet explorer window opens showing below screen. Give the user name and password.

Create2.PNG

In the BI Launch Pad, you can view the reports in the Public folder and also you can create webi reports. The home screen looks like below where you can see your recent documents, messages and alerts.

Create3.PNG

Click the documents tab. In the ‘My Favorites’ folder you can access your own documents. If administrator has provided you access for some more folders, you can see them here and the documents under them.

Create4.PNG

Create5.PNG

 

You can see the webi reports on the right side, open any of the report by double clicking on it-

Create6.PNG

This is the way the end users open the reports.

How to Create the Webi Reports-

In the BI Launch Pad, click on ‘Applications’ and select ‘Web intelligence Rich client’.

Create1.png

If it asks for a Java update, select ‘Run this time’ or select ‘Update’ if you are admin on the local desktop. Click ‘Run’.

Click ‘New’ to start creating a webi report. You will get the following options-

Create7.PNG

No data source – You can create a report structure using this option but it will not have any data.

Universe – You can select a universe to start creating webi report

Excel – to create webi report from excel file on your local PC

BEx – to create webi report from BEx queries of connected SAP BW system

SAP HANA / SAP HANA Online / Analysis view – these sources you can select as a base for your webi report if you have a connected HANA system with data

Free hand SQL – to create webi report on any relational database like Oracle, ECC which has tables

Select ‘Universe’

You can see the list of universes created in the system.

Create8.PNG

efashion is the preinstalled universe when you install the BO, select it.

Create9.PNG

You can see the folders under efashion. These are classes. Classes contain objects.

Objects can be of three types – Dimension, Detail, Measure object

e.g. Month is a dimension and Month name is the detail of the dimension. Sales revenue will be a Measure which represents a transaction information.

Drag some dimensions and measure objects in the ‘Result Object’ pane. This creates a backend sql script for the report. You can view it by clicking on the ‘View Script’ button.

Create11.png

Create1.png

Close the window and click on ‘Run Query’. Below report is generated-

Create12.PNG

If you need to edit the query, click on the edit button-

Create13.png

Add product lines also and run the query-

Create2.PNG

If ‘Lines’ is not displayed in the query, drag it again from the left side to the right side-

Create13.png

To remove any column, you can drag and drop it into the left panel. Drag the ‘State’ column outside the report and refresh the report.

Create13.png

Based on the dimensions, the value of the measure is shown. It changed dynamically as you add or remove columns.

Create14.PNG

One point to mention here is that the universe does not have any data, the webi report shows the data by fetching it from the database using the sql query that was generated while creating the webi report.

When you save the webi report, the data shown in the report is saved in the repository. Whenever you refresh a webi report, it again fetches the latest data from the database.

If you want to save the report without data, you can purge the webi report and then save it.

Create14.PNG

Create2.PNG

To get the data back in the query, refresh it.

Purge option is generally used while transporting reports between Dev, QA and Prod systems as this reduces the report size and only report structure is saved and transported.

Save the report in MyFavourites or any Public Folder. Please note that you can only save a report in Public Folder if your administrator had given your user id appropriate rights to do so.

Create3.PNG

Go back to the documents folder and there you can see your saved report under the folder.

Create4.PNG

You can double click on it to open the report or right click and select ‘Modify’ to change it.

Create2.PNG

Here the Modify  option just changes the layout of the report with the available objects that you selected while creating the report in the query panel. Whereas in ‘Edit’ query, you can select more objects from the universe or remove them to change the report.

If you have extra objects in your report which you have excluded in the modify option, it is better to edit the query and remove those unwanted objects as every time you refresh the query, all the data is fetched from the database.

You can save the report in pdf or excel format to save a copy in your local desktop. Click on ‘Save as’. Note the option of selection specific pages from the report.

Create2.PNG

Create4.PNG

This is a vertical table format, all the charts etc. will also come as it is in the excel or pdf report.

Cross Tab report

Click on Report Element tab and select go to sub tab ‘Table’. Select ‘Insert cross table’ option-

Create2.PNG

Select the dimensions and drop them on the blue cells, select the measure and drop it in the white cell. You can get a display like below-

Create10.PNG

Here the measure is displayed as a  intersection of two dimensions.

End user will give the requirements according to which we need to select the type of table in the report.

Charts

You can add the pie chart in the same sheet or you can add a sheet. Right click at the ‘Report 1’ tab at the bottom and select ‘Add a report’

Create1.png

Select the pie chart and drop in the report.

Create1.png

Drag the dimension and measure into the pie chart.

Select bar chart also in the same report and drag different set of dimensions to display the data in the bar chart. Save the report.

Create3.PNG