In Microstrategy, how can you direct the sql generated to
use a specifc table?
Answer Posted / preeja
if it is required for metric to calculate from a particular
table in report, you can try changing the "level" in the
merics.
or by using relationship filter also can direct to a
particular table ,based on the requirement.
modifying the logical table size is a good idea, but it can
affect all reports which depends on the attributes defined
on the same table.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is level prompt?
Explain fact?
Explain heterogeneous mapping?
What do you mean by consolidations?
Explain about compound key?
Write different kinds of objects in microstrategy?
what is microstrategy narrowcast server?
What is scanmd and md doctor?
what are passthrough functions?
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
What is purpose of having conditionality in metrics in microstrategy?
what is the difference between microstrategy and cognos?
What is the difference between microstrategy and cognos reporting tool?
What is a compound attribute in microstrategy?
How conflicts occur and what are the ways to resolve them?