Skip to Content
Author's profile photo Tammy Powlas

Week 3 Open SAP BI Clients – all about Design Studio – Dynamic Visibility, Scripting

Last week was all about Lumira – see Experiencing Week 2 OpenSAP SAP BI Clients Course and this week it is all about Design Studio.

I confess, I spent most of today doing the actual exercises on the SAP Cloud Appliance Library (CAL)  or SAP HANA Enterprise Cloud / Cloud Appliance Library

There was so much covered and so much to learn.  If you are interested in learning about Design Studio, I encourage you to enroll in the course BI Clients and Applications on SAP HANA – James Rapp, Foroohar Rafiei and Harjeet Judge

In the first exercise you create a calculation view in HANA using SQL Script to obtain the ranking.  I had no issue initially doing this.


However, I followed the exercises completely and managed to get my HANA account locked out for 24 hours when trying to access the HANA calc view through the BI Platform.  I saw several posts here on SCN how to fix that, but I couldn’t follow it.

I ended up terminating my CAL instance and spinning up a new instance, and re-doing exercise 1 again, but with a change; I logged on to the CMC first to change the password on the OLAP HANA connection and then proceeded to Design Studio on the BI Platform.  To avoid my mistake, I recommend you do this.


One thing you do during the exercises is change the CSS colors using HEX.  First my tree map wasn’t displaying any values; I closed Design Studio and re-opened it and it seemed to be working again (a relief)


In the above the three graphs all point to EMEA but to get through the exercises and concepts I let them be EMEA, America and APJ.

Just as I am wiped out from all the exercises, the next exercise shows us how to incorporate the UI5 controls (the Up arrow) in Design Studio – see Icon Explorer


In the exercises James Rapp praises Mike Howles for Design Studio 1.2/1.3 SDK – Design Studio Utility Pack and his SCN contributions and Design Studio 1.2/1.3 – SAP Fonts Usage for Icons which we actually do in one of the exercises.


There is a whole exercise on scripting, which is really cutting and pasting from the Adobe exercise file; in the “I like I wish” I need to remember to suggest having the scripts on the CAL instance for easier cutting and pasting.


In the last exercise, we learn how to do dynamic visibility in Design Studio as shown above.


The final part of the exercise is adding a profiling parameter at the end of your application to check performance as shown above.

I still feel I have more to learn but this week I learned a great deal about Design Studio and HANA SQL Scripting.  You can still sign up for the course at BI Clients and Applications on SAP HANA

Although not covered in the exercises, SDK’s are reviewed, with a great deal of praise to the SCN contributors.

Assigned Tags

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

      Great post Tammy.  I also learned a lot about Design Studio this week.  The way I overcame the copy/paste issue was to login to OpenSAP from my AWS session and download the exercise files there.


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Tom - I did that too, but still, the copy paste from Adobe looked very strange. Ideally they would be there in text files so we can copy and paste from Notepad.

      Author's profile photo Former Member
      Former Member

      Yes, I did have reformat them.  It probably would have worked without the reformatting but that made it easier for me to matchup with what was in the pdf.  And I agree, text files would make it much easier.  I can see though that there may be times when people would get confused and use the wrong text file.  The way it is in the pdf makes it easy to put it in exactly the correct place.

      Author's profile photo James Rapp
      James Rapp

      Hi Tammy,

      Thanks so much for the post. My apologies regarding the locking of your HANA account. I will have to republish the master image with that policy disabled.

      If you encounter it again, the solution is here:

      Finally, with regards to the scripting exercise, there were 9 distinct scripts and I was concerned that it might get confusing unless they were managed from a central document. Your point is well taken regarding text files on the machine though. I'll take that feedback and modify the content before the course runs again.