MSTR interview questions list

Here are some interview question on Microstrategy ... Some are common but some are tricky but important

1. Can we use prompts in cubes?
2. Can we create cubes based on free form sql?
3. when report and database give different result form same sql what does it imply?
4. Difference between Report Limit and Metric Qualification
5. What is a value prompt?
6. When a report has 2 metrics each from different fact table how will the sql be? If it has sub queries then how to avoid it?
7. How can one ensure that a fact table is included in a report?
8. When a report having data at customer, date, payment id  and amount giving correct result. But when payment id is removed from grid, the metric values become – what could be the reason? And how to resolve it?
9. What factors need to be considered when adding new tables to Microstrategy?
10. Explain Performance tuning for Dashboard
11. How to configure multiple data sources for a cube?
12. Difference between Logical view and Logical Table?
13. What is a joint child?
14. What need to be considered when creating a project based on star schema in MSTR?
15. How dashboard combines data from different datasets?
16. How referential integrity can be achieved?
17. What is complex report/dashboard you have created and how you solved the complexity?