Skip to Content
Author's profile photo Uladzislau Pralat

Enhance Basic Analysis Layout Template with Lumira Style Lasso – Part 1

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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Avetis Ovakimyan
      Avetis Ovakimyan

      Thanks for the contribution, but I can't find the attached document. Is there any issue with it ?

      Author's profile photo Uladzislau Pralat
      Uladzislau Pralat
      Blog Post Author

      Hi Avetis,

      you do not need the model itself without datasources, but you can implement the solution using code snippets from part 2 of the blog.

      Regards, Uladzislau

      Author's profile photo Avetis Ovakimyan
      Avetis Ovakimyan

      Thank You !