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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by consolidations?

577


What do you mean by mstr? What are the different types of mstr objects?

583


Explain true primary keys?

556


Explain standard filters?

570


What is scanmd and md doctor?

652






How does microstrategy object manager determine if two objects in different projects are the same?

584


According to you, what are the most important tables in a dw? Why?

578


What are the programs that we can do with the microstrategy architect?

573


What are public objects?

648


Explain about compound key?

592


What is the difference between absolute filtering and standard filtering?

529


If your client wanted to customize the null value, how would you do that?

541


Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

500


What are the various ways of incorporating security in microstrategy?

558


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?

2161