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?
Is olap services sold as a separate product?
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?
What are objects?
What are objects? Name different type of objects in microstrategy?
what are the different types of fact structures?
Explain microstrategy logical primary keys?
How would you configure wh authentication? Explain.
Explain standard filters?
What is a implicit attribute in microstrategy?
What is the difference in the way microstrategy handles custom group and consolidations?
Explain four-tier connection?
What is microstrategy intelligence server?
Can you create an event based schedule in microstrategy? How?
What are level metrics? Why are they needed?