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 the difference between absolute filtering and standard filtering in microstrategy?
How are microstrategy reports performance tuned?
what do you mean by kimball?
What do you mean by static prompt report?
Imagine this, you are required to reset the password for all users at a time. How would you do that?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
How conflicts occur and what are the ways to resolve them?
differentiate between two-tier, three-tier and four-tier connections.
what do you mean by security filter?
What is a joint child?
What are intelligent cubes?
What is the command manager?
What according to you are the roles and responsibilities of a microstrategy developer?.
What is purpose of having conditionality in metrics in microstrategy?
According to you, what are the most important tables in a dw? Why?