Recruiter, software, contract, business, systems, developer, analyst, hardware, technical interview questions, staffing agency
« Scenario 2
Define the different prompts found in Microstrategy? »

What are the different types of filters Microstrategy has?

Report Filter
The Report Filter is one or several conditions applied at the time the SQL is generated to return data from the warehouse. The Report Filter can be edited only in Design Mode. In View Mode, the Report Filter can be displayed but not edited. Changing the Report Filter causes the report to re-execute and takes longer than changing the View Filter.

View Filter
The View Filter is one or several conditions that return a subset of the data in the original report. For example, if the original report has all stores in the Northeast region shown, you could choose to show Boston stores only by adding a condition to the View Filter. The View Filter can be viewed and edited in View mode; in Design Mode it can only be viewed.

 Share

This entry was posted on Monday, February 18th, 2008 at 8:30 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.

One Response to “What are the different types of filters Microstrategy has?”

  1. venkat Says:
    September 5th, 2008 at 2:23 am

    this is a good answer

Leave a Reply