One of the most powerful Lumira analysis feature is lasso. This feature allows quickly filter or exclude chart data and focus analysis on specific area. Unfortunately this feature is missing in Design Studio. There are blogs that explain how to implement lasso in Design Studio:
Lasso selection in Design Studio Charts, Reverse Lasso in SAP BusinessObjects Design Studio. What I did not like about aforesaid implementations is:
- Separate modeling of filter and exclude functionality;
- Necessity to clear chart selection with the help of a button or click;
- Dimension hardcoding.
What I was looking for is “true Lumira style lasso” which has both filter and exclude functionality, simple and intuitive user interface. So I came up with my own Design Studio implementation of Lumira style lasso.
I enhanced Basic Analysis Layout Template
I added a number of things to the template. First of all added lasso_store_selection script to CHART On Select event to stored selection:
Then added POPUP_LASSO popup with lasso_filter and lasso_exclude scripts respectively assigned to filter and exclude icons/texts:
Then added LASSO_FUNCTIONS global script object
Finally added two more Data Sources: DS_2 and DS_3. They are needed to store selection (filter and exclude respectively) because CHAR selection is cleared before decision making POPUP_LASSO popup is shown.
It is not a big overhead to have two more Data Sources since they are on total data only without any drill down.
Now lets see the model in action. I use Analysis application to display Total Seats Occupied and Total Seats Occupied – Business Class Measures by Carrier using Scatter Chart. Using lasso I select 4 carrier with highest number of Total Seats Occupied
On lasso popup I choose Filter
Data is filtered to 4 selected carriers and filter line reflects that.
Now lets exclude SQ Carrier with lowest Seats Occupied. First selecting it with a lasso.
And then choosing exclude on lasso popup.
As you can see SQ Carrier was excluded and filter line reflects that
In second part of my blog I well go over BIAL script that implements Lumira Style Lasso functionality.
Attached is an exported model (unpack and change extension to zip prior to importing).