Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE Report export to CSV has extra columns which are excluded from the result view.
OBIEE Report export to CSV has extra columns which are excluded from the result view.
Excel exports works fine (eg : 500 records in total which is basically grouping by the column which is there in the exclude list)
CSV exports brings more (eg : 1000+ records)
How do we handle this ?
OBIEE Version : 11.1.1.7.150120
Thanks, Helan
Answers
-
Remove the columns from the criteria tab. CSV export is not looking at how you formatted the results, but uses the criteria tab for export.
Also see doc 2023149.1
0 -
Is there a way to handle this, because my result set will vary if i remove this column from the criteria / exclude section.
0 -
In my opinion your report is created incorrectly if you are dependent on certain columns to be there. Have you checked your RPD to see if all is setup correctly?
0 -
OBIEE as a data-pump is not the intended use ... the export to CSV doesn't care what you've got formatted or set in the exclude part of a visualization. It runs the query and dumps all the rows and columns given what's in the Criteria tab.
0 -
+1'000 - CSV: https://en.wikipedia.org/wiki/Comma-separated_values
0