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?
Answers were Sorted based on User's Feedback
Answer / senthilmurugan.s
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 ? | 4 Yes | 0 No |
Answer / dhineshkumar. s
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 | 1 No |
what is diff between Decode and case ? Give some Example?
Hi any done business objects certification.i am expecting some help from them.
Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?
Did you face any problems while creating reports? Name? Solutions?
Tell me about a complicated object you have created?
Can we configure two instances of CMS pointing to two different CMS system databases?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
What services the broadcast agent offers on the server side?
What would you consider as your biggest achievement and why?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
is there any limit for rows and columns in cross tab
How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible