In the previous parts we created the first part of our 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 we created a OLAP Universe on top of a BI Query to create a List Box in Xcelsius.
In this part we will leverage the web service to create the list box and we will configure the interactivity between the list box and our chart.
We going back to Xcelsius and open our existing visualization model with the chart.
I then select the menu Data > Connections and..
Click Add to add a new connection for our Query-as-a-WebService.
I select Query as a Web Service from the list and click on the new entry to finalize the configuration.
I paste the URL from the created QaaWS web service into the field WSD URL and click Import.
The web service is only returning one column. I select the entry “row” from the Output Values and then select the icon next to “Insert in” to mark the range in Microsoft Excel for the returned values.
After I am finished with that I navigate to the Usage tab and…
… set the Refresh on Load property.
Now I return to the Xcelsius canvas and Add a list box component to it. With a double-click on the list box component I open the properties.
I set the Insert Type option to Value and…
… select the range for the Source Data and point it to the previous marked cells for the web service.
I also select the range for the Labels and point it to the previous marked cells for the web service.
Now I need to configure the Destination to the cell in the spreadsheet that I used previously in Live Office as input cell for the parameter from the underlying Crystal Reports.
As next step I select the menu Data > Connections and go back to the existing Live Office connection that we did add previously and navigate to the Usage tab.
I select the icon next to the Trigger Cell and select the identical call that I used as the Destination cell (and as input cell for the parameter in Live Office).
I then select the option When Value Changes to make sure every time I select a different year from the list box the Live Office document is being refreshed with data from the SAP BI system.
I save everything and click Preview to take a look at my Xcelsius canvas.
So now the chart is being refreshed via LiveOffice and Crystal Reports towards the SAP BI System every time I select a different year from the listbox.
For those that missed the installation parts, here are the links to the blogs: