In Microstrategy, how can you direct the sql generated to
use a specifc table?

Answer Posted / radhakrishna kvnr

This can be acheived by decreasing the logical size of the
desire table in a such a way that it should be less than
other tables. AS Microstrategy will look the tale having
the least logical size and will make a join with that table.

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What leads to a cross-join or how does a cross-join occur?

560


Explain fact degradation?

613


What are prompted filters?

520


Can a record be inserted and updated in database using microstartegy?

536


Can reports be executed in off-peak periods?

592






What is transformation metric in microstrategy?

590


Explain two-tier connection?

529


Your i-sever crashed. What will you do?

653


Describe implicit attribute?

551


what are the different authentication modes available in microstrategy?

597


Is there a difference between view filter and report filter?

535


Can microstrategy desktop access operational data systems?

592


According to you, what are the most important tables in a dw? Why?

578


What is the difference in the way microstrategy handles custom group and consolidations?

567


Compare dataset and fileset?

582