{"id":459,"date":"2010-05-08T18:22:51","date_gmt":"2010-05-08T17:22:51","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=459"},"modified":"2012-12-28T14:40:59","modified_gmt":"2012-12-28T12:40:59","slug":"xcelsius-using-the-push-button-for-data-input","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/xcelsius-using-the-push-button-for-data-input","title":{"rendered":"Xcelsius: Using the Push Button for data input"},"content":{"rendered":"

Xcelsius is a great tool to build interactive what-if scenarios based on MS Excel models. We recently got a request to build such a dashboard and one of the user interface requirements was that the user should be able to change a value by clicking something like a +\/- button. Clicking the plus had to increase the value with 1, and clicking the min had to decrease it with 1.<\/p>\n

Luckily, Xcelsius provides us the Spinner component. This would have been a good and easy solution, if another\u00a0\"\"requirement wouldn’t have been that the dashboard had to be used on a (multi)touch screen. Touch means big buttons for user input and as you can see on the right, the Spinner component is way too detailed. So we needed something else to do the job.<\/p>\n

To solve this we used the new Push Button components. The Push Button simply does what its name says and pushes a value from a source cell to a destination cell. To solve our little problem we used two of these Push Buttons and some basic MS Excel logic.<\/p>\n

[kml_flashembed publishmethod=”static” fversion=”8.0.0″ movie=”http:\/\/hackingsap.com\/blog\/wp-content\/uploads\/plusminhackingsapcom.swf” width=”500″ targetclass=”flashmovie”]<\/p>\n

[\/kml_flashembed]<\/p>\n

In the spreadsheet two formulas and a cell with a start value for the gauge (C2) are created. The formulas add or deduct 1 from C2 (C2+1 and C2-1). After this the Push Buttons have to be bound to these cells. The plus button now gets B2 as Source Data and C3 as destination. After a click on this plus button the value of C2 will increase to 26.<\/p>\n

You can download the source file\u00a0here<\/a> (via Pay with a Tweet). If the file downloads as a ZIP-file, just rename the .zip into .xlf.<\/p>\n

\"\"<\/div>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

How to use the push button for data input into your Xcelsius what-if scenario dashboard.<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[21,44,126,6],"tags":[287,283,105,80,76,77,285],"class_list":["post-459","post","type-post","status-publish","format-standard","hentry","category-diy","category-knowledge-sharing","category-sapbusinessobjects-dashboards","category-xcelsius","tag-diy","tag-sap","tag-sap-crystal-dashboard-design","tag-scdd","tag-tips-tricks","tag-what-if-scenario","tag-xcelsius"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-7p","jetpack-related-posts":[{"id":1807,"url":"https:\/\/www.hackingsap.com\/blog\/xcelsius-dashboard-printer-2-5-update","url_meta":{"origin":459,"position":0},"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":102,"url":"https:\/\/www.hackingsap.com\/blog\/powerpoint-xcelsius-and-twitter","url_meta":{"origin":459,"position":1},"title":"Powerpoint, Xcelsius and Twitter DIY","author":"Xavier Hacking","date":"November 29, 2009","format":false,"excerpt":"Using Twitter in Xcelsius. How does it work?","rel":"","context":"In "DIY"","block_context":{"text":"DIY","link":"https:\/\/www.hackingsap.com\/blog\/category\/diy"},"img":{"alt_text":"twitter1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/twitter1.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/twitter1.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/twitter1.png?resize=525%2C300 1.5x"},"classes":[]},{"id":1008,"url":"https:\/\/www.hackingsap.com\/blog\/xcelsius-2008-fix-pack-3-4-available","url_meta":{"origin":459,"position":2},"title":"Xcelsius 2008 Fix Pack 3.4 available","author":"Xavier Hacking","date":"December 15, 2010","format":false,"excerpt":"It's update time again: Xcelsius 2008 SP3 Fix Pack 3.4 is ready for download!","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":1030,"url":"https:\/\/www.hackingsap.com\/blog\/5-xcelsius-scdd-sap-crystal-dashboard-design-tips-to-start-2011-right","url_meta":{"origin":459,"position":3},"title":"5 Xcelsius tips to start 2011 right!","author":"Xavier Hacking","date":"December 31, 2010","format":false,"excerpt":"Let's kick off 2011 with some Xcelsius (SAP Crystal Dashboard Design) tips which may help you during the development of some cool Xcelsius dashboards.","rel":"","context":"In "SAP BusinessObjects Dashboards"","block_context":{"text":"SAP BusinessObjects Dashboards","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects-dashboards"},"img":{"alt_text":"Xcelsius SAP Crystal Dashboard Design Object Browser","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/objectbrowser-300x132.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1062,"url":"https:\/\/www.hackingsap.com\/blog\/xcelsius-2011-bi4-sap-crystal-dashboard-design-direct-query-binding","url_meta":{"origin":459,"position":4},"title":"Xcelsius 2011: Direct query binding","author":"Xavier Hacking","date":"January 10, 2011","format":false,"excerpt":"A first impression of the Direct query binding feature of the upcoming Xcelsius release.","rel":"","context":"In "SAP BusinessObjects Dashboards"","block_context":{"text":"SAP BusinessObjects Dashboards","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects-dashboards"},"img":{"alt_text":"Xcelsius 2011 - Query Browser","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/xcelsius2011-1.png?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":459,"position":5},"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":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/459","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=459"}],"version-history":[{"count":31,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/459\/revisions"}],"predecessor-version":[{"id":481,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/459\/revisions\/481"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}