ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
i Have created the universe in which i have one table and 
different derived tables from the same table i am supposed 
to create report from the same universe  which should 
dispalay the duplicates rows, but all the time i run the 
report i am not getting the duplicate rows i have checkd 
the duplicate report option too in report.. is there 
problem with universe or report,.. can any body help?
 Question Submitted By :: Tanvirowaisi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
Answer
# 1
I thing, the plm is in universe, there is only one table is 
used in the universe and all other is derived tables. where 
you get objects? if you get objects from derived tables 
alone pls check the join condiion in derived table's sql 
query, else if you are pulling objects from derived table 
and db table, definitly you would get duplicate rows.
 
Is This Answer Correct ?    0 Yes 0 No
Dhineshkumar. S
 
  Re: i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
Answer
# 2
This can be solved in a simple manner.. In Report just 
double click your table or right click for Table 
properties.. In the General Tab just uncheck the 
option "Avoid duplicate rows Aggregation". Hope you will 
get the desired results..

--Senthilmurugan.S
 
Is This Answer Correct ?    0 Yes 0 No
Senthilmurugan.s
 
 
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
What is the drill up , drill down, drill by , drill trough ? TCS1
WHAT IS CARDINALITY?  4
If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps. iFlex1
what is master-detail report TCS2
Draw the architecture of traps? Wipro3
how many user were there  1
How toconnect one to one report? iFlex3
while migrate bo 5.1 report into boxir2 ,what are the problems faced  2
What is the use of AFD? Where it can be stored?  1
Can we have multiple domains?  3
how do u resolve contexts ? Wipro4
What are the different types of Filters available in BUSINESS OBJECTS?  1
can we create aliases for every table beforehand? if yes whar are the disadvantages? AG-Technologies2
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe? Oracle3
What is a universe? TCS5
what is a filter?  1
What do you mean by Object qualification?  3
plz tell me about BOmain key in detail?  1
As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.  5
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in  2
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com