Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,174
- Fusion AI Data Platform 1,028
- Analysis and Data Visualization 999
- BI Publisher 870
- Analysis 685
- Oracle Fusion Analytics 603
- Administration 556
- OAC 506
- OBIEE 435
- Fusion HCM Analytics 419
- Analytics 414
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 274
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 232
- 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
OTBI Reports
Discussion List
-
View and Layout in OTBIHi, Is there any document / video which shows how to make changes in a view and in a layout and the relationship between the two. Also, is there a way to make changes to…Pavan Cheruvu-Oracle 24 views 7 comments 0 points Most recent by Pavan Cheruvu-Oracle Oracle Transactional Business Intelligence Forum -
Is BI Administrator role alone sufficient to access all reporting data in OTBI ?If a user already has the BI Administrator role in SaaS Fusion, do they still need additional data roles along with AP Manager or GL Manager to view data in OTBI reports…User_BR9YB 32 views 4 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
Access run history & older report outputs of OTBI scheduled reportsHi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output o…Ameya_J 12 views 5 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
How to view an OOTB report in OTBI?Hi experts, i am trying to open/view the report from OTBI, but the open field is greyed out and when i try to edit and click on view report to open it - nothing is happe…Srikar Pusuluri 15 views 5 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
What is the maximum number of rows that an OTBI report can fetch correctlyI am trying to write an OTBI report from Fusiuon on Payables and I am seeing some incorrect values on invoice amount and few other fields. I am not sure if it is because…Arnab Das 14 views 5 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
Current Year Promotion ReportI want to get the promotions of current year in OTBI report, I am getting it but the if there is any action after promotion then system is not picking that employee reco…Nazera Shabnam. 64 views 6 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
225000 rows which is Maximum data rows exported from the analysis into CSV using scheduled agentHi Team, We have requirement for extracting more than 25000 rows while we want to export using scheduled agent. Maximum data rows exported from the analysis into CSV, Ta…Sravan Kumar K 22 views 2 comments 2 points Most recent by RVohra Oracle Transactional Business Intelligence Idea Lab -
How to apply group by on a column in OTBI in Oracle Fusion Cloud?Hi everyone, I am working with OTBI in Oracle Fusion Cloud and I need to group by Creation Date (Subject Area → "- Supplier Organization"."Creation Date") one aggregated…NikhilYadav 21 views 2 comments 0 points Most recent by NikhilYadav Oracle Fusion AI Data Platform Forum -
2Provide Total Pages option in OTBI HeaderWe are not able to print Page number (that is available) of Total pages (that is not available in Print & export options>Header). And this is a standard/vanilla need in …VDM_IM 11 views 1 comment 2 points Most recent by AmitGoel Oracle Transactional Business Intelligence Idea Lab -
Can you please share any OTBI seeded AP Dashboard's ?Hello I was wondering if you could please share with me any OTBI Dashboard that include any AP's KPI's Thanksmartingabriel Kinovisques 22 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
Workforce Performance - Performance Check-In Real Time - issue with table promptsHello, I have following OTBI analysis : SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT0 s_0,"Workforce Performance - Performance Check-In Real Time".…MariaStanciu 12 views 2 comments 0 points Most recent by MariaStanciu Oracle Transactional Business Intelligence Forum -
Status field for Employment Contracts (Oracle HCM)Hello experts, we are creating an OTBI report with the Employment Contracts Real Time subject area and we have seen that it is available the fields Status and Status cod…Oriana L. 11 views 1 comment 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
What privilege grants access to data in the Purchase Order Measures folder columns?I have a user who is trying to use columns from the Purchase Order Measures folder in the Procurement - Procure to Pay Real Time subject area. I've created a custom role…Selene Becerra 21 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
Display the attachment URL in OTBI reportHello Team, I am trying to display the highlighted value in an OTBI report. Can anyone help me find where I can find this so that I can add it to my OTBI analysis? Thank…User_JB90I 11 views 2 comments 0 points Most recent by JohnW-Oracle Oracle Fusion AI Data Platform Forum -
OTBI duplicate linesHi. Does anyone have any idea how to deal with duplicate lines in OTBI? The subject are we are using is Receivables - Standard Receipts Application Details Real Time. We…missy_21 92 views 9 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
Create Customer Statements Seeded Bursting Logic Fails for International CustomersHi, is anyone experiencing this error? ####[2025-09-09T17:48:48.847+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ … -
Context Value in Work Relationship subject areaHello experts, does anyone can help me better understand what type of information refer to the following fields of the Workforce Management - Work Relationship Real Time…Oriana L. 21 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
How to fetch the lookup codes and lookup Types created in Fusion HCM into OTBI reportHello All, we are using a OTBI analysis (Subject Area - Workforce Learning - Learning Records Real Time) to fetch the Learning Records for a few particular courses. so, …KarthikDamamkar 171 views 8 comments 0 points Most recent by Abhisek Choudhury Oracle Transactional Business Intelligence Forum -
How to create an OTBI report to count all employees with no goals assignedHello, Need to create an OTBI report to count all employees with no goals assigned or with no individual goals assigned. When using the Workforce Goals - Goal Status Ove…MariaStanciu 11 views 1 comment 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
How to get industry name from receivables in otbi(receivables-customer real time)Hi we are joining two subject areas receivables-customer real time and receivables-transactions real time through (bill to customer number and organization number), we a…Ani_tha 21 views 3 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum