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
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?
Explain fact structure?
How would you get two images on microstrategy login page?
How is the number of passes in a sql query significant in performance evaluation?
What is embedded metric?
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?
Can microstrategy desktop access sap data?
Explain the Roles in mstr?
Name different type of objects in microstrategy?
How long does it take to get microstrategy desktop up and running?
what are the different types of fact structures?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
What are the tracing options available in microstrategy object manager?
Explain fact?
Is microstrategy desktop available in other languages?