KB249194: How to disable drilling on Row and Column Header in MicroStrategy Web

Summary

An administrator may want to disable drilling on Row and Column header programmatically. This can be done using Strategy Web SDK.
Before customization:

After customization:

Follow these steps to achieve this customization:

• In the Web Customization Editor (WCE), create a new java class that extends the ReportCellDrill class and called it NoRowHeaderDrillReportCellDrill
• Add a default constructor and override the method getComposedContextMenuBuilder as shown below:
  

  
   public NoRowHeaderDrillReportCellDrill(Shortcut definition) {
          super(definition);
          // TODO Auto-generated constructor stub
      }
  
      @Override
      protected ComposedContextMenuBuilder getComposedContextMenuBuilder(
              TransformContext context) {
          Object obj = null; 
          if((getCell(context) instanceof ReportGridCellRowTitle) || (getCell(context) instanceof ReportGridCellColTitle)) 
          { 
              obj = new InvalidDrillContextMenuBuilder((com.Strategy.web.app.transforms.ReportGridDisplayCell.Context)context);
              return ((ComposedContextMenuBuilder) (obj)); 
          } 
          else 
              return ((ComposedContextMenuBuilder) (super.getComposedContextMenuBuilder(context)));
      }

  
  
• In the WCE, go to Strategy Web Configuration > Context Menus > reportCellContextMenus > default and double-click drillGrid(Drill) to open it in the editor as shown below:
  

• Go to Advance Properties > Builder ClassName and put in the path to the class created from (1) e.g. com.Strategy.transform.NoRowHeaderDrillReportCellDrill as shown below:
  

• Restart the application server