Recruiter, software, contract, business, systems, developer, analyst, hardware, technical interview questions, staffing agency
« How would you apply a query filter based on the description of the attribute instead of an ID.
Scenario 2 »

Scenario 1

What would you do to tune a Microstrategy Report which is returning millions of rows?

You can tune the report on two levels.

Database: Within the database, indexes, partitions, keys and hints can help the generated SQL query be more efficient.

Microstrategy: Look into setting up some object prompts for attributes, metrics and filters. Try using required filters so you never bring back 550 million rows.

 Share

This entry was posted on Monday, February 18th, 2008 at 8:29 pm and is filed under MicroStrategy Interview Questions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply