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

Answer Posted / andy

Assuming you have OLAP licence,the easiest way to direct to
a particular table is to create a dummy fact on the
table,include the fact in metric and put the metric in
report objects.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How conflicts occur and what are the ways to resolve them?

700


What is microstrategy desktop?

780


what is a security filter?

735


What is fact extension?

767


What are the vldb properties? Which level of vldb configurations have the highest precedence?

716


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

763


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

782


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

734


What is a dw? Why do we need it?

695


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

715


What are objects?

743


hi,can you please share with me about,what is reportlimit,report order and how can create and use

4896


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

754


Explain clustering?

692


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

671