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?
Answer:
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 Question | Next Question |
| Explain What is the difference between view filter and report filter? | What is Smart Metric? |