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.
The Data Model was not built as top-down. As such, the Bursting Key was not at the top of the report.
I rebuilt the Data Model as top-down and bursting worked
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:
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
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!
Great, it is working for you now.
Appreciate that if you can describe what do you mean the DM was not built as top-down and Bursting Key was not at the top of the report. Thanks for your help!
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
