Oracle Fusion Data Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Fusion Data Intelligence Idea Lab

Categories

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

BIP Report Output when there are no rows should return the expected headers, not DATA_DS

Submitted
362
Views
2
Comments
Dave Kekish
Dave Kekish Rank 5 - Community Champion
in Oracle Fusion Data Intelligence Idea Lab

We currently schedule reports to output as a CSV to the UCM for import into our local data warehouse platform. This works very well except on the occasion that the report has no data to display.

When data exists, we get the expected header row, followed by data. when there is no data (for any of a dozen reasons), we get however a single column that is entitled Data_DS. This breaks normal import processes.

Can we get it to output the expected column headers (which it will appear to do if you run the report interactively) to output in the CSV to the UCM?

Tagged:
1
Up
1 votes

Submitted · Last Updated

Comments

  • User_WX4OG
    User_WX4OG Rank 1 - Community Starter

    Hi Dave,

    could you please help how you resolved this? we are also going through the same scenario.

  • Dave Kekish
    Dave Kekish Rank 5 - Community Champion

    Hi there, to be 100% honest with you, I don't really remember.

    In general, we have pivoted over to regenerating the reports out of PVO's where this is an issue, however, one trick to try is on the data model, make sure the Include Parameter Tags option is enabled. That should force the headers to generate.