In Microstrategy, how can you direct the sql generated to
use a specifc table?
- 7 Answers
- 20666 Views
- Lanco, I also Faced
- E-Mail Answers
Answer Posted / vanitha
create dummy attribute on the specific table and use that
dummy attribute as a report object then the SQL hit the
Specific table
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Does microstrategy intelligence server run on windows®, unix®, or linux®?
Can we access multiple operational databases from within a single microstrategy project?
What is microstrategy intelligence server?
Explain fact constellation schema?
How does microstrategy object manager determine if two projects are related?
What is static prompt in microstrategy?
Explain oject manager?
Explain attribute?
Explain scan md?
How to optimize a report in microstrategy environment?
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?
Describe implicit attribute?
How can you make the sql query to be based on a specific table of your choice?
What do you mean by bulk export report?
What is derived metric?
