Business Intelligence Web Service, commonly known as BI WS is one more connectivity option offered by SAP to Xcelsius users to fetch data from external sources with Web Intelligence report as the intermediate layer
BIWS was introduced in BOXIR 3.1 SP2, in which it was possible to create BI WS only through Web Intelligence. However, from BO 4.0 onwards, it is now possible to create BIWS from Web Intelligence itself.
Below are the steps for creation of BI WS,
Open or Create a Web Intelligence report with the block of data you want to Publish.
For Publishing a block as Web Service, the report should be present in the CMS. Hence, if you are creating the report n Web Intelligence, name the report and save it to CMS. Alternatively, if you are creating the Web Service in Rich Client, then Export the report CMS before creating the Web Service.
Once you are done with the above steps…
Right click on the border of the block for a context menu. From the displayed menu, select ‘Publish as Web Service’ option as shown in the screen below
A Publish Web Intelligence Content Wizard will open up. Using this wizard, you can resolve duplicate Web Services, set filters and prompts on your Web Services, select or move the Web Services across folders or application Servers. Click Next
A following screen to choose duplicate Web Services will be shown, if no duplicate content is found, a message saying ‘no duplicate content was found’ will be displayed. Click Next
You will define your published content in the next screen, and set filters as per the requirements, and choose the server on which the Web Service will be hosted.
To add the host server, click on the Manage Servers button on ‘Define Published Content’ window… add the host name and the URL, and click on OK.
Once you are done with naming and describing your Published Content, Click on next.
On the next window, from the Tree structure (if you have already created the tree sturucture) I do not have the structure on my server, select the destination folder and click on ‘Create’ at the bottom. Web Services will be created, once created you will be presented with a message of successful creation
Congratulations…your Web Service is created.
Now, to copy, the WSDL, open your Web Intelligence report. Click on the Web Service Publisher Icon on the left. All the Published Web Services will be presented in the tree mode. Click on the Web Service who’s WSDL you want, the WSDL will be presented in the bottom window, as shown in the screen.
Copy the WSDL, this WSDL can now be used in the Xcelsius to fetch the data for your Dashboards.