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


Please Help Members By Posting Answers For Below Questions

What is the difference between absolute filtering and standard filtering in microstrategy?

733


How are microstrategy reports performance tuned?

709


what do you mean by kimball?

727


What do you mean by static prompt report?

734


Imagine this, you are required to reset the password for all users at a time. How would you do that?

730






Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

646


How conflicts occur and what are the ways to resolve them?

695


differentiate between two-tier, three-tier and four-tier connections.

724


what do you mean by security filter?

732


What is a joint child?

695


What are intelligent cubes?

756


What is the command manager?

725


What according to you are the roles and responsibilities of a microstrategy developer?.

779


What is purpose of having conditionality in metrics in microstrategy?

749


According to you, what are the most important tables in a dw? Why?

730