Microstrategy Interview Questions - part 10

  1. Should you have DATE as ID attribute form?
  2. What is compound key?
  3. What is a fact and an attribute?
  4. What are Factless facts?
  5. What are Transformations? Is there any transformations implemented in your project?
  6. Explain Fact Structure(types, one by one)
  7. Explain Level Extension. How it is used in your project?
  8. Explain Fact Relation.
  9. Explain Fact Degradation.

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.

Microstrategy Interview Questions - part 7

  1. What is metadata?
  2. What is two-tier connection?
  3. What is three-tier connection?
  4. What is difference between 2, 3 and 4 tier connections?
  5. How do you achieve schema object version control (similar to VSS)?
  6. What are different kinds of objects in MicroStrategy?
  7. What’s fact table?
  8. Where is Administrator’s password stored? Is it stored in encrypted?

Microstrategy Interview Questions - part 6

  1. What is ScanMD?
  2. What is MD Doctor?
  3. What is clustering?
  4. How will you reset password of all users?
  5. What are different modes you can run I-Server?
  6. How can you make sure that I-Server would be running even if the application  mode has crashed and how  to get back the instance?
  7. What are various authentication modes?
  8. How can you configure WH authentication?
  9. Does DLS affect MicroStrategy?

Microstrategy Interview Questions - part 5

  1.  What is Freeform SQL?
  2. What is an OLAP cube report?
  3. How to apply OLAP?
  4. How to handle many to many relationships?
  5. If there are diff. customers how to define the data?
  6. How to create dual key(dual key in composite key)
  7. What is VLDB based performance tuning?
  8. Have u used stored procedures to invoke MSTR?
  9. What is compound metrics(is m1 + m2 a compound metrics)
  10. What is Hetreogenous mapping?

Microstrategy Interview Questions - part 2

  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?
  10. how does the ordering change affect the calculation?
  11. Tpes of cache?

Microstrategy Interview Questions - part 1

  1. What is a Command manager?
  2. What is an Object manager?
  3. In the RDF documents, a metric pops up when you run it, how to delete it(there are three ways to delete it)?
  4. Installation of MSTR?
  5. Configuration?
  6. In a document how to repeat a section?
  7. Query builder?
  8. Report wizard?
  9. Report builder?
  10. Configuring data mart?
  11. Fact level extension?
  12. Diff types of reports?
  13. Types of objects?

Pages

Subscribe to Universal Remote Codes TV RSS