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
What is fact extension?
Explain security role?
If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?
What do you mean by static prompt report?
what is the difference between the report filter and report limit?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
Explain the Roles in mstr?
explain html document?
What are vldb properties?
Explain the difference between rolap and molap?
What are the different types of metrics available in microstrategy?
what are the different authentication modes available in microstrategy?
What is smart metric?
Explain attribute?
Compare dataset and fileset?