In Microstrategy, how can you direct the sql generated to
use a specifc table?
- 5 Answers
- 11650 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 specific features and functionality do I get with olap services?
What is the difference between absolute filtering and standard filtering in microstrategy?
What are configuration objects?
How to use value prompt and drag it on to report editor
How would you configure wh authentication?
Describe implicit attribute?
Explain attribute role?
How do you achieve schema object version control?
1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?
What is rank metrics in microstrategy?
Is it possible to see the data in dataset?
What do you mean by inmon?
Teradata 
