In the previous parts we created a Xcelsius visualization model which is leveraging a Live Office document to retrieve SAP BI data. The underlying SAP BI query contains a SAP variable and in the next 2 parts we will create a OLAP Universe and a web service to generate the list of values for the Calendar Year and we can then combine this into a listbox in Xcelsius acting as the selector for our chart.
For the list of values I created a second query which by itself does not contain any variables so that we retrieve all possible values for the calendar year
As next step I will create a new OLAP Universe. I start the Universe Designer (Start > Programs > BusinessObjects XI Release 3 > BusinessObjects Enterprise > Designer).
I authenticate against the BusinessObjects Edge server and select the menu File > New.
I select New to create a new connection against the SAP BI system.
I enter a connection name and navigate down the list to selectSAP Business Warehouse from the list.
The notion of “SAP Business Warehouse” is only a description. Universes are supported for BW 3.5 and BI 7.
In the next screen I need to provide the connection details and I can select the authentication method for my connection
I select authentication Mode “Use Single Sign On when refreshing reports at view time“.
Using single-sign-on in combination with an SAP system requires the SAP authentication to be configured for the SAP system in the Central Management Console of BusinessObjects Enterprise.
In the next screen I can select the BI Query that I created.
As the final step I need to provide the name for my Universe.
Now I select the menu File > Export to export the universe to BusinessObjects Edge so that I can use it with the Query-as-a-WebService tool.
I select a folder for the Universe and I select the Groups that should be assigned to the Universe.
After creating the OLAP Universe, you can now create the web service on top of the OLAP Universe.
I start Query as a Web Service (Program > BusinessObjects XI Release 3 > BusinessObjects Enterprise > Query as a WebService) and because I never started it previously the list of hosts is empty.
I click Add to create a new host entry.
I enter the name of my BusinessObjects system and the URL will be filled in for me. I then enter the name of my CMS and click OK.
After creating the host definition I can authenticate towards the system
After the logon to the BusinessObjects Server I can now create a new WebService on top of Universe.
I select the menu Query > New….
… and enter a name for the web service and select the Advanced Parameters option and select secSAPR3 as Authentication method.
In the next screen I select the Universe I created and…
… in the next screen I select the Calendar Year as the result object.
In the next screen I am presented with a preview of the resultset…
… and in the next screen I copy the URL to the clipboard so that it can be used later on in the Xcelsius Designer.
At this point we have a Xcelsius model retrieving data from Crystal Reports via Live Office and a Query-as-aWebService retrieving data from SAP BI. In the next part we will use the webservice and integrate it into our Xcelsius model.
For those that missed the installation parts, here are the links to the blogs: