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 DOES SQL TAB CONTAIN?
why do we use crystal reports rather than webintelligence reports ?
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
how we send repotrts/documents to end user
what is aggregate navigation?
3 Answers Countrywide, CTS, HCL,
is it possible to export the webi reports to crystal reports?with out using businessview?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
what is document design in boxi,have u participate in that