Interested to Buy Any Domain ? << Click Here >> for more details...
In Microstrategy, how can you direct the sql generated to
use a specifc table?
- 7 Answers
- 21972 Views
- Lanco, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
Answer / sreenivasa rao
Using force fact only can hit a particulat table
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi..every one please tel me the answer for my question, how many project sources we can create in Metadata?
At which levels you can set the vldb properties? Which level has the highest pecedence?
How long does it take to get microstrategy desktop up and running?
How do you achieve schema object version control?
Explain security filter?
What is derived metric?
What is heterogeneous mapping?
What are prompted filters?
What do you mean by static prompt report?
hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com
What is level prompt?
A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
Teradata 
