nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Dave Kekish

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?

Find more posts tagged with

BI Publisher

Report Output

Needs Votes

Status: Needs Votes

Comments

User_WX4OG

Hi Dave,

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

Dave Kekish

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.