I would use level metrics to force the SQL generation (remove the report level from the metric and add level on ALL the dimensions from the fact table you want to generate SQL against).  By doing this you will only affect the report that is using the metric.  If you start altering the logical table size you will affect all reports.