Oracle Analytics Publisher

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

Categories

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

Empty column missing from csv output

Closed
921
Views
8
Comments
Antony Hooper-29731
Antony Hooper-29731 Rank 3 - Community Apprentice
edited September 11 in Oracle Analytics Publisher

Summary

Empty column missing from csv output

Content

I have a BI Publisher report that extracts several columns that may or may not be populated.  When they are not populated (only null values), the output does not include them when exporting the csv. 

Is there any way to force every column that is specified in the data model to be present in the csv output?

There is a setting for dynamic columns in the report properties under 'FO Processing', however that doesn't seem to be what I'm looking for.

Any help will be appreciated.

Many thanks,

Antony.

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    You are welcome.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi Antony,

    Did you try the below option

  • Antony Hooper-29731
    Antony Hooper-29731 Rank 3 - Community Apprentice

    Took me a while to find it, but I knew I'd seen it somewhere, in case anyone else is unsure of where to find this setting:

    Capture.PNG

    Yes that's exactly the one, and it also showed me how to remove parameter tags.

    Thank you so much, really appreciate it.

    Antony.

  • Max Naluparayil
    Max Naluparayil Rank 1 - Community Starter

    Hi Antony, Can you please re-upload the image which has the solution to this problem? It shows up as a broken link. 

  • Rajesh Dhanapal
    Rajesh Dhanapal Rank 4 - Community Specialist

    Hi,

    Please can you re-upload the image. I have got exactly the same issue.

  • Harishma
    Harishma Rank 3 - Community Apprentice

    Hi @Antony Hooper-29731, could you please re-share the image? I am dealing with the same issue and would like to understand the solution.

  • Harishma
    Harishma Rank 3 - Community Apprentice

    Hi @Sherry George, could you please re-share the solution that was provided? I don't see the solution/image in this thread. I am dealing with the same issue and would like to understand the solution.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Both users aren't active in this forum. This question was imported from another platform.

    Please post a new question in https://community.oracle.com/products/oracleanalytics/categories/bi-publisher , post your product name and version and your question with all the details for other people to be able to provide replies.

This discussion has been closed.