Skip to Content
Author's profile photo Tammy Powlas

Fun with Filters and Templates in #SAPZen Beta Testing

We received some templates to try out in SAP Zen beta testing.  The templates help as they already have pre-built components and tabs. During initial testing, I was following this tutorial religiously, but I couldn’t get my set filters to work. I was using what the tutorial showed in the properties of Events “on select”:

     DS_1.setFilter(“0SPRMGCOM”, LISTBOX_1.getSelectedValue());

The filters would not work. Did I ask for help?  Submit a ticket?  No, I labored for hours on this.  For sure, I thought I was missing something.  Then I changed it to the following:

     DS_1.setFilterExt(“0SPRMGCOM”, LISTBOX_1.getSelectedValue());

The setFilterExt was the trick.  Success!

See my video below:

The steps I followed were to copy the templates to the templates directory, assign the BEx query as the datasource, set the properties on each of the dropdown boxes and then tested the run time.  It was pretty fast, and the templates seem to really help the testing.

I encourage others who are doing SAP Zen beta testing to share their experiences. 

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jie Deng
      Jie Deng

      Hi Tammy,

      Sorry for the confusion. This video was created before the ZEN development team made the change to script method setFilter and setFilterExt.

      In short word, you need to choose the method setFilter and setFilterExt as following:

      - If you define items in ListBox with the internal format (e.g. MEMBER/10, MEMBER/12), then you need to select the corresponding script method setFilter .

      - If you define items in ListBox with the external format ( e.g. France, Germany etc), then you need to select the corresponding script method setFilterExt .

      In your case, you defined the items in listbox with the external format, so you need to choose script method setFilterExt .

      For more detailed information and examples about these 2 script methods please refer to ZEN documentation (Open menu "Help" in Zen Studio --> help contents --> Application Designer Guide: Designing Analysis Applications --> API Reference --> Data source alias --> setFilter ).