Chapter 9. Retrieving External Data Sources

So far, we have worked with static data that was stored in an Excel data model of our dashboard. In real-life scenarios, we need to link our dashboard with an external data source, such as a database or web service.

In the earlier releases of SAP BO Dashboards (XI 3.1 and older), we used to connect our dashboard to dynamic data using methods such as Live Office, web services, XML data, and XML maps. But these methods were complex and difficult to use and couldn't fulfill the end user's needs. We have a new method introduced in the release of version 4.0, which is called Direct Query. Using this method, we can build a direct query on a top of universe and send the parameters in an easy way. We can also ...

Get Learning SAP BusinessObjects Dashboards now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.