prasanth

• Jul 9th, 2007

 

Report filter: this is applied on data before retriving from DW..

View filter:This is applided on after data from DW..and on which data you have in the particular report.

eswareddi

 Profile Answers by eswareddi Questions by eswareddi

• Jul 18th, 2007

 

view filter is subset of report...it doesn't goes to dwh...But report filter does.

Mythili

• Jul 18th, 2007

 

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.

wasim

• Oct 6th, 2007

 

Report Filter: Applied for before calculating the metrics.

We can create a condition from any objects within master projects.

It can re-exeute the report

View Filter: We can apply a condition in memory. Dont re-execute.

We can create a condition from any objects within report objects.

thirusingireddy

 Profile Answers by thirusingireddy 

• Jun 17th, 2008

 

view filters it  filter the data at microstrtegy level but repot filtr   are filter the data at data base level

Kumar14

 Profile Answers by Kumar14 

• Jan 14th, 2010

 

In addition to above good answers.
Report filter: Global, can use in any report if it satisfied the filter condition.
View filters are: Local to that particular to report.

vidhya

• Feb 15th, 2012

 

SQL engine takes care of Report filter
Analytical engine takes care of View filter

sivaleela prasad

• May 30th, 2012

 

Report filter : Before execution of the report ,calculate the warehouse so effect on the SQL ,it is fast performance.

View filter : After execution of the report , calculate the analytical engine so no effect on the SQL ,it is slow performance.

Mahipal

• Oct 19th, 2012

 

Report Filter: This filter condition is directly thrown into SQL directly when we first run the report and fetches data according to the filter condition. This filter directly communicates with the Database

View Filter: This is a special type of filtering condition where the filter can be applied once the results are back from the Database. This filter communucates with the Analytical engine as the results are already residing there.

Olex

• Jan 24th, 2013

 

Report filter limits data at query level when report executes, view filter slices data without running any sql queries.

mohit bhutani

• Mar 31st, 2014

 

Report Filter is handled at database level and view filter is handled by analytical engine. Report filter affects SQl and View filter doesn't affect

pavan

• Dec 8th, 2015

 

View Filter: View Filter is using for Multiple Views in a Report. It is a OLAP service. It has no SQL Passes, It can be used after report execution.

Report Filter: Report Filter is Creating in a Report only by using Report Filter Definition. It does not move to another Report. It can be used before Report execution.

Jayadev

• Oct 25th, 2016

 

Report filter works while retrieving the data from warehouse, view filter will be applied after retrieving the data

Suresh

• Jan 13th, 2017

 

View filter can be applied after the metric calculations are done for a report. wherer as report filter is applied in the calculation itself i.e report filter is applied in the where clause of the Sql. view filter are local to the report and report filter can be used for other reports as well.

Shikha Sood

• Oct 7th, 2017

 

View Filter: View filter works on the executed report as It is on Analytical engine level. It will on hit the database again to fetch the reuslt. It will only execute on the fetched report result set.

Report Filter: Report Filter is the where condition and it will hit the DB to get the result set. It is added in the SQL that is generated when we have executed the report