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

The requirement is Excel.

in How to create a string formula in BI Publisher from joined Data Sets Comment by Dclay May 24, 2018 7:00AM
I am relatively new to BI Publisher, not sure where this formula should be added. I have linked the data sets, generated the xml; should this be added when I create the report? If so, where?

in How to create a string formula in BI Publisher from joined Data Sets Comment by Dclay May 23, 2018 7:00AM
I am not creating an RTF template, this will be an interactive report that will be exported to Excel. Columns in Horizontal Layout: "tc_cde" "DP_rid" "last_nme" "first_nm" "addr1" "addr2" "cty" "st" "zip" "recip_lang" "age" "phys_first_nme" "phys_last_nme" "ctr_nme" "tcc_first_nme" [if "TC_COORD_FIRST_NAME" is null then…

in How to create a string formula in BI Publisher from joined Data Sets Comment by Dclay May 23, 2018 7:00AM
We are using OBIEE 11.1.1.7. I have tried this in Google Chrome and IE 11 without success. I do not see an nqquery.log file but I have included the last 100 lines from our bipublisher.log file below. [2018-04-23T10:30:10.333-05:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 56] [userId: <anonymous>] [ecid:…

in Error while creating BI Publisher Data Set with Oracle BI Analysis Comment by Dclay Apr 23, 2018 7:00AM
Worked. Thanks.

in How can I schedule a burst in BI Publisher for an email to include an attachment in Excel format and Comment by Dclay Mar 20, 2018 7:00AM
No, we are not using APPS. They do not want use to use APPS due to that it has to it has too high of permissions. We need assistance on how we should setup permissions to this function as a non-apps user.

in How to access APPS packages, functions used in Discoverer in OBIEE BI Publisher Comment by Dclay Oct 10, 2017 7:00AM

Welcome to the Oracle Analytics Community

Dclay Rank 3 - Community Apprentice

Comments