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
Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.
What is a implicit attribute in microstrategy?
What is metadata in microstrategy?
Write different kinds of objects in microstrategy?
What is purpose of having conditionality in metrics in microstrategy?
Explain fact?
what do you mean by security filter?
What do you mean by bulk export report?
What is static prompt in microstrategy?
What is microstrategy desktop?
What is a logical size of a table and what does it depend on?
Explain compound key?
how do you create schema objects in 2 tier connection?
Explain factless facts?
Explain microstrategy logical primary keys?