BI4.1: Creating a universe on top of a Web Service
You are asked now to select a driver, select here the Web Service Connector in the category Generic:
Now you can test the connection and hit Finish.
The Universal Wizard proceeds now seamlessly into the process of creating a Data Foundation. Enter a name (e.g. WebService1_DataFoundation) for the Data Foundation and click Next:
Select the table from the Web Service and hit Next:
Because this Web Service takes two inputs, the Edit Input Columns dialog appears. For now I am not binding the input columns to a parameter, simply because we do not have any parameters at this point in time. Go ahead and hit OK:
By now, the Universal Creation Wizard has finished its task by creating all basic objects that a universe needs. In our case, the web service has two mandatory inputs, so we need to take care about those in order to get some data back from the web service.
I have a list of world currencies in a CSV file, so I am creating two parameters in the Data Foundation that will get their List Of Values from the CSV file:
Go to the data foundation and right-click on the table, hit Edit Input Columns:
And map the newly created parameters in the Data Foundation with the Web Service input parameters:
After mapping the parameters you are good to go!
Now lets create a test query in the business layer and enter two currencies:
the conversion rate is delivered by the Web Service (nice!):
You could use this Information in your BI reports and e.g. offer your users the possibility of changing the currency dynamically. Now image the amount of Web Services available in the Internet and how you can enrich your BI Reports.
Thank you for reading and I hope you enjoyed this blog.