In Microstrategy, how can you direct the sql generated to
use a specifc table?
Answers were Sorted based on User's Feedback
Answer / ashok
In Metrics Editor Goto->Dimensionality->add attribute as Target and keep Grouping and Filtering as NONE.
This is the way to point a metric to use particula table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / radhakrishna kvnr
This can be acheived by decreasing the logical size of the
desire table in a such a way that it should be less than
other tables. AS Microstrategy will look the tale having
the least logical size and will make a join with that table.
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / antara
While defining Dimensionality (Level) of the metric mention
Target as the fact based on that specific table and set the
filtering to 'Absolute'.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / guest
Using the Level parameter in the Metric level options
Is This Answer Correct ? | 1 Yes | 3 No |
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
What do you mean by mstr? What are the different types of mstr objects?
What is rank metrics in microstrategy?
Explain security filter?
What are vldb properties?
Explain the Roles in mstr?
How are microstrategy reports performance tuned?
what are the different types of tests done on a microstrategy report?
What is microstrategy?
What are the different modes to run i-server?
what is the difference between documents and dashboards in mstr?
I want to learn Microstrategy Tool...Can you help me to find best coaching center for Microstategy..please send details to maheswari.umaece@gmail.com Thanks and Regards, Uma