Oracle Transactional Business Intelligence

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

Excel report only showing parameter page and not data page when bursting

Received Response
10
Views
3
Comments

See attachment.

When I run the report online it works.

When I orride the bursting, it works.

When I schedule with DM Bursting, the excel spreadshhet has the parameter values on Sheet 1, but no data on Sheet 2.

Answers

  • RVohra
    RVohra Rank 6 - Analytics Lead

    Ensure that your DM bursting query (or delivery mapping) is correctly passing all report parameters used in the layout and data model.

    Also, can you log into BI Publisher Job History, open the job, and:

    • Download the XML data generated during bursting
    • Open it and confirm whether it contains actual data nodes or is empty
  • Al Darabaris
    Al Darabaris Rank 1 - Community Starter

    The XML contains the data.

    The data is not transferred to the Report Template.

    But I can republish the xml to the report and it all appears

  • RVohra
    RVohra Rank 6 - Analytics Lead

    This is interesting, It is not easy to answer without the env access. You might need to have a debugging session with Oracle Support. Log a SR.

    Hope it helps!