⟩ In Microstrategy, how can we direct the sql generated to use a specifc table? I know of using ApplySimple, but there are other ways too?
If you need to use a specific table , we need to play with the logical size of that table. Whenever MSTR frames a query it retrieves data from the table that has the least logical size and hence when you set the logical size of your table to be least compared to the other base table, MSTR will retrieve data from this specified table.