|
INTERVIEW QUESTIONS
DATA WAREHOUSING
MICROSTRATEGY
DETAILS
Question: In Microstrategy, how can you direct the sql generated to use a specifc table.
I know of using ApplySimple, but there are other ways too...
Answer: If you need to use a specific table , we need to play with the logical size of that table. Whenever MSTR frames a query it retrieves data from the table that has the least logical size and hence when you set the logical size of your table to be least compared to the other base table, MSTR will retrieve data from this specified table.
|
|
|
Category |
MicroStrategy Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 7153 users |
Added on |
7/27/2011 |
Views |
69419 |
Rate it! |
|
|
Question:
In Microstrategy, how can you direct the sql generated to use a specifc table.
I know of using ApplySimple, but there are other ways too...
Answer:
If you need to use a specific table , we need to play with the logical size of that table. Whenever MSTR frames a query it retrieves data from the table that has the least logical size and hence when you set the logical size of your table to be least compared to the other base table, MSTR will retrieve data from this specified table.
Source: CoolInterview.com
Playing with the logical size of a table is not recommended always because it might affect the other reports as well, this can be done by setting filtering and grouping null in level metrics. Source: CoolInterview.com
Answered by: Alok | Date: 5/25/2016
| Contact Alok
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All MicroStrategy Interview Questions & Answers - Exam Mode /
Learning Mode
|