In Microstrategy, how can you direct the sql generated to
use a specifc table?
Answers were Sorted based on User's Feedback
Answer / ashok
In Metrics Editor Goto->Dimensionality->add attribute as Target and keep Grouping and Filtering as NONE.
This is the way to point a metric to use particula table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / radhakrishna kvnr
This can be acheived by decreasing the logical size of the
desire table in a such a way that it should be less than
other tables. AS Microstrategy will look the tale having
the least logical size and will make a join with that table.
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / 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 |
Answer / guest
Using the Level parameter in the Metric level options
| Is This Answer Correct ? | 1 Yes | 3 No |
What is pass through metrics in microstrategy?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
What is a implicit attribute in microstrategy?
you are required to disable webusers to use only one i-server. How would you do that?
I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor.
Which of the end-user items leverage olap services?
Difference between project merge and object manager in microstrategy?
Explain batch?
what do you mean by security filter?
Describe implicit attribute?
What is microstrategy desktop?
What according to you are the roles and responsibilities of a microstrategy developer?.