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

7 Answers
22037 Views
Lanco, 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 / preeja

if it is required for metric to calculate from a particular
table in report, you can try changing the "level" in the
merics.
or by using relationship filter also can direct to a
particular table ,based on the requirement.

modifying the logical table size is a good idea, but it can
affect all reports which depends on the attributes defined
on the same table.

Is This Answer Correct ?

13 Yes

0 No

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

Answer / vanitha

create dummy attribute on the specific table and use that
dummy attribute as a report object then the SQL hit the
Specific table

Is This Answer Correct ?

6 Yes

1 No

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

Answer / kwwl

By changing the Logical Size of the "specific" table. After
changing table size, you need to update schema.

Is This Answer Correct ?

4 Yes

1 No

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

Answer / kanchan

In addition to above answers, you can force a fact to take
data from the required table only

Is This Answer Correct ?

1 Yes

0 No

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

Answer / pritika

we can use alias name of that table and change the logical
size of that alias table dnt modifies main table and use the
alias table..

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sunil

Totally agree Preeja's answer...but when you have more then
one fact table and they all are hitting some other attribute
you will have take VLDB prop under consideration.

changing the logical size never recommended unless you full knowledge of architect and expertise.
It will create some problem in other reports.

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sreenivasa rao

Using force fact only can hit a particulat table

Is This Answer Correct ?

0 Yes

0 No

Post New Answer