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  >  Business Objects
Go To First  |  Previous Question  |  Next Question 
 Business Objects  |  Question 12 of 239    Print  
How to filter repeatative values in the report to get distinct values.

Example: In any database we can use distinct command But My Report source is flatfile.Therfore,I cann\'t manipulate source system.

Is there any command or function to filter repeating records/values in the report.

Advance,Thanks.
BO-Nath

  
Total Answers and Comments: 3 Last Update: March 18, 2006     Asked by: BO-Nath 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 03, 2006 00:07:51   #1  
reddeppa        

RE: How to filter repeatative values in the report to ...

In the Query pannel ..we have tab "Options"..

click there to get "eliminate dupicate"..enable this options..

its may help u..


 
Is this answer useful? Yes | No
February 15, 2006 09:41:56   #2  
rahul        

RE: How to filter repeatative values in the report to ...

Using the eliminate duplicates option is one way.

In a clightly different scenario, duplicates could come up due to the design structure of the report. e.g.

In some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the original field required. That ways the same value is fetched and also only one value is returned.


 
Is this answer useful? Yes | No
March 18, 2006 12:59:00   #3  
Omkar Paranjpe        

RE: How to filter repeatative values in the report to ...

Hi,

One other way possible is by doing "No Duplicates" radio button in the Options of the data provider in the Definition(the black cube)

But sometimes in free-hand sql reports it is not possible.


 
Is this answer useful? Yes | No


 
Go To Top


 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