Reverse Lasso in SAP BusinessObjects Design Studio

Lasso Selection capability is a powerful feature that comes with SAP BusinessObjects Design Studio. Using the Lasso selection functionality allows you to select a particular chart area and zoom into it. For more information on creating a lasso selection, click here.

In this blog we will discuss the merits of reverse lasso functionality. Reverse lasso is unique because allows you to remove a particular selection from the chart. This is useful when the user wishes to see only particular KPIs on the chart during runtime.

Since we are selecting multiple members on the chart, it is mandatory to set the “Selection Mode” for the chart under the “Additional Properties” panel to “Inclusive”. This setting will let you select multiple series on the Chart.

Reverse Lasso in SAP BusinessObjects Design Studio

The reverse lasso feature is also very effective and flexible because it can be incorporated into any chart. Reverse lasso functionality can be achieved by excluding the selection and then passing it as a filter to the data source.

This can be achieved in pie charts as well.

To incorporate the reverse lasso feature, you would require a simple script:

 var c=””;
 b=c+a;          
 c=b;
 var st=””;
 var array=CHART1.getSelectedMembers(“ZREGION”);
 array.forEach(function(element, index) {
 st=”!”+element.internalKey;
 c=c+st+”;”});
 a=c;
 DS_1.setFilterExt(“ZREGION”,c);

In the above script, a and b are global variables and are initialized with null values.

A ‘CLEAR SELECTION’ button is also added to clear the reverse lasso selection. On clicking this button, the filter is also cleared and the global variables are also set to null values. The script on the button is as follows:

 a="";
 b="";
 DS_1.clearFilter("ZREGION");

In a scatter plot, the reverse lasso feature works in a similar fashion. Sometimes a Scatter plot may get crowded at a particular point. This feature allows the user to declutter the cluttered part for better clarity. In the following image, reverse lasso selection is applied to a crowded part in a Scatter plot.