Hi, Which flavor of Publisher you are using, OAC, OAS or Fusion..? Can you please share your sample Bursting query? Check this note for FA publisher. - Fusion BI Publisher - BI Publisher Bursting Query From Email Address Parameter 3 - Bursting Alerts - Bursting Notifications - SMTP / OCI CNS - Email Domain - Bursting Job…

You can create lists of SQL Query or Fixed Data values only.

Hi, You can use System Variables (Analytics Publisher) like xdo_user_name in your query.

These are only supported date expressions for dynamic file name. Alternatively you can try dynamic file name(ex: TEST.2023JUL31) using Analytics Publisher Bursting Functionality.

Hi, Can you please share the error you are getting? what is the data source of your data set?

Hi, What Issue you are facing, provide more detail? Refer, Create Data Sources - Create RTF template -

Hi, You need to correct your syntax - Sample Runreport Request: curl -X POST -v -u username:password -o SampleOAPReport.pdf -H "Content-Type:multipart/form-data" -v -F 'ReportRequest={"attributeFormat":"pdf"};type=application/json'…

Hi, Can you share RTF(etext) and sample XML data for understanding the issue? It would be best to reorganize your data set as per the requirement.

Hi Dileep, Oracle Analytics Publisher(earlier known as BI Publisher) in Oracle Fusion Apps Cloud is designed to access data from Fusion Apps transactional database. JDBC/JNDI connections to external databases aren't supported. Refer https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/data-source-connections.html

Hi, BIP does not support this feature, there is Enhancement Request for same, you can check with oracle support team for more detail. ENH 30324446 - BIP SHOULD SUPPORT HIDE/UNHIDE IN EXCEL REPORT FORMAT Reference: Doc ID 2601464.1 Regards, Sandeep

HI Dhanuka, Generally this should work by default, column headers will repeat on all multiple sheets. Can you elaborate more or you can share your template/excel file, i can have a look. Regards, Sandeep

Hi, Are you able to generate report using template viewer? try generating the report output using template viewer, you can launch from program files (ex: C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\TemplateViewer) Regards, Sandeep S. Chauhan

Hi Ruzwan, Hope you are able to generate XML file (output type as XML(data)). You can check your template locally with generated XML output file. this will help you to debug further. you can also share your detail log here. -Sandeep S. Chauhan

Hi Pribin, This is expected behavior when generating the output in Excel file. carriage returns/new paragraphs will affect the output. These control character can be eliminated in SQL data set under data model. Or you can also try Excel (html) output as this output type ignores the control characters. Hope this will help…

Hi Andrew, Yes, The xml files produced by the bursting do not contain the parameters. Just by setting the Data Model property to include Parameter Tags will not cause the parameters to be included in every xml created by the bursting. Bursting will create the xml files by splitting the data according to the Split By field.…

Hi Saurabh, You can try building GeoJSON using data source shared by India govt https://data.gov.in/resource/all-india-pincode-directory-contact-details-along-latitude-and-longitude Thanks!

Hi Saurabh, BI Publisher do not support Essbase DV Dataset. This is the limitation as BIP cannot render the metadata for essbase dv dataset. Although you can directly setup essbase datasource & create bip datamodel.…

Hi Wayne, In Point number 4, JNDI name should be jdbc/AuditViewDataSource. We will get document updated. Thanks, Sandeep S. Chauhan

Hi, You can try using "expression filter" and/or option "limit value By" to achieve this. To add Expression filter : Click the filter bar menu or right-click, then select Add Expression Filter. To add Limit Value by option: Click the filter Menu and hover the mouse pointer over the Limit Values By option to specify how the…

Hi, Can you share the Audit report query? From where did you get the qyery with request id? Are you using this query for fusion BIP? Regards, Sandeep