Categories
- All Categories
- 93 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.2K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 53 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Exporting to csv file from BI Publisher as per template.
Hi All,
When we export csv file from BI Publisher Reports it takes all the columns available with data model. Hence the csv file doesn't follow the template format of report.
I need to export the report as csv file with number of fields added into the report template.
Please suggest.
Regards,
Abinash
Answers
-
-
Hi Christian,
We are using Oracle Business Intelligence 12.2.1.1.0. mounted on UNIX platform.
Agree with point b, "In general CSV is an export of the *data*. Not from what the report displays and mangles and omits." -- Even OBIEE does that, but how can we remove the unwanted columns from displaying to user, which makes no sense to them.
Regards,
Abinash.
0 -
By not having those columns retrieved at all in the first place.
0 -
yes, correct. but we need few columns for which we cannot exclude at data model layer, hence trying to exclude them while exporting.
Regards,
Abinash
0 -
That's simply not how the tool works. Use a data model for the export which has precisely what you need.
0