Skip to Content
avatar image
Former Member

How to retrieve duplicate rows in BOE XI3.1

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.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 24, 2017 at 10:23 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29, 2017 at 02:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2017 at 06:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded