Readers:

Today, I am going to introduce a new blog entry related to Interview Questions. I have interviewed a lot of people for various MicroStrategy positions over the years and thought I would share with you some of the questions I have asked or have been asked on interviews. I will try to add two interview questions a month.

Best regards,

Michael

Question

Why does the SQL you created using MicroStrategy (assume it generated a single-pass SQL) produce different results than when you run it directly against a database?

Answer

There may have been steps that required the analytical engine which would only occur on the Intelligence Server and not when you directly run SQL against a database.

Join the conversation! 2 Comments

  1. Great post! Very interesting…

    Reply
  2. I think the question is not well stated.
    “SQL” Generated (technically) never creates different results.
    “Report Result” and “SQL Result” might be different.

    PS: There are cases SQL may create different result from DBQuery Tool and database (forexample Toad). Its a defect that rarely happens due Microstrategy Drivers

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Category

Interview Questions, MicroStrategy Engine, MicroStrategy Generated SQL

Tags

, , , , ,