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

Hi, Try this, Edit Dashboard->Tools->Print Options->Print Rows should be set to 'All' Regards, Sandeep

Hi, Refer this support document for standalone BIP: How to set default report time zone in BIP (Doc ID 2535432.1) == When BIP is integrated with OBIEE: BI Publisher preferences page inherits the OBIEE settings. For a new user the timezone setting in the BI Publisher preferences are taken from the instanceconfig.xml. You…

Hi, You can try this as well:<br /><?format-date:(xdoxslt:ora_format_date_offset(xdoxslt:sysdate(&#39;YYYY-MM-DD&#39;),7,&#39;+&#39;));&#39;DD-MM-YYYY&#39;?> -Sandeep

 Hi, Nice to know that its working

Hi Donald, The attached template / XML is absolutely working fine without any exception or error. Which you have stated above as well. Can you share diagnostic log file for this issue, refer below link to enable and generate the diagnostic file.…

Hi Chethana, There is no direct provision to handle this in OAC for Analysis reports, though with some tweaks this can be handled using Agents in OAC classic. As per my knowledge, This option (agents) is currently available for analysis and not for DV projects. Oracle Analytics Cloud 18.1.3 and later version have all the…