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 !