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.
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:
4. Open Excel/Data/Get External Data/From Web
5. Paste the URL into the Address/Select Go and Import
6. Select OK to import the data
Data will be sorted into columns and rows.
7. Save the excel sheet
8. Open your Dashboard Designer
9. Select from the File/New/New with Spreadsheet
Find and select the file
10. Select the Ticker from
Components /Selectors/Ticker and drag it to the drawing canvas
11. Select the URL Button from
Components /Web Connectivity/URL Button and drag it to the drawing canvas
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.
13. Select the first data in the labels column (Not the Column title) drag it down and select OK
14. Select the Value Labels
15. Select the first data in the Labels Value column (Not the Column title) drag it down and select OK
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
Destination determines where the data is stored once selected
17. Select the row beneath the entire data and select OK
18. Select the URL Button and re-label it to display Twitter then select the field to connect the Ticker to URL Button
19. From the toolbar select Preview
20. Select any label and it will take you to the twitter page
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