Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,077
- Analysis and Data Visualization 980
- BI Publisher 844
- Analysis 675
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 431
- OAC 421
- Analytics 394
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 256
- Analyses 253
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 203
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 158
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Publisher
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
-
Conditional font color setting is not working for pivot table based BIP in oracle fusionHi , I need to set the font color as red for negative measure values getting pivot table based BIP report. I found the doc id 23A Known Issue related to conditional colo… -
Bursting BIP report to different emails by respective business unitsHello guys, am super new to bursting. I am facing an issue with bursting an excel attachment which has 3 tabs (a detailed report, +2 summarized tables by buyer name). Th…
-
Inconsistent behavior of conditional formatting with Row contextI am using following code in my RTF template to set background gray for the alternative rows. #d9d9d9 This works. When I use the similar code to set the top border of t… -
Is there any way to get around - ORA-01795 : Maximum number of expressions in a list is 1000I have created a secondment report, and the business want a parameter in Oracle BIP with Locations. However we have over 1000 active locations. SELECT location_name FROM… -
Creating Trend Line charts using BIP Offline Editor for WordHave been grappling with how to generate time based trend charts to track status trends. For example, the source data is in this general format: Record 1 - Opened 10/01/…
-
Bursting and JDBC connection error for publisherHello, Our goal is to enable the bursting option for a publisher data model. We created a table to store bursting parameters in our Autonomous Database. However, we are …
-
BIP Reports are ending in Error with ORA-56733: logical I/O limit exceeded - call abortedCustom Scheduled BIP Reports are ending in error with the below details. The Report ran approx 1 hour and got ended in error. Error getting report data [INSTANCE_ID=bip.…
-
How does CD_TRX_AMOUNT xml tag is getting generated "Create Customer Statements" report ?I am trying to customize the "Create Customer Statements" report in oracle fusion, for which I needed to add one column in "G_LINE_CLUSTER" group. As soon as I am editin…
-
Query of Report BI Publisher Oracle Cloud. BurstingHi, I have created a report with the Bi publisher and I have a bursting where I indicate the name of the file among other things. It works fine but I would like to know …
-
Print Receivables Transactions : Provide Confirmation of Invoice Email DeliveryHi Team, In AR Invoice Printing process, After sending the invoice copy to customer is there a way to access the .msg files send to customers as proof of delivery. We ne…
-
Etext output is delivered as .txt (Incorrect) on email but as .csv (correct) on FTP BIP 11gSummary Etext output is delivered as .txt (Incorrect) on email but as .csv (correct) on FTP BIP 11g Content Hi, We are using BI publihser 11g and need to deliver .csv ou…
-
Exit from XSLT after one match is found in payment templateHi All , I have a below code XSLT code , where I want to exit from the for each loop if the first match is found. The ID tag inside the for-each loop should be printed o…
-
Schedule a Publisher ReportOur goal is to create a publisher report to schedule, in order to send the report via email to a group of users. We have successfully configured email delivery in the ap…
-
Superscript in the Date ex: 1st July 2024I have a requirement to get the superscript after date. Currently am using select to_char(sysdate,'ddth Month,YYYY','NLS_DATE_language=American') from dual Output: 1st J…
-
Bursting to UCM not consistentHi, I have a simple report that needs to burst the output to UCM. It is not working consistently. Can you please provide pointers as to what could be the issue. I have f…
-
Extract all the SQL queries of different BI Publisher reportsHello, I have many reports and I want to extract all the Sql queries of their data model. I can't do it manualy because I have more than 100 reports. Can I find a way to…
-
Oracle cloud table for Sales AgreementsWhat is the the Oracle cloud table for Sales Agreements, We need the Agreements name,Effective Start and End date ,signed date, sales rep and price list etc In R12 we ha…
-
backend table/column associated with field "Budget Amount Entered As" on Review Budget entries pageHi Experts, Though I am able to locate most columns in tables: XCC_BUDGET_ACCOUNTS , XCC_BUDGET_DIST_ACCTS , XCC_CONTROL_BUDGETS , XCC_BUDGET_DIST_HEADERS — which table/…
-
When we run the Pick Slip Report, the "Sales Order Line Number" appears in the incorrect sequenceThis is due to "Sort By I tried commenting out the order by clause, but the sequence was still incorrect. Then, I attempted to change the P_SORT_BY parameter, which is b…
-
how can I display days off for an employee when there is neither time in nor time out on these daysI have an issue that I need to display employee days off as "day off". For example, I have an employee whose days off are from 10:00 to 18:00 (Friday & Saturday), and hi…