Data Warehouses MicroStrategy Question:
Download Questions PDF

Explain What is the difference between view filter and report filter?

Answer:

Report Filter:

A report filter?conditions appear in the SQL used to retrieve the report result set from the database. The report filter is created as part of the report and is saved with the report definition.

View Filter :

View filters do not modify the SQL for the report like normal report filters do. Instead, view filters are applied to the overall result set after the SQL is executed and results are returned from the data warehouse.

Download Data Warehouses MicroStrategy Interview Questions And Answers PDF

Previous QuestionNext Question
In Microstrategy, how can we direct the sql generated to use a specifc table?

I know of using ApplySimple, but there are other ways too?		What are Logical Views used for In Microstrategy?