{"id":102,"date":"2009-11-29T11:44:46","date_gmt":"2009-11-29T10:44:46","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=102"},"modified":"2011-12-18T15:02:45","modified_gmt":"2011-12-18T13:02:45","slug":"powerpoint-xcelsius-and-twitter","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/powerpoint-xcelsius-and-twitter","title":{"rendered":"Powerpoint, Xcelsius and Twitter DIY"},"content":{"rendered":"

A few weeks ago Timo Elliot<\/a> (SAP BusinessObjects) launched his free PowerPoint Twitter Tools on his SAP web 2.0 blog<\/a>. With these tools you are able to integrate Twitter in you presentations and use it i.e. to receive live feedback during your presentation.\u00a0Lots of updates and improvements have been published since then and the high number of positive comments (on Twitter) confirm what a great idea this is.<\/p>\n

A drawback of the tool is that you can\u2019t configure the layout yourself. Also there is a SAP logo on every slide plus the e-mail address of the author. I like SAP but I think it is a bad thing to stuff your slides with logo\u2019s. Also, why would your audience care?<\/p>\n

So, let\u2019s build a custom Twitter tool for PowerPoint ourselves, step-by-step.<\/p>\n

Requirements:
\n– A copy of Xcelsius Engage or Xcelsius Engage Server (get a free 30-day trial here<\/a>);
\n– MS Excel;
\n– MS Powerpoint.<\/p>\n

<\/p>\n

We can use the Twitter search API<\/a> to find out how to import the tweets via XML maps. According to this page we need the following url to receive the 10 most recent tweets about Apple:<\/p>\n

http:\/\/search.twitter.com\/search.atom?q=Apple&rpp=10<\/em><\/p>\n

Now we go to the spreadsheet area in Xcelsius to import this XML. Go to the Develop tab and choose Import. If you don\u2019t have a Developer tab, close Xcelsius and open Excel. Go to Excel Options and enable \u201cShow Developer tab in the Ribbon\u201d. Quit Excel and restart Xcelsius.<\/p>\n

\"twitter1\"<\/p>\n

Past the above url and import the data in the spreadsheet. Make sure you do not put the data in the upper cells of the spreadsheet as we need them later on, so use i.e. cell A10. Your setup should now look something like this:<\/p>\n

\"twitter2\"<\/p>\n

Actually, for our Twitter tool we will only need the following fields\/columns:
\nns1: name (Name of the author)
\nns1: uri (Link to the author profile)
\nns1: title (Tweet)
\nhref (Link to the tweet and link to the profile image of the author)<\/p>\n

Next we have to add this connection in the Data Manager. Add an Excel XML map connection and you will see that Xcelsius already recognizes the connection we just made.<\/p>\n

\"twitter3\"<\/p>\n

In the Usage tab, enable Refresh On Load and adjust Refresh Every to 1 minute. Bind the Trigger Cell to cell A2 and select “When Value Changes”.<\/p>\n

\"twitter4\"<\/p>\n

We want to be able to change the search term, so we need to make a variable of the XML Data URL in the Definition tab. Bind this field to cell A5.<\/p>\n

\"twitter5\"<\/p>\n

Go to the spreadsheet and put the following values in the cells:
\nA1: http:\/\/search.twitter.com\/search.atom?q=
\nA2: Apple
\nA3: &rpp=10
\nA5: =CONCATENATE(A1,A2,A3)<\/p>\n

I like to highlight the cells with variables yellow and the cells with Excel formulas green, just for clarity.<\/p>\n

\"twitter6\"<\/p>\n

As you can see in the spreadsheet area the data is presented in a somewhat hierarchical way, with lots of empty cells. But, when running the dashboard this actually is not the case and all cells will be filled with data. To demonstrate this you can use the Spreadsheet Table component. Bind the display data to the first 4 rows below the XML map field headers. Hit the Preview button and you\u2019ll see that the href-column gives us 2 links for each tweet, placed in 2 cells below each other. We should keep this in mind! Now delete the Spreadsheet Table component.<\/p>\n

\"twitter7\"<\/p>\n

Add an Input Text component to the canvas and bind this to cell A2. With this field the user can change the search term.<\/p>\n

\"twitter9\"<\/p>\n

Next I use the Image component to add an image of a text balloon to the canvas. Paste a label component on the text balloon and bind it to cell O11 (text of the first Tweet). Next add an URL Button component to the canvas and also place it on top of the text balloon. Bind it to cell M11 (url of the tweet). Erase the label value in the Properties pane and in the Appearance tab deselect \u201cShow Button Background\u201d.<\/p>\n

\"twitter10\"<\/p>\n

Finally we have to add the name and profile image of the tweet author. Add the Slide Show Component to the canvas and bind it to cell M12 (profile image location, always one cell below the url of the tweet, remember?).<\/p>\n

\"twitter11\"<\/p>\n

Next add another Label Component and bind it to cell V11 (author name). Now we only have to add another URL Button component and past it over the profile image. Bind it to cell W11 (url of author profile).<\/p>\n

\"twitter12\"<\/p>\n

Now it is time to test our dashboard! Hit Preview.<\/p>\n

\"twitter13\"<\/p>\n

So that\u2019s how it works. You can embed the swf-file into Powerpoint or place it wherever you want.
\nDownload the source files here<\/a> (via Pay with a Tweet). Have fun!<\/p>\n

[kml_flashembed movie=”http:\/\/hackingsap.com\/blog\/wp-content\/uploads\/twitter.swf” height=”450″ width=”600″ \/]<\/p>\n","protected":false},"excerpt":{"rendered":"

Using Twitter in Xcelsius. How does it work?<\/p>\n","protected":false},"author":1,"featured_media":172,"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,5,126,6],"tags":[287,19,20,17,105,80,286,285,18],"class_list":["post-102","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-diy","category-featured","category-sapbusinessobjects-dashboards","category-xcelsius","tag-diy","tag-excel","tag-flash","tag-powerpoint","tag-sap-crystal-dashboard-design","tag-scdd","tag-twitter","tag-xcelsius","tag-xml"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/twitter_logo.jpg","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-1E","jetpack-related-posts":[{"id":1127,"url":"https:\/\/www.hackingsap.com\/blog\/bi4-product-names-xcelsius-dashboards","url_meta":{"origin":102,"position":0},"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":[]},{"id":272,"url":"https:\/\/www.hackingsap.com\/blog\/thoughts-on-xcelsius-2008-sp3","url_meta":{"origin":102,"position":1},"title":"Thoughts on Xcelsius 2008 SP3","author":"Xavier Hacking","date":"December 16, 2009","format":false,"excerpt":"'New' features from SAP BusinessObjects.","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":1370,"url":"https:\/\/www.hackingsap.com\/blog\/sap-businessobjects-dashboards-cookbook-tweetaway-giveaway-xcelsius","url_meta":{"origin":102,"position":2},"title":"SAP BO Dashboards cookbook Tweetaway","author":"Xavier Hacking","date":"July 6, 2011","format":false,"excerpt":"Okay guys, it is time to give some stuff away. On behalf of Packt Publishing we can give away two eBook copies of the SAP BusinessObjects Dashboards cookbook we released a few weeks ago. Joining this giveaway Tweetaway is easy: Just send out a tweet with a link to the\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"Join the Tweetaway!","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/logo_twitter_withbird_1000_allblack-300x55.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3219,"url":"https:\/\/www.hackingsap.com\/blog\/sap-bi-product-name-shake-up-the-2017-edition","url_meta":{"origin":102,"position":3},"title":"SAP BI product name shake-up: the 2017 edition","author":"Xavier Hacking","date":"May 26, 2017","format":false,"excerpt":"Another year, another set of product names for our beloved SAP BI tools. Seemingly out of nowhere a list of new names were presented last week at the SAPPHIRENOW event\u00a0in Orlando FL. Even after all the name changes we had in the past 10 years ('member Xcelsius?), this still came\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/www.hackingsap.com\/blog\/category\/featured"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":877,"url":"https:\/\/www.hackingsap.com\/blog\/sap-insidetrack-videos-on-xcelsius-scdd-and-bo-explorer","url_meta":{"origin":102,"position":4},"title":"SAP InsideTrack videos on Xcelsius (SCDD) and BO Explorer","author":"Xavier Hacking","date":"October 22, 2010","format":false,"excerpt":"Watch these expert presentations on SAP Crystal Dashboard Design (Xcelsius) and the SAP BusinessObjects Explorer.","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\/SITVANLogo.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/SITVANLogo.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/SITVANLogo.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/SITVANLogo.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":444,"url":"https:\/\/www.hackingsap.com\/blog\/more-htg-from-sap-setting-up-authorization-for-xcelsius-in-sap-bw","url_meta":{"origin":102,"position":5},"title":"More HTG from SAP: Setting up authorization for Xcelsius in SAP BW","author":"Xavier Hacking","date":"March 12, 2010","format":false,"excerpt":"SAP HTG on creating authorization objects\/roles in SAP BW for Xcelsius dashboards.","rel":"","context":"In "Knowledge sharing"","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"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\/102","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=102"}],"version-history":[{"count":77,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions"}],"predecessor-version":[{"id":1554,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions\/1554"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media\/172"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}