Hi,
I am using BO 4.1. My query has two objects, and when I view data, I get four rows. But, when I run the same query I get only two rows. The actual result should be 1,2:1,2:1,3:1,2. I did set ‘Duplicate Rows’ radio button option. Does anyone experienced the same problem ?
Any help would be really appreciated.
Ramesh
Listserv Archives (BOB member since 2002-06-25)
Hello Ramesh,
My understanding is you got 4 rows but the report only displays 2. So it might be aggregating duplicate rows… So click somewhere on the result set. when you do so it selects the entire result set. Then go to format menu and then go to Table Menu from there. In the Table Menu there is a Tab called General. In that Tab there is check box named AVOID DUPLICATE ROW AGGREGATION. Check that and your result set should all the duplicate rows.
I hope this is what you are looking For.
Radhika
Listserv Archives (BOB member since 2002-06-25)
Hello Everybody,
I encountered a strange problem. I have two objects host_id and site_id in
result objects panel and condition site_id equal to 10822 in conditions
panel. The relationship between site_id and host_id is one-to-many. If I
execute this query , BO returns only distinct (host_id,site_id) pair even
when I have ‘Duplicates’ switch toggled ON. If I copy the SQL generated
against the database directly then I get back everything without any
problem. Even if I look into Data->View then it displays all raw data
selected. So I am assuming that something happens the data is retrieved.
Can anybody provide me some gudielines about which settings I need to
examine to get all the rows ?
Thanks
Abhijit Bhattacharya
Listserv Archives (BOB member since 2002-06-25)
Abhijit - Right click on the border of the results table and select Format
Table. Select the General tab and enable “Avoid Duplicate Row Aggregation”.
It would be nice if BusObj could make this an application level setting so
we wouldn’t have to do it for every report.
George Baranowski
QuadraMed
Hello Everybody,
I encountered a strange problem. I have two objects host_id and site_id in
result objects panel and condition site_id equal to 10822 in conditions
panel. The relationship between site_id and host_id is one-to-many. If I
execute this query , BO returns only distinct (host_id,site_id) pair even
when I have ‘Duplicates’ switch toggled ON. If I copy the SQL generated
against the database directly then I get back everything without any
problem. Even if I look into Data->View then it displays all raw data
selected. So I am assuming that something happens the data is retrieved.
Can anybody provide me some gudielines about which settings I need to
examine to get all the rows ?
Thanks
Abhijit Bhattacharya
Listserv Archives (BOB member since 2002-06-25)
Turn on “Avoid Duplicate Row Aggregation” in the General tab of the Table
Format.
Erich Hurst
Compaq Computer Corporation
“It is so easy to break eggs without making omlettes.” – C.S. Lewis
Listserv Archives (BOB member since 2002-06-25)
Hello,
Business Objects initially performs a sum on measures when it displays
the report (depending on the definition of the object - see the
properties tab). Select your table in the report, go to the Format menu,
Choose Table. Click on ‘Avoid Duplicate Rows Aggregation’. That should
display all your data.
Best regards,
Thierry Vandenplas
DHL International N.V.
Belgium
…
Can anybody provide me some gudielines about which settings I need to
examine to get all the rows ?
Thanks
Abhijit Bhattacharya
Listserv Archives (BOB member since 2002-06-25)
First, check to see if you have included all keys in your query. If you
do not have the full key, it is very likely that you will return
multiple rows for the given key.
This could also be normal behavior. In this case, highlight the table.
Select the ‘Format Block’ icon (the one with the little “i”). Select the
General tab, and then click on the box next to Avoid Duplicate Rows
Aggregation. Click on OK, and you should see all the rows from the
viewer.
Abhijit Bhattacharya wrote:
Hello Everybody,
I encountered a strange problem. I have two objects host_id and site_id in
result objects panel and condition site_id equal to 10822 in conditions
panel. The relationship between site_id and host_id is one-to-many. If I
execute this query , BO returns only distinct (host_id,site_id) pair even
when I have ‘Duplicates’ switch toggled ON. If I copy the SQL generated
against the database directly then I get back everything without any
problem. Even if I look into Data->View then it displays all raw data
selected. So I am assuming that something happens the data is retrieved.
Can anybody provide me some gudielines about which settings I need to
examine to get all the rows ?
Thanks
Abhijit Bhattacharya
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================
Listserv Archives (BOB member since 2002-06-25)
I understand that to see duplicate rows in a report, you must turn ‘off’ duplicate row aggregation, but I was wondering if there is a way to do this in Designer, so the users of the report automatically see the duplicate rows.
Thanks!
Sarah
Listserv Archives (BOB member since 2002-06-25)