Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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