DISTINCT Values in WEBI
We always not prefer to see the duplicate records in report. in some cases the output of the universe may have duplicates. We can remove the duplicates in WEBI layer. Follow the below steps to remove duplicates. Go to Query Panel in Webi, Click the properties and uncheck the “retrieve the duplicate rows”. By default, it is checked Thanks. Please let me know for any issues.