Skip to Content
Author's profile photo Former Member

Ticker and URL Button-Sap Dashboard

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         2. Now add the person’s details at the end

After you refresh the browser it will look like this:


     3. Copy the URL

     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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.