GeekInterview.com
Series: Subject: Topic:
Question: 15 of 18

What is the difference between view filter and report filter?

Asked by: Interview Candidate | Asked on: Jul 3rd, 2007
Showing Answers 1 - 10 of 10 Answers
prasanth

Answered On : 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.

  
Login to rate this answer.

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

  
Login to rate this answer.
Mythili

Answered On : Jul 18th, 2007

Report Filter:

A report filterconditions 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.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
wasim

Answered On : 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.

Yes  1 User has rated as useful.
  
Login to rate this answer.

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

  
Login to rate this answer.
Kumar14

Answered On : Jan 14th, 2010

View all answers by Kumar14

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.

  
Login to rate this answer.
vidhya

Answered On : Feb 15th, 2012

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

  
Login to rate this answer.
sivaleela prasad

Answered On : 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.

  
Login to rate this answer.
Mahipal

Answered On : 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.

  
Login to rate this answer.
Olex

Answered On : Jan 24th, 2013

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

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.