Skip to Content

    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 ChartsReverse 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

Lasso 1.jpg

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:

Lasso 2.jpg

Then added POPUP_LASSO popup with lasso_filter and lasso_exclude scripts respectively assigned to filter and exclude icons/texts:

Lasso 3.jpg

Then added LASSO_FUNCTIONS global script object

Lasso 4.jpg

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.

Lasso 5.jpg

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

Lasso 6.jpg

On lasso popup I choose Filter

Lasso 7.jpg

Data is filtered to 4 selected carriers and filter line reflects that.

Lasso 8.jpg

Now lets exclude SQ Carrier with lowest Seats Occupied. First selecting it with a lasso.

Lasso 9.jpg

And then choosing exclude on lasso popup.

Lasso 10.jpg

As you can see SQ Carrier was excluded and filter line reflects that

Lasso 11.jpg

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).

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