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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many reports have u created ? explain a few.

1667


Explain what three things do you consider to be the most important factors for a manager?

557


Explain what are the steps to do to use alerts in bo?

617


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


How to schedule the report in b.o?

564






What is the difference between the public object&schema object?

580


explain in detail about type 3?

631


Explain the data types present in bo and what happens if we implement view in the designer and report?

565


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4193


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1779


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2609


Explain which versions are used in the bo dashboard work?

635


How we drill up week to month?

619


how to create metric universe ?

1899


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1973