Microstrategy Interview Questions - part 8

  1. What is the difference between RW document and HTML document?
  2. What’s smart metric?
  3. What is a bridge/relationship table?
  4. How will you resolve double counting in M-M relationship between two attributes?
  5.  What is a CUBE?
  6. What are differences between View Filter and Report Filter?
  7. What are the different types of Filters available? Explain each with example.
  8. What is derived metrics? Explain the example from your project.
  9. What are Prompted Filters or cascaded prompts?
  10. How will you customize the display for Null Values?
  11. Can you enable/disable the thresholds based on some condition/prompt answers?
  12. In a Document, there are 5 reports and 5 out of them need to have a prompt so that 10 user can select first day of the week for which user want to execute the report. How many prompts would be required to bemade?
  13. What’s XML Cache?
  14. What’s a Bulk export report?
  15. Can you have a prompt in free form SQL report?
  16. What will happen when the network connection between the webserver and one of the clustered I-server is lost? Will report run smoothly?
  17. Can you prioritize report execution?