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!
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
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…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
