Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to retrieve the duplicates records.

Hi friends,

My next issue, how to retrieve the duplicate records in web intelligence.I checked the option Retrieve duplicate records in web intelligence as well.But it is not helping me.

Hope you guys are help to solve this issue.

Thanks lot,



Former Member

hi Blaji,,

ive tried this here and it worked perfectly with me

even so, you dont need to make the QTY as a dimension, you can leave it as a measure also, and it will work good with you.

click the block on the WebI, the Block itself.

and find its properties, under "Display", you will find

"Avoid Duplicate row Aggregations"

in the query it self you should flag "Retrieve Duplicated Rows"

i think this will work fine with you

good luck


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question