In Microstrategy, how can you direct the sql generated to
use a specifc table?
- 5 Answers
- 11323 Views
- I also Faced
- E-Mail Answers
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 |
What are the benefits of using microstrategy intelligence server?
How do you optimize reports in microstartegy?
Explain the difference between holap and molap?
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.
What are the types of facts in microstrategy?
Explain fact degradation?
Is it possible to see the data in dataset?
What do you mean by consolidations?
can metadata be manually edited? If yes, how?
How we can decided drilling options for an attribute?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?
# how to increase logical sige of a table in microstrategy
Teradata 
