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 Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you please send me the migration related issues .

1641


is it possible to export the webi reports to crystal reports?with out using businessview?

1816


Explain what is aggregate table and aggregate fact table ... Any examples of both?

603


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1751


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598






can anybody tell me about complicated object you have created

2751


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3843


What are the data types present in bo? What happens if we implement view in the designer and report?

615


How we drill up week to month?

617


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

599


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1487


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1718


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4441


Explain is there any default username & pwd for bo designer & supervisor?

593


What are all difference between business objects 6.5 and xi r2?

600