Oracle Transactional Business Intelligence

Products Banner

Export OTBI to CSV includes excluded columns

Received Response


How do we ensure that OTBI reports exported into CSV, do not include the excluded columns.

Content (required):

Currently I have a learn report that I have filtered using a column I did not want the user to view. When it is exported into CSV however ALL columns are visible. How do I prevent this?

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):


  • Bhaskar Konar
    Bhaskar Konar ✭✭✭✭✭

    Hi @Dawn Cawston - CPS ,

    When you extract the results in CSV all the columns selected in the criteria pane will be available in the extract, as a result you are getting all columns here.

    In your case, you need to remove the column from Criteria tab. As you are using it for filter and filter will be still there even if you are removing the column from the criteria tab.

    Hope this help.