Oracle Transactional Business Intelligence

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

Export OTBI to CSV includes excluded columns

Received Response
41
Views
1
Comments

Summary:

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):

21D

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

Answers

  • Bhaskar Konar
    Bhaskar Konar Rank 7 - Analytics Coach

    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.

    Cheers,