Skip to Content

What is the value of setting up cascading filters in SAP BusinessObjects Design Studio ?  If you are navigating a lot of data on the iPad it would help to filter it.

I watched the SAP video Design Studio 1.0: Set up a Cascading Filter in an Application and thought I would give it a try myself.  I ended up adding one more step at the end – see below.

First I create my own application, with a cross tab and chart.  I added two dropdown boxes, as the video shows.  At the start up event I include the code (using the Wizard) to fill up the project text and work breakdown structure (WBS) text. 

/wp-content/uploads/2012/12/1event_170387.jpg

In my application, instead of filtering by country > region I will filter by project > WBS.  A several WBS elements make up a project.

/wp-content/uploads/2012/12/2script_170388.jpg

The above script was created using the content assistance.

/wp-content/uploads/2012/12/3dropdown_170389.jpg

On the first dropdown (projects) I added script to get the value from the Project info object and then to select the project’s related WBS members

/wp-content/uploads/2012/12/fixscript_170390.jpg

On the second dropdown (WBS) I get the selected value of the WBS – note this was not part of the video.

/wp-content/uploads/2012/12/fx2_170392.jpg

Here is how the application looks on the iPad:

/wp-content/uploads/2012/12/6fix_170394.jpg

The screen shot above is looking at the first dropdown (projects)

/wp-content/uploads/2012/12/7fix_170396.png

In the above I’ve selected the PM project and the crosstab and the chart have filtered to only the PM project.

/wp-content/uploads/2012/12/8fix_170398.png

The above is filtering on WBS element

So on the iPad you can have the Design Studio application send all the projects, and then let the project manager filter what project they need, and even down to the WBS level.

Check out the other videos available at sap.com/learnbi

I am sure we will hear more about Design Studio at BI2013

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply