In Microstrategy, how can you direct the sql generated to
use a specifc table?
Answer Posted / 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 |
Post New Answer View All Answers
Explain transformations?
Explain fact?
1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?
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
Explain fact structure?
Explain three-tier connection?
Explain fact degradation?
what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?
What are the different formatting types?
What is static prompt in microstrategy?
Can you create an event based schedule in microstrategy? How?
Can microstrategy desktop access sap data?
What is microstrategy intelligence server?
How are microstrategy reports performance tuned?
What are report filters and view filters?