Popular Tags
- OTBI 1,458
- Reporting 1,399
- FDI 1,153
- Fusion AI Data Platform 1,024
- Analysis and Data Visualization 994
- BI Publisher 868
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 488
- OBIEE 434
- Fusion HCM Analytics 417
- Analytics 411
- Fusion ERP Analytics 390
- BI Publisher Data Models 360
- Security 301
- HCM 270
- Answers 265
- BIP 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 221
- ERP Analytics Content 215
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Publisher Forum
Ask questions in the Oracle Analytics Publisher forum to get help from peers and experts. Receive answers from Publisher's top customers and developers.
Discussion List
-
How to print a Paragraph which has multiple conditionswe have requirement to print time off paragraph for employees belonging to 4 states and grade not equal to 99. other paragraph where employee belonging to one state and … -
where can i find the tables in hcm related to currency conversion rates and tax deduction detailshi where can i find the tables in hcm related to currency conversion rates and tax deduction details masters where details are stored for our reporting
-
Split worksheets multiple timesWe are using BI Publisher Excel template (97-2003) . We have data that can exceed the row limit of 65k rows. This template has 3 tabs/worksheet each can exceed 65k. How …
-
Convert a number to a fraction BIP reportHi all, Is there a function sql to convert a number to fraction using a BIP report in Oracle HCM? For example if I have 0.25 FTE value, I want to print the fraction 1/4.…
-
Report output require in one rowHello BI Expert, I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be gre…
-
Font issue in the BIP report output when login with different sign in languageWhen I run the BIP report with English as sign in language,the output font is Arial whereas when run the same report with Japanese as sign in language, the output font i…
-
How to add a trigger that will skip running report if no data returnedI'm running multiple reports throughout the day that will show as failed if there are no results to the report (which is expected sometimes). My analysts have to go and …
-
Report output require in one rowHello Expert I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be greatly…
-
BI Publisher errorHi Job fails for Data model>bursting and the error code is this: does anyone know what is the issue? Waiting Time: 0.7 seconds Data Fetch Time: 10.4 seconds Total Execut…
-
Help with Development of Payroll GL Report in BIPGood Day, We're preparing for go live at the end of this month on Oracle Fusion Cloud. Our team is learning OTBI and BIP in preparation for this, and I have a question r… -
I want query for below columns, for AR Invoice Integration Exception report using interface Tables.Columns are ACCOUNT_CLASS, Distribution_Account, description, Invoice_Number, Distribution_Amount, Payment_Term, Currency, GL_DATE, Error_Reason, Ship_To_customer_Name, …
-
Oracle bursting syntax error in FusionError while compiling bursting query: java.io.IOException: prepare query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near : Syntax error [nQSEr…
-
Can’t install BI Publisher for desktopHello, I'm trying to install Oracle Analytics Publisher for desktop however I have the following error "Another version of this product is already installed. Installatio…
-
Can we print an image attachment from UCM in BIP reportWe have a requirement to print an image attachment stored in UCM in a custom BIP report. In order to print this image in BIP report, we need the base64 encoded image dat…
-
How to manage dimensions of an image within a BIP report when generating output in Excel format?I have successfully managed to retrieve an image from the file system, and while I am able to display it in a standardized size of my choosing (e.g. width="300px" height…
-
Display Employee Image in RTF template with Color borderDear Community Is there any way to display employee image in rtf template with color border. I am using below code, image is appearing perfectly but how add border to th…
-
How can we view all schedules for a report scheduled to run daily?Hi, We have a report scheduled to run daily, from 27/08/2022 until 27/08/2050. When going through the daily schedules, noticed these are generated just until 22/06/23. H…
-
BIP and BICC Deployment QuestionsWe have the following questions related to deployment of BICC Datastore extracts and BIP files... • Do we want to deploy DataStore metadata or Datastore extracts for BIC…
-
email bursting query issue with xml clob dataSummary email bursting query issue with xml clob data Content I am getting below error while using the xml clob data in email bursting query, can we use the xml clob dat…
-
Please could someone point me in the direction of the Reports to Analytics/BI conversion assistantThe Oracle documentation says this is located in http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html but I cannot find it here, the most recen…