In Microstrategy, how can you direct the sql generated to
use a specifc table?

Answer Posted / kanchan

In addition to above answers, you can force a fact to take
data from the required table only

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is percent-to-total shortcut metric in microstrategy?

548


How would you configure wh authentication? Explain.

536


What is the difference between absolute filtering and standard filtering in microstrategy?

579


What is level prompt?

539


What does microstrategy intelligence server allow users to do?

526






What are pass-through functions and why they are so called? Give some examples.

580


Explain fact constellation schema?

579


Explain the Roles in mstr?

552


How will you monitor the errors received while running i-server and report?

522


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?

2163


Explain heterogeneous mapping?

562


Explain snowflake schema?

589


What is transformation metric in microstrategy?

590


What are vldb properties?

553


What is fact degradation?

578