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

Answer Posted / pritika

we can use alias name of that table and change the logical
size of that alias table dnt modifies main table and use the
alias table..

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2154


Explain fact structure?

599


How would you get two images on microstrategy login page?

539


How is the number of passes in a sql query significant in performance evaluation?

533


What is embedded metric?

568






Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

594


Can microstrategy desktop access sap data?

534


Explain the Roles in mstr?

546


Name different type of objects in microstrategy?

552


How long does it take to get microstrategy desktop up and running?

557


what are the different types of fact structures?

544


You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

523


What are the tracing options available in microstrategy object manager?

576


Explain fact?

555


Is microstrategy desktop available in other languages?

600