Skip to Content

Part 1 of this blog can be found here – note you can still apply for Beta program until September 14.  Please see this link to apply.

Since the new release of Zen, aka BusinessObjects Design Studio, the first complaint was ” you mean I need to type in all the values when I do a dropdown against master data”? 

Meaning you had to type in the key and text for any drop down values:

/wp-content/uploads/2012/08/1fig_128643.png

Figure 1

Figure 1 shows where we had to manually type in each key and text data for any drop down.

With the latest release, this issue goes away.  A tip is to use the CTRL-Space feature in the editor.

/wp-content/uploads/2012/08/2fig_128644.png

Figure 2

Figure 2 shows a crosstab and the chart and a dropdown.  I’ve already included the BEx query as a data source.

/wp-content/uploads/2012/08/3fig_128651.png

Figure 3

First go on the Properties of the application, to the On Startup of Events

This is the script to put in:

DROPDOWN_1.setItems(DS_1.getMemberList(“ZPROJ”, “KEY”, “TEXT”, 4,“ALL”));

In JavaScript-like terms, it is getting the members of ZPROJ info object, key and text, with maximum 4 rows to display, with “ALL” being the default.

Note that I did not have to type this in manually but simply use the CRTL-Space wizard that walked me through the steps. 

/wp-content/uploads/2012/08/4fig_128652.png

Figure 4

For the properties of the Dropdown box, you can use the JavaScript wizard to walk you through the code for the On Select event:

/wp-content/uploads/2012/08/5fig_128653.png

Figure 5

Figure 5 shows you can activate content assistance (which is what I did) by pressing Ctrl + Space

Figure 5 represents the code for the On Select event – so on select info object ZPROJ get selected value.

/wp-content/uploads/2012/08/6fig_128654.png

Figure 6

Figure 6 shows how it operates in run-time (desktop or iPad) with showing 4 as maximum, default to all

/wp-content/uploads/2012/08/7fig_128655.png

Figure 7

Figure 7 shows the runtime – when I filtered on Distribution, it displays only the Distribution results.

So far in my SAP BusinessObjects Design Studio beta experiences I have not personally coded – I have used the wizard.

To report this post you need to login first.

5 Comments

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

  1. Nikhil Joy

    From the fig. 2, it seems  number of components are less compared to dashboard design or it is displaying only selected components? do we have the option of using wide variety of components like in dashboard?

    Regards,

    Nikhil Joy

    (0) 
    1. Tammy Powlas Post author

      There is more than what the screen shows.  Unfortunately I am working on a laptop these days – hopefully this does not mislead you.

      Tammy

      (0) 
      1. Niyati Shah

        Hi Tammy,

        Is it possible to populate the dropdown with values only for which we have corresponding data.

        My dropdown has counties filled in it  but some of them have no corresponding  data to showed on  the charts .

        Help needed.

        Regards

        Niyati

        (0) 
        1. Tammy Powlas Post author

          I saw your question in the discussion forum, so there is no need to cross-post here, which is against community rules.

          Please be patient – the people who help do this on their own time.

          (0) 

Leave a Reply