In Microstrategy, how can you direct the sql generated to
use a specifc table?
Answer Posted / andy
Assuming you have OLAP licence,the easiest way to direct to
a particular table is to create a dummy fact on the
table,include the fact in metric and put the metric in
report objects.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
explain html document?
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?
what are logical views used for?
Can the administrator easily maintain and manage microstrategy intelligence server?
How would you configure wh authentication?
According to you, what are the most important tables in a dw? Why?
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?
What is a dw? Why do we need it?
What do you mean by dimensional modeling and relational modeling?
How do we resolve attribute roles in microstrategy?
what is microstrategy narrowcast server?
If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?
What is microstrategy intelligence server?
What are logical views used for in microstrategy?
Explain security filter?