Enhance Basic Analysis Layout Template with Lumira Style Lasso - Part 2

[uladzislau_pralat]

    In first part of the blog I explained how Basic Analysis Layout Template can be enhanced with Lumira Style Lasso using out the box capabilities. Now I will go over BIAL scripts in details.

    lasso_store_selection

    This script is run on CHART On Select event to stored selection. In particular:

• Number of selected members is counted (measures are excluded);
• DS_2 is filtered to include only CHART selection;
• DS_3 is filtered to exclude CHART selection;
• Lasso popup is shown if at least dimension member is selected.

var selection = 0;

// count

DS_1.getDimensions(Axis.ROWS).forEach(function(element, index) {

      if(!element.isMeasuresDimension) {

            if(CHART.getSelectedMember(element.name).externalKey!='') {

                  CHART.getSelectedMembers(element.name).forEach(function(element1, index) {

                        selection = selection + 1;               

                  } );

            }

      }

} );

DS_1.getDimensions(Axis.COLUMNS).forEach(function(element, index) {

      if(!element.isMeasuresDimension) {

            if(CHART.getSelectedMember(element.name).externalKey!='') {

                  CHART.getSelectedMembers(element.name).forEach(function(element1, index) {

                        selection = selection + 1;               

                  } );

            }

      }

} );

//count

// filter

var new_filter = '';

DS_1.getDimensions(Axis.ROWS).forEach(function(element, index) {

      if(CHART.getSelectedMember(element.name).externalKey!='') {

            if(!element.isMeasuresDimension) {

                  DS_2.clearFilter(element.name);

                  DS_2.setFilter(element.name, CHART.getSelectedMembers(element.name));

            }

      }

} );

DS_1.getDimensions(Axis.COLUMNS).forEach(function(element, index) {

      if(CHART.getSelectedMember(element.name).externalKey!='') {

            if(!element.isMeasuresDimension) {

                  DS_2.clearFilter(element.name);

                  DS_2.setFilter(element.name, CHART.getSelectedMembers(element.name));

            }

      }

} );

// filter

// exclude

var  filter_val = '';

DS_1.getDimensions(Axis.ROWS).forEach(function(element, index) {

      if(!element.isMeasuresDimension) {

            if(CHART.getSelectedMember(element.name).externalKey!='') {

                  filter_val = DS_1.getFilterExt(element.name); 

                  CHART.getSelectedMembers(element.name).forEach(function(element1, index) {

                      if (filter_val=='') {

                        filter_val = '!' + element1.externalKey;

                      }

                    else {     

                        filter_val = filter_val + ';!' + element1.externalKey;

                    }

                  } );

                DS_3.setFilterExt(element.name, filter_val);           

                  }

            }

} );

DS_1.getDimensions(Axis.COLUMNS).forEach(function(element, index) {

      if(!element.isMeasuresDimension) {

            if(CHART.getSelectedMember(element.name).externalKey!='') {

                  filter_val = DS_1.getFilterExt(element.name);

                  CHART.getSelectedMembers(element.name).forEach(function(element1, index) {

                      if (filter_val=='') {

                        filter_val = '!' + element1.externalKey;

                      }

                    else {     

                        filter_val = filter_val + ';!' + element1.externalKey;

                    }

                  } );

                DS_3.setFilterExt(element.name, filter_val);           

                  }

            }

} );

// exclude

// popup

CHART.clearSelection();

if (selection > 0) {

      POPUP_LASSO.show();   

}

// popup

    lasso_filter

    This script is run on Filter Icon / Text On Click event to filter DS_1 to include only CHART selection. In particular:

• For each dimension DS_2 filter is copied to DS_1;
• Lasso popup is hidden.

DS_1.getDimensions(Axis.ROWS).forEach(function(element, index) {

      if(!element.isMeasuresDimension) {

            DS_1.setFilterExt(element.name, DS_2.getFilterExt(element.name));

      }

});

DS_1.getDimensions(Axis.COLUMNS).forEach(function(element, index) {

      if(!element.isMeasuresDimension) {

            DS_1.setFilterExt(element.name, DS_2.getFilterExt(element.name));

      }

});

POPUP_LASSO.hide();

    lasso_exclude

    This script is run on Filter Icon / Text On Click event to filter DS_1 to exclude CHART selection. In particular:

• For each dimension DS_3 filter is copied to DS_1;
• Lasso popup is hidden.

DS_1.getDimensions(Axis.ROWS).forEach(function(element, index) {

      if (!element.isMeasuresDimension) {

            DS_1.setFilterExt(element.name, DS_3.getFilterExt(element.name));

      }

});

DS_1.getDimensions(Axis.COLUMNS).forEach(function(element, index) {

      if (!element.isMeasuresDimension) {

            DS_1.setFilterExt(element.name, DS_3.getFilterExt(element.name));

      }

});

POPUP_LASSO.hide();

  In third of the blog, I will focus on Undo Previous Step command issue with Lasso and how to resolve it.

  Attached is an exported model (unpack and change extension to zip prior to importing)