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

What do you mean by inmon?

651


What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

533


Explain scan md?

570


How can users design dashboards quickly and without programming experience or training?

523


Compare dataset and fileset?

568






What is a implicit attribute in microstrategy?

1137


Explain static reports?

540


What are the types of facts in microstrategy?

616


Explain factless facts?

567


Explain fact table?

639


What is level prompt?

529


While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

522


What is the command manager?

573


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

499


Can the administrator easily maintain and manage microstrategy intelligence server?

547