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 do you mean by trimming sql in microstrategy?
What do you mean by dimensional modeling and relational modeling?
What are the various ways of incorporating security in microstrategy?
what are passthrough functions?
What is a dw? Why do we need it?
What is non-aggregate metric?
What are objects?
How does microstrategy object manager determine if two projects are related?
Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.
Explain microstrategy logical primary keys?
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
What subtotaling features does microstrategy desktop contain?
Explain security filter?
what is the difference between the report filter and report limit?
What are report caches and how many types are there?