Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

BI Report output shows Data_DS in csv format instead of showing empty table with columns

Received Response
48
Views
1
Comments
Ninad Joshi
Ninad Joshi Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Report output displays Data_DS when there is not resultant data

Expected:

I need the CSV output to display column names when data in not present for further integration column mapping

Please review attached document with screenshots

what can be done to get the expected output format

CSV report output issue.docx


Thank you

Ninad

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi, In that case you need to build your report such that it always has 1 row of data. Like join to a second dataset g_0 with a a select null from dual so you always get that row if no data found in your main data set g_1.