Microstrategy Interview Questions – Part 4

Post Info: 1,606 views 0 Comments Post a comment

Part 4 of the common interview questions for Microstrategy BI Reporting.

  • Wat is pass thru function?
  • How to create prompt in prompt filter or cascading filter?
  • Diff between star and snowflake?
  • Wat schema does mstr support?
  • Wat is a true key?
  • Adv of using fact id on count functions?
  • Why do we need update schema?
  • Thresholds?
  • Diff between simple and compound metric?
  • how does the ordering change affect the calculation?
  • Tpes of cache?
  • Intelligent cubes?
  • Perform unit testing?
  • Latest version of mstr?
  • Diff between user and system hierarchy?
  • Wat is meta data?
  • Do you have total in page by
  • How do u create subtotals?
  • Consolidation and custom groups w.r.t query?
  • Document and dashboard?

1. Wat is pass thru function?

2. How to create prompt in prompt filter or cascading filter?

3. Diff between star and snowflake?

4. Wat schema does mstr support?

5. Wat is a true key?

6. Adv of using fact id on count functions?

7. Why do we need update schema?

8. Thresholds?

9. Diff between simple and compound metric?
how does the ordering change affect the calculation?

10. Tpes of cache?

11. Intelligent cubes?

12. Perform unit testing?

13. Latest version of mstr?

14. Diff between user and system hierarchy?

15. Wat is meta data?

16. Do you have total in page by

17. How do u create subtotals?

18. Consolidation and custom groups w.r.t query?

19. Document and dashboard?

20. Prompt ordering?

21. Types of prompts,metric,filters?

22. Wat is freeform reports and use?

23. Complex reports u created?

24. Vldb settings and use?

25. Sql hint>?

26. Transformations?

27. Explicit table aliasing?

28. Warehouse catalog use?

29. Types of transformation

30. Set a default drillmap to the proj

Return to top

Leave a Reply

 

Are you finished?

Return to top