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?
Submitted by: Administrator
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.
Submitted by: Administrator
we can create a separate table with specific columns we need to use(i.e .a more appropriate table using table alias)
Submitted by: Anasuya
Read Online Data Warehouses MicroStrategy Job Interview Questions And Answers
