allow to customize the SQL that Microstrategy generates

they can be applied at DB level, report level and metric levels

help to improve the performance of the report

All of the above