I am creating a report in BI publisher and it shows duplicate values for employee ID's. Employee ID should be a distinct value and should not be returning duplicate values.
Here's a blog that might help. It has the xdo distinct function which can be used in bip templates.
https://blogs.oracle.com/xmlpublisher/entry/counting_distinctly