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
What do you mean by inmon?
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?
Explain scan md?
How can users design dashboards quickly and without programming experience or training?
Compare dataset and fileset?
What is a implicit attribute in microstrategy?
Explain static reports?
What are the types of facts in microstrategy?
Explain factless facts?
Explain fact table?
What is level prompt?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
What is the command manager?
You have got the requirement from a client. Explain the technical approach you will take now.
Can the administrator easily maintain and manage microstrategy intelligence server?