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.
  10. What is Compound Key Attribute? Give example from your project.
  11. Can you update a table in Warehouse using MicroStrategy?
  12. How will you resolve an issue when (by chance) an aggregate table at higher level has a higher LTS than an aggregate table at lower level?
  13. What happens if LTS is high for a higher level table?
  14. What are the criteria used by the MicroStrategy SQL Engine to build the join tree of a report’s SQL?
  15. Can MicroStrategy logical primary keys and the true (warehouse) primary keys differ?
  16. Oracle has a pseudo column named ROWID which is not “directly” exposed to front-end? Can this table be used in MicroStrategy? Why one would do that?
  17. Can you create Schema objects in 2 tier connection? Is it recommended?