SAP BO Dashboards + = DashConn

SAP BO Dashboards + = DashConn

Posted by Xavier Hacking

For the upcoming SAP BusinessObjects Dashboards Cookbook I had the pleasure to try some of the coolest add-ons for SAP BusinessObjects Dashboards (fka Xcelsius). One of them was the DashConn add-on by IdeaCrop. This add-on enables us to connect dashboards to real-time data from the popular CRM-cloud solution┬áLet’s have a look at the features of this add-on.


After installing the add-on a new component is added: DataViewer. This component is used to establish the connection with and to display the data from It actually works as an interactive grid in which you can set filters, aggregate data and drill-down/up in the report data.


In the properties pane we can – after logging in with our credentials – select the report we want to use. So in fact the only thing you need to get data into your dashboard is a proper report that provides all the data you want to use. There is no need to set up XML-data connections or other solutions that will take a lot of time to build. Just select a report from the list.

Data Output

An interesting feature is the option to bind data to the spreadsheet. With this we can use the data from the reports in other Dashboard Design components like charts and gauges. Not only the total result set can be bound to the spreadsheet, but also the selected rows can be bound separately! This enables us to make really interactive dashboards.

Another option here is to use Dynamic Prompts. For example you can use a slider component to set the minimal number of leads. The output in the DataViewer component then will only show the events that meet this dynamic requirement.

Working Mode

By default the component is configured to make a connection to and retrieve live data. There is an option to set the Working Mode to Offline, which means that the first level of report data is embedded within the dashboard. Now the dashboard is still usable without an internet connection. The Fallback Mode tries to retrieve live report data first, and when this fails the cached data is used.

Data Connection

So what if you don’t want to use the DataViewer component and you just want to load the report data into the spreadsheet and set up standard Dashboard Design components? DashConn features a Data Connection in the Data Manager that provides all of the features of the component. Additionally it has the Usage tab just like the other data connectors in the Data Manager in which you can define when the data should be refreshed.

Final thoughts

I like this add-on. Just select a report and the component does almost all the work for you. With the Data Output and/or Data Connection features you can make the dashboard as interactive and advanced as you want. The user guide even shows how to publish the dashboard back to so it can be used from within itself.

Check the demos, tutorials and free trial at the IdeaCrop website. - Apr 4, 2011 | SAP BusinessObjects Dashboards, Xcelsius
Tagged | , , , , ,

Leave a Reply