Data Warehouses MicroStrategy Question:
Download Questions PDF

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.

Download Data Warehouses MicroStrategy Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is the difference between view filter and report filter?What is Smart Metric?