In Microstrategy, how can you direct the sql generated to use a specifc table?
Use level metrics to force the SQL generation.
• Remove the Report Level from the metric(s)
• Add Leveling to the metric(s) for each of the Dimensions/Attributes in the Fact Table you are trying to force in the SQL
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 other reports.