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
Internet explorer window opens showing below screen. Give the user name and password.
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.
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.
You can see the webi reports on the right side, open any of the report by double clicking on it-
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’.
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-
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
You can see the list of universes created in the system.
efashion is the preinstalled universe when you install the BO, select it.
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.
Close the window and click on ‘Run Query’. Below report is generated-
If you need to edit the query, click on the edit button-
Add product lines also and run the query-
If ‘Lines’ is not displayed in the query, drag it again from the left side to the right side-
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.
Based on the dimensions, the value of the measure is shown. It changed dynamically as you add or remove columns.
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.
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.
Go back to the documents folder and there you can see your saved report under the folder.
You can double click on it to open the report or right click and select ‘Modify’ to change it.
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.
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-
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-
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.
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’
Select the pie chart and drop in the report.
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.