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

Categories >> Software >> Data Warehouse >> Micro Strategy
Suggest New Category

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

Question Posted / guest

5 Answers
12727 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

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

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

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

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

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

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

Answer / guest

Using the Level parameter in the Metric level options

Is This Answer Correct ?

1 Yes

3 No

Post New Answer