Kevin M-Oracle

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: https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#GUID-A43F6006-8FE9-4A20-9C5C-547CDD605E70…

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: https://docs.oracle.com/middleware/bi12214/bip/BIPAD/GUID-70A13B37-330A-4DA4-B445-9EB61DF128D9.htm#GUID-70A13B37-330A-4DA4-B445-9EB61DF128D9 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: https://docs.oracle.com/middleware/bi12214/bip/BIPDM/GUID-A926D588-426F-47C7-8A9A-B0A7959C5814.htm#GUID-CFCC739C-0F9A-49D6-AD05-06A37EE22C9F 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

You are welcome. Rgds, Kevin

in Freeze the First-Few-Columns in Interactive View -BIP Comment by Kevin M-Oracle Jul 23, 2024 12:44PM

That is not a current feature. Log it in Idea Labs. Rgds, Kevin

in Freeze the First-Few-Columns in Interactive View -BIP Comment by Kevin M-Oracle Jul 23, 2024 12:19PM

Welcome to the Oracle Analytics and AI Community

Kevin M-Oracle Rank 6 - Analytics & AI Lead

Comments