How to export the report/data without column header to plain text file in OBIEE 11g ?

Question

Dear all,

May I know whether it is possible to export the report without column headers to plain text file (non delimited file)  in OBIEE 11g ?

For the work around solution to export the report in plain text file (non delimited file), I join the values of all columns to one column and export this column to csv and rename to txt file.

However, I don't know how to omit the column header during export.

As the omit of the column header during export is specific for 1 report only, hence, I don't want to change that export option globally.

Thanks in advance.

Gianni Ceresa · Answer

CSV/Tab delimited ignore the results views.

It exports directly the dataset returned by the criteria you entered.

So if you have 10 columns in your criteria and add 5 as excluded in a table view, if you export it in CSV you get the 10 columns.

That's why you still get the header, even if empty.

User_RUIII · Answer

Hi Aj,

After using Narrative view, the column header/line is omitted when exporting to PDF/Excel. However, when I use Export -> Data -> CSV Format/Tab delimited Format to export, the blank link is still there.

May I know whether I can totally remove the column header in exporting to CSV/Text file ?

Really thanks a lot.

Thomas Dodds · Answer

Wrong tool for the job ... OBIEE isn't great at DB dumps