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 |
differentiate between two-tier, three-tier and four-tier connections.
Explain standard filters?
What is fact degradation?
What are the types of facts in microstrategy?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
Name the types of transformation?
I am in chennai.I need Micro strategy ,Informatca & BO cd (not orginal)Please where get that.I really this badly. Regards, Raji
What are the vldb properties? Which level of vldb configurations have the highest precedence?
To save time, can many reports be run at the same time?
How to do performance tuning on reports.
How will you monitor the errors received while running i-server and report?
Define different types of attributes in microstrategy desktop?