Skip to Content
0

How to retrieve duplicate rows in BOE XI3.1

Mar 24, 2017 at 08:55 AM

79

avatar image

Symptom

  • Rows are duplicated (doubled) in WebIntelligence reports .
  • Values are correct but shown duplicated.
  • Different results from executed BEx query.

Environment

  • Business Objects Enterprise XI 3.1 Service Pack 6
  • Infoview and WebI Rich Client XI 3.1 SP6

Reproducing the Issue

  1. In Infoview or WebI Rich Client, build a WebI document, bring objects to the query panel, run the query.
  2. Run the query with button 'Retrieve Duplicate Rows", but only part records are shown.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Mar 24, 2017 at 10:23 AM
0

in the table->properties->tick the checkbox "avoid duplicate row aggregation" check box and see.


untitled.png (12.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Chris Jones Mar 29, 2017 at 02:22 AM
0

Hi Amit,

There is no "Avoid duplicate row aggregation" option in my WebI.

Properties is shown as below in my product, is there any other configuration to display it? Thanks.


ars.png (277.7 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

option higlighted in left panel are related with report.you need to select the table to see the table properties in left panel.

0
Shankar Choudary Mar 29, 2017 at 06:42 AM
0

Hi Chris,

In report panel right click on Report table and select "Format Table option" after choosing that option, In general you would be able to see the option "Avoid duplicate row aggregation" tick the check box and click on apply and then on click on OK button. try refreshing the report after the changes.

Also in query panel, go to query properties tick the check box "Retrieve Duplicate rows" and then apply changes, try running the query after implementing the changes.

Regards,

Ravi Shankar

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Ravi, thanks a lot, this helps resolve my issue.

0