Skip to Content

As a part of the BCO6181 ERP Applications course I got the task to create a Ticker and URL Button-Sap Dashboard and then explain how I did it in a blog post. So here we go…

Start of with registering and downloading your SAP Crystal Dashboard Design 2011, departmental edition 30-Day Evaluation, the activation code will be sent to your email.

http://www54.sap.com/solution/sme/software/analytics/crystal-dashboard-design/index.html

Now we need a data source to play with. In this tutorial I will demonstrate how to follow tweets from important people on Twitter by importing the RSS data through excel into the dashboard.

RSS (Rich Site Summary) is a group of web feed formats used to publish updated works —such as blogs, news, YouTube – in a standardized format. An RSS document contains full or summarized text, plus metadata.

To do this you will need to open a browser and find the API Feed (Google it) for twitter then add the persons account name or number in the end.

         1. For Twitter, API is https://api.twitter.com/1/statuses/user_timeline.rss?screen_name=

https://api.twitter.com/1/statuses/user_timeline.rss?screen_name         2. Now add the person’s details at the end https://api.twitter.com/1/statuses/user_timeline.rss?screen_name=c821311

After you refresh the browser it will look like this:


/wp-content/uploads/2013/06/1_225407.jpg

     3. Copy the URL https://api.twitter.com/1/statuses/user_timeline.rss?screen_name=c821311

     4. Open Excel/Data/Get External Data/From Web

/wp-content/uploads/2013/06/2_225408.jpg

    5. Paste the URL into the Address/Select Go and Import

/wp-content/uploads/2013/06/3_225409.jpg


6. Select OK to import the data

/wp-content/uploads/2013/06/1bg_225410.jpg

Data will be sorted into columns and rows.

/wp-content/uploads/2013/06/2bg_225411.jpg

    7. Save the excel sheet


    8. Open your Dashboard Designer

/wp-content/uploads/2013/06/1_225407.jpg


   9. Select from the File/New/New with Spreadsheet

/wp-content/uploads/2013/06/2_225408.jpg

        Find and select the file

/wp-content/uploads/2013/06/3_225409.jpg

   10. Select the Ticker from

          Components /Selectors/Ticker and drag it to the drawing canvas

/wp-content/uploads/2013/06/4_225415.jpg

   11. Select the URL Button from

          Components /Web Connectivity/URL Button and drag it to the drawing canvas

/wp-content/uploads/2013/06/5_225416.jpg

   12. Select the Ticker and select the labels drop down arrow to select the spreadsheet. We are selecting the values from the excel sheet that will show up on the ticker.

/wp-content/uploads/2013/06/6_225417.jpg

   13. Select the first data in the labels column (Not the Column title) drag it down and select OK

   /wp-content/uploads/2013/06/7_225418.jpg

   14. Select the Value Labels

/wp-content/uploads/2013/06/8_225419.jpg

   15. Select the first data in the Labels Value column (Not the Column title) drag it down and select OK

/wp-content/uploads/2013/06/9_225420.jpg

   16. Select the Insertion type to be Row and select the Source Data. Insertion type determines how we select the data. Data source determines what is the data and

/wp-content/uploads/2013/06/10_225421.jpg

       Destination determines where the data is stored once selected

/wp-content/uploads/2013/06/11_225422.jpg

17. Select the row beneath the entire data and select OK

/wp-content/uploads/2013/06/12_225423.jpg

   18. Select the URL Button and re-label it to display Twitter then select the field to connect the Ticker to URL Button

   /wp-content/uploads/2013/06/13_225424.jpg/wp-content/uploads/2013/06/14_225425.jpg

   19. From the toolbar select Preview

    

   20. Select any label and it will take you to the twitter page

/wp-content/uploads/2013/06/15_225427.jpg

/wp-content/uploads/2013/06/16_225428.jpg

Thank you for taking time to read my blog. You are welcome to comment and give suggestions to improve it.

Many thanks to my teacher Tony Thomasis and BCO6181 classmates @ Victoria University, Melbourne, and SAP for providing a free trial software.

“Share your knowledge. It’s a way to achieve immortality.“ Dalai Lama


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply