{"id":1146,"date":"2011-04-04T14:20:32","date_gmt":"2011-04-04T13:20:32","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=1146"},"modified":"2011-12-18T15:02:24","modified_gmt":"2011-12-18T13:02:24","slug":"sap-bo-dashboards-xcelsius-salesforce-com-dashconn","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/sap-bo-dashboards-xcelsius-salesforce-com-dashconn","title":{"rendered":"SAP BO Dashboards + Salesforce.com = DashConn"},"content":{"rendered":"

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

Component<\/strong><\/h4>\n

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

\"\"<\/a><\/p>\n

Reports<\/strong><\/h4>\n

In the properties pane we can – after logging in with our Salesforce.com credentials – select the Salesforce.com report we want to use. So in fact the only thing you need to get Salesforce.com data into your dashboard is a proper Salesforce.com 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.<\/p>\n

\"\"<\/a><\/p>\n

Data Output<\/strong><\/h4>\n

An interesting feature is the option to bind<\/strong> data to the spreadsheet. With this we can use the data from the Salesforce.com 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.<\/p>\n

\"\"<\/a><\/p>\n

<\/p>\n

Another option here is to use Dynamic Prompts<\/strong>. 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.<\/p>\n

\"\"<\/a><\/p>\n

Working Mode<\/strong><\/h4>\n

By default the component is configured to make a connection to Salesforce.com and retrieve live data. There is an option to set the Working Mode<\/strong> to Offline<\/strong>, 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<\/strong> tries to retrieve live report data first, and when this fails the cached data is used.<\/p>\n

Data Connection<\/strong><\/h4>\n

So what if you don’t want to use the Salesforce.com 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<\/strong> in the Data Manager<\/strong> that provides all of the features of the component. Additionally it has the Usage tab <\/strong>just like the other data connectors in the Data Manager in which you can define when the data should be refreshed.<\/p>\n

\"\"<\/a><\/p>\n

Final thoughts<\/strong><\/h4>\n

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 Salesforce.com so it can be used from within Salesforce.com itself.<\/p>\n

Check the demos, tutorials and free trial at the IdeaCrop website<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

The DashConn add-on for SAP BusinessObjects Dashboards (fka Xcelsius) by IdeaCrop enables us to connect dashboards to real-time data from the popular CRM-cloud solution Salesforce.com. Let’s have a look at the features of this add-on.<\/p>\n","protected":false},"author":1,"featured_media":1168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[126,6],"tags":[127,128,129,124,125,285],"class_list":["post-1146","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sapbusinessobjects-dashboards","category-xcelsius","tag-dashconn","tag-ideacrop","tag-salesforce-com","tag-sap-businessobjects-dashboards","tag-sbod","tag-xcelsius"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/dc4.png","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-iu","jetpack-related-posts":[{"id":1181,"url":"https:\/\/www.hackingsap.com\/blog\/sap-businessobjects-dashboards-4-0-cookbook-released-xcelsius","url_meta":{"origin":1146,"position":0},"title":"SAP BusinessObjects Dashboards 4.0 Cookbook released","author":"Xavier Hacking","date":"May 26, 2011","format":false,"excerpt":"I am very happy to announce the release of the SAP BusinessObjects Dashboards 4.0 Cookbook I worked on the past year with co-author David Lai and the team at Packt Publishing. In this book we discuss over 90 so-called recipes that give a step-by-step explanation of the possibilities of SAP\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"SAP BusinessObjects Dashboards cookbook","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sbodcookbook-243x300.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2077,"url":"https:\/\/www.hackingsap.com\/blog\/article-for-businessobjects-expert-dashboards-add-ons-xcelsius","url_meta":{"origin":1146,"position":1},"title":"Article for BusinessObjects Expert on add-ons for Dashboards","author":"Xavier Hacking","date":"January 13, 2013","format":false,"excerpt":"I wrote an article for the BusinessObjects Expert platform about add-ons for\u00a0SAP BusinessObjects Dashboards. These add-ons are third-party\u00a0plugins that extend the functionality of the standard toolset of SAP BusinessObjects Dashboards\u00a0and they can consist of additional components or connectivity options. Examples are add-ons that let you load data from CSV-files or\u2026","rel":"","context":"In "SAP BusinessObjects Dashboards"","block_context":{"text":"SAP BusinessObjects Dashboards","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects-dashboards"},"img":{"alt_text":"boexpert","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/boexpert.jpeg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/boexpert.jpeg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/boexpert.jpeg?resize=525%2C300 1.5x"},"classes":[]},{"id":1807,"url":"https:\/\/www.hackingsap.com\/blog\/xcelsius-dashboard-printer-2-5-update","url_meta":{"origin":1146,"position":2},"title":"Xcelsius Dashboard Printer 2.5 update","author":"Xavier Hacking","date":"September 2, 2012","format":false,"excerpt":"Last November a very useful add-on for SAP BusinessObjects Dashboards was announced by Data Savvy Tools: Xcelsius Dashboard Printer. This add-on component replaces the standard Print button component which only has one very basic functionality: Printing the whole dashboard as you see it. The Xcelsius Dashboard Printer add-on component lets\u2026","rel":"","context":"In "New technology"","block_context":{"text":"New technology","link":"https:\/\/www.hackingsap.com\/blog\/category\/new-technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1416,"url":"https:\/\/www.hackingsap.com\/blog\/intelligent-printing-in-sap-bo-dashboards","url_meta":{"origin":1146,"position":3},"title":"Intelligent printing in SAP BO Dashboards","author":"Xavier Hacking","date":"November 21, 2011","format":false,"excerpt":"I want to share a preview of the upcoming Dash Printer Add-on for SAP BusinessObjects Dashboards by Data Savvy Tools, which seems to be what the Print button should have looked like.","rel":"","context":"In "SAP BusinessObjects Dashboards"","block_context":{"text":"SAP BusinessObjects Dashboards","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects-dashboards"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Print_1-300x214.gif?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1124,"url":"https:\/\/www.hackingsap.com\/blog\/sap-htg-calling-bex-web-applications-from-sap-businessobjects-dashboards-xcelsius","url_meta":{"origin":1146,"position":4},"title":"SAP HTG: Calling BEx Web Applications from SAP BusinessObjects Dashboards (Xcelsius)","author":"Xavier Hacking","date":"February 21, 2011","format":false,"excerpt":"This SAP How-To Guide shows you how to call a BEx Web Template or a dashboard from a dashboard and vice versa.","rel":"","context":"In "SAP BusinessObjects Dashboards"","block_context":{"text":"SAP BusinessObjects Dashboards","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects-dashboards"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1127,"url":"https:\/\/www.hackingsap.com\/blog\/bi4-product-names-xcelsius-dashboards","url_meta":{"origin":1146,"position":5},"title":"BI4 product names for Xcelsius","author":"Xavier Hacking","date":"March 21, 2011","format":false,"excerpt":"Overview of the new BI4 product naming for SAP BusinessObjects Dashboards (fka Xcelsius).","rel":"","context":"In "SAP BusinessObjects Dashboards"","block_context":{"text":"SAP BusinessObjects Dashboards","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects-dashboards"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/1146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/comments?post=1146"}],"version-history":[{"count":20,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/1146\/revisions"}],"predecessor-version":[{"id":1532,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/1146\/revisions\/1532"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media\/1168"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=1146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=1146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=1146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}