Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

More Micro Strategy Interview Questions

What is pass through metrics in microstrategy?

0 Answers  


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

0 Answers  


What is a implicit attribute in microstrategy?

0 Answers  


you are required to disable webusers to use only one i-server. How would you do that?

0 Answers  


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.

6 Answers   Target, TCS,


Which of the end-user items leverage olap services?

0 Answers  


Difference between project merge and object manager in microstrategy?

0 Answers  


Explain batch?

0 Answers  


what do you mean by security filter?

0 Answers  


Describe implicit attribute?

0 Answers  


What is microstrategy desktop?

0 Answers  


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

0 Answers  


Categories