Skip to Content
Author's profile photo Muralikrishnan Ethiraj

Traffic Controller with SAP Design Studio on HANA…(designed for fun)

Hi Everyone,

After few busy days,today i got a chance to put my hands again on SAP BO Design Studio and this is what i did during this time which i would like to share with you.

Lets consider the scenario,where few people are heading to different cities and got struck in a same Traffic Signal which is kind of gateway to all these cities.There is a Traffic controller who has to streamline the flow of traffic which can be done with the help of Design Studio.

The list of people who are heading to different cities are as follows:


This data has been modeled using SAP HANA Studio as an Analytical View to consume in Design Studio.

In Design Studio,place Chart,Dropdown and Images(to place the traffic signals) and then assign the Data Source to Chart.Now assign the “Heading_To” attribute values to a dropdown.

Write the following script, in the “On Select” of dropdown


In “On Startup”


In the “On Select” of Chart,write the “if” condition to show the traffic signals accordingly,something like


Now Execute the report

In the executed Dashboard,Select the Target City(Heading To)…say “Heidelberg”.The Drivers belong to this city are shown in the chart and the Traffic signal is blank now




If you see the list of Driver’s here in the chart, “Angela” has to travel longer distance to reach the destination in Heidelberg who has to be given the first preference and “Anne” is second according to distance, in the list and can get the second preference.”Michelle” and “Barbara” can wait for some more time.

Click on “Angela” and observe the Traffic Signal and now its green,so she can proceed


Click “Anne” and its yellow so she can be ready to proceed


Click “Michelle” or “Barbara”.The signal turns to be red for them


If we have some additional features in terms of components,visualisation and scripting functions,we can design much impressive and usefull reports with the help of Design Studio.I hope this will happen in near future.

This is created just for fun.Happy reading it !


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Murali,


      Thanks for the demo, I'll be following intently to see any new ideas you come up with soon.


      In the mean-time I understand the design studio should facilitate designers to use a single underlying 'fat' query for all dashboards (on a given data source).the word on the grapevine is that this will perform even with vast datasets where Dashboards would have crumbled. Have you any experience on the performance side with large data sets yet?


      I'm interested to know if it is really best practice to use a single BEx query underlying dashboards as opposed to a series of queries which cut back on data volumes.




      Author's profile photo Muralikrishnan E
      Muralikrishnan E
      Blog Post Author

      Hi Bridie,

      I even tried with large data volumes(as HANA Calc View as Source and not BEx Query),and we need to accept that there are some performance issues.But it again depends on how we modeled the query before accessing in Design Studio.

      I think if we modeled a query with the recommended best practices,using single query or series of query would not make big difference.