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

Your account is locked and your administrator has forgotten the password. What would you do?

759


Explain standard filters?

766


What are vldb properties?

759


Explain scan md?

775


What are public objects?

803


Explain fact structure?

759


How do you optimize reports in microstartegy?

822


Difference between project merge and object manager?

784


How does microstrategy object manager integrate with the microstrategy product suite security model?

716


Imagine this, you are required to reset the password for all users at a time. How would you do that?

736


Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

720


what is the difference between the report filter and report limit?

716


Can we access multiple operational databases from within a single microstrategy project?

794


You have got the requirement from a client. Explain the technical approach you will take now.

673


What is level prompt?

697