In this article we will review creating an SAP BI Web Services connection in the Web Intelligence Rich Client, using the Web Service Publisher tool.
SAP Dashboard users regularly import data using both Query as a Web Service, (QaaWS), and Live Office data connections.
- A QaaWS connection does not require a Web Intelligence document and queries directly against an SAP Universe. Universe Queries are not as Sophisticated as a Data Block from a report. With QaaWS connections you can filter your data with prompts.
- Live Office Connections can retrieve sophisticated Data Blocks from Web Intelligence reports. You can apply logic and aggregation to report Data Blocks allowing you to transform your raw data into a more usable data set, better matched for the intended use in your dashboard. With Live Office connections you can filter your data with prompts and inputs.
A BI Web Services connection also retrieves sophisticated Data Blocks from Web Intelligence reports. With BI Web Services you can include additional inputs, filter dimensions and measures, Drill up/down in tables and insert additional Web Intelligence Document objects.
Creating a BI Web Service connection
BI Web service connections are published from Data Blocks in a Web Intelligence report. First you create a report with a table or graph of the Data Block you want to publish.
The Table below was built with City as a Dimension and Sales Revenue as a Measure. A Prompt Filter was also added on the Dimension Year.
When you Right Click on a table or graph in a report, you can select “Publish as Web Service”:
A Publish content wizard appears and guides you through the steps of creating the BI Web Service Connection:
The wizard fist checks to see if any other publications contain the same data and filters. If any duplicates are found they are displayed:
Then you name the Data Block in the Web Service and set Content Filters. Any Dimension or Measure can have Content Filters applied in the Web Service. You can also choose an alternate server to Publish the Web Service connection:
Finally, you save and Publish the Web Service to a folder on the server:
If all goes well you will receive an “Operation Successful” message. Then click “Ok” and “Finish”:
You can now review the Published BI Web Service in the Web Intelligence Rich Client. It will be listed in the Web Services Tab of the Left Panel. When you click on a BI Web Service in this panel, you can review its properties. This is also where you copy the BI Web Service URL to your clipboard:
When you click on a Data Block in this panel, you can review the Data Block properties. You can also open the drop down boxes to view the Universe Objects:
You can also view an image of the Data Block, or view the Data Block Content Filters:
In this example we used a very simple Block of Data with limited Prompts and Content Filters. BI Web Services can provide powerful insight to your data with sophisticated Data Blocks and more extensive Filters and Input Controls.
The Input Values and Output Values in the image below show some of the Filters, Input Controls and Web Intelligence Document Objects that are available in the BI Web Service we just created. These additional values can greatly enhance the data presented in your SAP Dashboards.