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

How do we resolve attribute roles in microstrategy?

677


What is the conflict resolution window?

589


What is the difference between absolute filtering and standard filtering in microstrategy?

560


What is the effect of dls on microstrategy?

525


what are passthrough functions?

496






Can reports be executed in off-peak periods?

583


What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

562


Your i-sever crashed. What will you do?

643


Explain the difference between rolap and molap?

545


What do you mean by mstr?

590


What do you mean by mstr? What are the different types of mstr objects?

569


what specific features and functionality do you get with olap services?

542


What do you mean by bulk export report?

552


What is a logical size of a table and what does it depend on?

536


Write the components microstrategy metadata?

574