How to retrieve the duplicates records.
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.
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