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

Again, if you do not see the data you expect, the data engine log can be a very helpful tool in troubleshooting your custom data model. Rgds, Kevin

in BI Publisher report doesn't fetch data for a global level function. Comment by Kevin M-Oracle Sep 10, 2024 6:19PM
See Formatting Dates in Rgds, Kevin

in Excel is not considering my date value as date even after I tried many formatting? Need suggestion Comment by Kevin M-Oracle Sep 10, 2024 2:05PM
The template viewer does not execute global functions. It just uses static XML data and runs it against the layout template. This issue is occurring during the data generation phase. So you have to troubleshoot the global function in the Data Model. The data engine log is a good resource to see why the functions are not…

in BI Publisher report doesn't fetch data for a global level function. Comment by Kevin M-Oracle Sep 10, 2024 1:53PM
Water Marks and background images are supported for PDF and PPT output only. You could try using shapes. They are supported with Shapes in HTML output. Adding Text to Shapes See: Rgds, Kevin

in Assistance with Moving Image Behind Text in RTF Template Rendered as HTML in Oracle BI Publisher Comment by Kevin M-Oracle Sep 3, 2024 1:49PM
Check the Jobs page, do your jobs show there? Check the Administration→Scheduler Diagnostics page, any errors or warnings? If so, I would suggest you log an SR for assistance. Rgds, Kevin

in I am running report (BIP) but when checking in job History there are no running jobs, Why? Comment by Kevin M-Oracle Aug 29, 2024 1:20PM
See: Rgds, Kevin

in We developed BI reports in English but user wants based on local Language want how to show data ? Comment by Kevin M-Oracle Aug 29, 2024 1:18PM
You are welcome. Kevin

in Can another font be added to Analytics Publisher (Cloud)? Comment by Kevin M-Oracle Aug 28, 2024 5:59PM
You need to have the BI Service Administrator role. Rgds, Kevin

in Can another font be added to Analytics Publisher (Cloud)? Comment by Kevin M-Oracle Aug 28, 2024 4:15PM
Yes, go to Administration →Manage Publisher→Font Mapping. There is a button to upload custom fonts. Rgds, Kevin

in Can another font be added to Analytics Publisher (Cloud)? Comment by Kevin M-Oracle Aug 28, 2024 3:50PM
I would suggest you reorder the data, select the reps first, have the employees be dependent on the reps. Rgds, Kevin

in Bursting Report Comment by Kevin M-Oracle Aug 27, 2024 2:37PM
For Fusion Application, please post to the CCC - Cloud Client Connect. Rgds, Kevin

in Is it possible to run the procedure in Oracle BI Publisher ? Comment by Kevin M-Oracle Aug 26, 2024 2:34PM
Best to do that in the data model, so you can display tabular data using a template. Rgds, Kevin

in RTF Template - I want to print the sum of salary where account=77000 in RTF templete. Comment by Kevin M-Oracle Aug 23, 2024 2:39PM
Login to /xmlpserver. Go to the catalog, select the data model, More→Download. Kevin

in How to edit the sales order Report data model Comment by Kevin M-Oracle Aug 23, 2024 1:18PM
We need more details to assist. Basically, for-each whatever [account=77000] end for-each sum(salary). Rgds, Kevin

in RTF Template - I want to print the sum of salary where account=77000 in RTF templete. Comment by Kevin M-Oracle Aug 23, 2024 12:50PM
If you add a variable (parameter) in a script, you have to declare it in the database package. Rgds, Kevin

in How to add a parameter when calling a function from the trigger section Comment by Kevin M-Oracle Aug 13, 2024 12:18PM
The package in the database has to be updated, add the parameter. Rgds, Kevin

in How to add a parameter when calling a function from the trigger section Comment by Kevin M-Oracle Aug 12, 2024 2:49PM
Hi Gabriel, It depends on the data you are splitting by. You only need one layout for bursting. Rgds, Kevin

in Bursting BIP report to different emails by respective business units Comment by Kevin M-Oracle Aug 5, 2024 4:43PM
You should use a different layout for the full report and for the bursting subset of data. For example if you are splitting on G_1, the layout should not have for-each:G_1 or reference data that is not part of G_1. Rgds, KEvin

in Bursting BIP report to different emails by respective business units Comment by Kevin M-Oracle Jul 30, 2024 12:19PM
You can use the parameter value to create a dynamic filename. See Passing a Parameter to the Bursting Query: Rgds, Kevin

in Query of Report BI Publisher Oracle Cloud. Bursting Comment by Kevin M-Oracle Jul 30, 2024 12:15PM
What was the result? Kevin

in Could please let me know I have only one group how to split into multiple sheets in oracle EBSR12 Comment by Kevin M-Oracle Jul 23, 2024 3:49PM

More Comments

MFA for Oracle Community

Welcome to the Oracle Analytics Community

Kevin M-Oracle Rank 6 - Analytics Lead

Comments