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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can reports be executed in off-peak periods?

666


According to you, what are the most important tables in a dw? Why?

642


What is adaptive metric?

626


Explain the difference between rolap and molap?

633


What is level metrics in microstrategy?

645






What according to you are the roles and responsibilities of a microstrategy developer?.

700


Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

709


Can I access intelligent cubes without olap services?

652


What is microstrategy intelligence server?

652


What is a joint child?

617


what do you mean by passthrough functions?

630


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

604


To save time, can many reports be run at the same time?

678


Explain clustering?

609


What do you mean by staging area?

601