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 - Inclusive selection mode

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.

Reverse Lasso in SAP BusinessObjects Design Studio - Column chart

 

Reverse Lasso in SAP BusinessObjects Design Studio - Column chart

This can be achieved in pie charts as well.

Reverse Lasso in SAP BusinessObjects Design Studio - Pie chart

Reverse Lasso in SAP BusinessObjects Design Studio - Pie chart

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.

Reverse Lasso in SAP BusinessObjects Design Studio - Scatter plot

Once the reverse lasso selection is applied, the cluttered part of the plot is removed.

Reverse Lasso in SAP BusinessObjects Design Studio - Scatter Plot

Lasso and reverse lasso feature can be applied to all the charts. Have fun applying this very useful feature to any chart.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com