we are working on obiee 220.127.116.11 version.we have an issue when the report exported in CSV format.Some rows are repeating,the same report exported to excel we are not getting repated rows.
Can anyone please let us know the sloution to overcome the issue.
Are you sure the issue is in the CSV and not in the Excel?
If you run the physical query directly on the DB aren't the rows repeated?
CSV export the raw result of the criteria of your analysis, Excel export the result of your view, and in a view you can do a lot of things (aggregate rows together, make them unique etc.).