GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  MicroStrategy
Go To First  |  Previous Question  |  Next Question 
 MicroStrategy  |  Question 4 of 5    Print  
What is the difference between view filter and report filter?

  
Total Answers and Comments: 5 Last Update: June 17, 2008     Asked by: sabari 
  
 Sponsored Links



 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 09, 2007 04:49:58   #1  
prasanth        

RE: What is the difference between view filter and rep...
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.

 
Is this answer useful? Yes | No
July 18, 2007 01:48:49   #2  
eswareddi Member Since: February 2007   Contribution: 2    

RE: What is the difference between view filter and rep...
view filter is subset of report...it doesn't goes to dwh...But report filter does.
 
Is this answer useful? Yes | No
July 18, 2007 04:43:42   #3  
Mythili        

RE: What is the difference between view filter and rep...

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.


 
Is this answer useful? Yes | No
October 06, 2007 11:52:00   #4  
wasim        

RE: What is the difference between view filter and rep...

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.

 
Is this answer useful? Yes | No
June 17, 2008 14:22:38   #5  
thirusingireddy Member Since: June 2008   Contribution: 0    

RE: What is the difference between view filter and report filter?

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


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links



 
Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape