Skip to Content

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:

Capture_1.JPG

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

Capture_3.JPG

In “On Startup”

Capture_9.JPG

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

Capture_4.JPG

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

Capture_5.JPG

Capture_6.JPG

 

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

Capture_2.JPG

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

Capture_7.JPG

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

Capture_8.JPG

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 !

Rgds,Murali

To report this post you need to login first.

2 Comments

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

  1. Bridie Stevens

    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.

     

    Thanks,

    Bridie

    (0) 
    1. Muralikrishnan E 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.

       

      Rgds,Murali

      (0) 

Leave a Reply