Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

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

Comments

Hi Dheeraj, Test the XML output for one against you layout, remove any for-loops pointing to groups that are not included in the split-by subset. Rgds, Kevin

in BIP Report in Oracle fusion not generating output when XML bursting is used in excel template Comment by Kevin M-Oracle Apr 15, 2025 11:28AM
I used Download / Upload and your issue did not replicate. Rgds, Kevin

in How do I preserve parameter visibility settings when migrating BI Publisher reports to a new server? Comment by Kevin M-Oracle Apr 14, 2025 12:56PM
How did you generate the reports zip file in 11g? How did you import the zip file to OAS? Rgds, Kevin

in How do I preserve parameter visibility settings when migrating BI Publisher reports to a new server? Comment by Kevin M-Oracle Apr 11, 2025 1:24PM
Migrating reports and data models should not change the objects. I tested using Download / Upload and the show parameter settings were retained in the copy. How are you migrating data models and reports? Rgds, Kevin

in How do I preserve parameter visibility settings when migrating BI Publisher reports to a new server? Comment by Kevin M-Oracle Apr 10, 2025 9:14PM
That's great, thanks for letting us know. Rgds, Kevin

in Group Filter set to parameters with default values but no data returns, even though it's there. Comment by Kevin M-Oracle Apr 9, 2025 12:54PM
Please log an SR to get direct assistance. Rgds, Kevin

in Group Filter set to parameters with default values but no data returns, even though it's there. Comment by Kevin M-Oracle Apr 8, 2025 6:00PM
Hi Bhaskar, You are welcome. Glad I could help. Kevin

in dynamic footer in RTF template Comment by Kevin M-Oracle Apr 8, 2025 4:04PM
Try adding a parameter to your data model instead of a group filter. Rgds, Kevin

in Group Filter set to parameters with default values but no data returns, even though it's there. Comment by Kevin M-Oracle Apr 7, 2025 8:23PM
Leave the filter out. Just create a data set with the xls spread sheet. Does it generate data? Kevin

in Group Filter set to parameters with default values but no data returns, even though it's there. Comment by Kevin M-Oracle Apr 7, 2025 8:08PM
If each page is being populated by a for loop, you can try for-each@section:whatever so it updates the footer for each iteration of the loop. Rgds, Kevin

in dynamic footer in RTF template Comment by Kevin M-Oracle Apr 7, 2025 5:38PM
Using MHTML output has the same 65k record limitation. Currently you can use an RTF or XPT layout to generate xlsx output. Rgds, Kevin

in Page Break function not working for excel(MHTML) output format Comment by Kevin M-Oracle Mar 28, 2025 1:06PM
Change the name (replace) in the data generation, then there is no need to modify the layout. Rgds, Kevin

in Change excel sheetname ( BI Publisher - Excel template 12.2.1.3) Comment by Kevin M-Oracle Mar 28, 2025 1:03PM
You are welcome. Kevin

in OAP 7.6 with Ukrainian localization is inoperable Comment by Kevin M-Oracle Mar 27, 2025 12:40PM
Please apply and test Patch 37399490: CANNOT EDIT DATA MODEL OR ACCESS MENUS WITH UKRAINIAN LANGUAGE for version 7.6.0.0.241001. Rgds, Kevin

in OAP 7.6 with Ukrainian localization is inoperable Comment by Kevin M-Oracle Mar 26, 2025 3:37PM
If your output is a simple table, I would suggest an Excel layout. Otherwise you have to format the column(s) as date after it is generated. Rgds, Kevin

in Date Display as "Date Format" but not "Text Format" in Excel output Comment by Kevin M-Oracle Mar 25, 2025 10:49AM
You should be able to add columns, but not parameters as that is limited by the package defintion. Rgds, Kevin

in Account Analysis Report - How to add new columns in Report Comment by Kevin M-Oracle Mar 13, 2025 4:29PM
No the image has to be in a BLOB column, not CLOB. Rgds, Kevin

in Dynamic Images in BIP report Comment by Kevin M-Oracle Mar 13, 2025 1:55PM
Hi Frank, Most of the features in this section of the guide are not for RTF output, only PDF. Yes, you should test in Enterprise. Rgds, Kevin

in RTF Header using section break not showing as expected (Word / Template Builder) Comment by Kevin M-Oracle Mar 13, 2025 12:49PM
Hi Frank, I changed from section to page break. Used the layout dialog to set different first page and scope whole document. If worked as expected. Rgds, Kevin

in RTF Header using section break not showing as expected (Word / Template Builder) Comment by Kevin M-Oracle Mar 11, 2025 7:24PM
If you would like you can share your simple RTF and XML data, no PI or CI please. Or you can log an SR and provide those two files. Rgds. Kevin

in RTF Header using section break not showing as expected (Word / Template Builder) Comment by Kevin M-Oracle Mar 7, 2025 1:41PM

More Comments

MFA for Oracle Community

Welcome to the Oracle Analytics Community

Kevin M-Oracle Rank 6 - Analytics Lead

Comments