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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
515
Views
6
Comments
User_RUIII
User_RUIII Rank 3 - Community Apprentice
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

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.

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Hello,

    Go to your column properties. Make Column heading Blank and check custom heading and make the font color as white and size as zero.

    Capture.PNG

    Go to table properties and make the below change.

    Capture.PNG

    Now export it as data and in the save window save it as file.txt .

    Thanks

    Aj

  • User_RUIII
    User_RUIII Rank 3 - Community Apprentice

    Hi Aj,

    Thanks for your prompt reply.

    On the table properties, I don't have the option of "No Column or table headings" in Display Folder & Column Headings.

    pastedImage_0.png

    Instead, I have selected "Off" in Column Labels under View Properties.

    pastedImage_3.png

    Although the column header is gone during export, it still leaves a blank line.  Is there anyway to remove that blank line ?

    pastedImage_1.png

    Thanks a lot.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Ok..

    Add a Narrative view and include your columns like below

    @1 @2 @3 @4

    thanks

    Aj

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

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

  • User_RUIII
    User_RUIII Rank 3 - Community Apprentice

    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.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.