In Microstrategy, how can you direct the sql generated to use a specifc table?
Using the Level parameter in the Metric level options
Assuming you have OLAP licence,the easiest way to direct to a particular table is to create a dummy fact on the table,include the fact in metric and put the metric in report objects.