Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,178
- Fusion AI Data Platform 1,030
- Analysis and Data Visualization 1,001
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 606
- Administration 556
- OAC 509
- OBIEE 435
- Fusion HCM Analytics 422
- Analytics 417
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 275
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 237
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Publisher Forum
Explore Oracle Analytics Publisher (BI Publisher): pixel-perfect reports, bursting, templates, scheduling, integrations, troubleshooting, and best practices.
Discussion List
-
Oracle BI EE OTBI Query multi Select queryI have a query that was written as a Data Analysis in Oracle OTBI, and I am using it inside of BIP Data Model and I am structuring parameters for the Oracle BI EE logica… -
Need help in including the FLOW_ID in my BI Publisher reportIn my BI Publisher data model I’m using a custom SQL query that returns payroll balances driven from the standard payroll action tables: PAY_PAYROLL_ACTIONS, PAY_PAYROLL…
-
BI Publisher Word Add-inHello, I have built a custom report in ARCS where we have displayed all unmatched transactions in ARCS with their aging bucket, number of transactions and the amount. We… -
Oracle Kubernetes - PDF printing on a Kubernetes Weblogic BI serverI install and maintain an Oracle Analytics Publisher that runs on Weblogic for the purposes of printing PDFs from APEX. It is nothing more than the PDF printer. The curr… -
please help with table/ BI SQL query to fetch Work Workday Patterns detailsHi All, Could you please help with table/ BI SQL query to fetch Work Workday Patterns details that we create under setup and maintaince > Workforce Information > Work Wo…
-
BI Publishing to Object Storage OCI PoliciesHi Folks, I wonder ifany of you OCI gurus have found a solution to my issue. When I try to connect my BI publisher Delivery to Object storage using the documentation and… -
BIP report to get the approval status with history and attachments for Leave encashment, salary trasHi Experts Could you please help me with the BIP report sql query on how to get the approval status for Leave encashment, salary transfer letter requests along with appr…
-
Rowmark visible on export output of BI Publisher Report with excel templateHi, I created an excel template based bi publisher report using sql query. Expected Output Country Region State County Item Sales Germany North W1 C1 Laptop 20 Mouse 22 …
-
Need help with Cost Accounting Distributions CodeHy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation account c…
-
Need BIP report SQL query to get GL Balances by Posting Date in oracle FusionNeed BIP report SQL query to get GL Balances by Posting Date
-
How to send multiple files from "split by" in one email by "deliver by" ?Bursting a report we want to send every invoice, dunning, etc as a separate PDF/Excel, but in one email per customer . I thought this could be done by configuring the "S… -
Whenever I try and reference a where clause key flexfield it inserts null into my sql scriptHello, Version: Oracle Analytics Public 12.2.6.4.0 I have a simple query that like the following: SELECT TOWN, STRNUM, STRNAME FROM CUST.ADDRESS WHERE STRNUM > 100 I als…
-
Conditional Region within repeating group?So, I'm trying to create a conditional region inside of a repeating group. There are xsl attributes as part of the if code. However, I get an error saying "element xsl i…
-
How to call dbms_crypto package from Oracle BI publisherWe have a requirement to call dbms_crypto.encrypt package from BI publisher to encrypt sensitive data at the column level. So i have 2 questions: When we select Data Sou…
-
BI Publisher - Suppress Repeating Values in RTF template?In BI Publisher, I have a table inserted and would like to suppress repeating value for a column. How would I go about doing this?
-
Using BIPublisher RTF template how to create protected word outputs ?I am using BI Publisher RTF templates to generate WORD output reports. The requirement is to have the Word output report "protected" so that Users cannot change the valu…
-
How do I view the HTML output of a Oracle BI Publisher report with 700 thousand rows?Hi everyone, I'm currently using BI Publisher embedded in Oracle Analytics Server 2024. I have a report that uses 2 parameters: P_BRANCHES and P_DATE For P_BRANCHES = 'A…
-
Dunning Letter File naming within the zip file.Currently, using Bursting, I am able to place the “Dunning Letter” output zipped PDF files with naming convention ("Dunning_'Dunning_id'.zip") directly into the SFTP loc…
-
BIP report's header to be that column's Property > Label when output format is .csvHi Experts, I would like to reach out to you for my question below: The BIP report is having Subject Area (Supplier - Supplier Real Time) as the data source. And I am si…
-
How to convert number to text for non-English languageWe have a requirement to show the Total Amount of Purchase Order into words in rtf. We were able to display it in English, but the requirement is to display in a non-Eng…