Popular Tags
- OTBI 1,506
- Reporting 1,423
- FDI 1,302
- Fusion AI Data Platform 1,055
- Analysis and Data Visualization 1,015
- BI Publisher 899
- Analysis 699
- Oracle Fusion Analytics 635
- OAC 590
- Administration 565
- Analytics 454
- Fusion HCM Analytics 449
- Fusion ERP Analytics 447
- OBIEE 444
- BI Publisher Data Models 371
- Security 305
- Oracle Analytics Cloud 300
- HCM 296
- Fusion Data Intelligence 285
- BIP 272
- Answers 266
- Analyses 258
- Developers 250
- Fusion Data Intelligence FDI 245
- Data Modelling and Datasets 238
SQL
Discussion List
-
Can we have a OTBI analysis based on a BI Publisher Report's output?Summary Can we have a OTBI analysis based on a BI Publisher Report's output? Content Can we have a OTBI analysis based on a BI Publisher Report's output? Regards, RashmiUser_MC37Q 220 views 9 comments 0 points Most recent by User_MC37Q Oracle Transactional Business Intelligence Forum -
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package. Content I am search…Tim Welsh 561 views 8 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum
-
OTBI - add a SQL column to a subject area analysisSummary Can you refer to a table using SQL and a subject area at the same time? Content Is it possible to add column to a subject area using SQL? I have tried editing th…Antony Hooper-29731 51 views 1 comment 0 points Most recent by venkata veeragoni Oracle Transactional Business Intelligence Forum
-
Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLSummary Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQL Content Hi All, We have a dashboard -Pipeline Time In Process which consists of bot…Ramesh Nakka 22 views 0 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence Forum
-
Is it Possible to Use an Alias for the Bursting Sender Info?Summary Is it Possible to Use an Alias for the Bursting Sender Info? Content We engaged a vendor to write some BI Publisher reports, which use bursting to send out email…Rebekah Baker 451 views 8 comments 0 points Most recent by Sricharan Monigari Oracle Transactional Business Intelligence Forum
-
Prompt Dashboard for cross subject areasSummary Prompt Dashboard for cross subject areas Content Hello, I have an analysis made by two subject areas (linked by an INNER JOIN) and the system puts "saw" alias in…Dario_DiFranceschi 53 views 2 comments 0 points Most recent by Jagadish Angadi-29558 Oracle Transactional Business Intelligence Forum
-
Oracle BI Publisher - Report on Report Job HistorySummary Find a way to acquire all Report Job History listed and extract all data to Excel Content Hi, I used to be an Apps DBA\Technical application Support on R12 EBS b…Barry Stamp-73691 141 views 1 comment 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum
-
Packages in BI publisherSummary Packages in BI publisher Content Dears , I am migrating some reports from EBS R12 into oracle cloud fusion . some of these reports SQL query contains standard pa…Islam Abu Khamseh-76822 61 views 1 comment 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum
-
Exceeded configured maximum number of allowed input recordsSummary Error message received when running report Content Hi, could someone explain why I get the attached error? Many thanks, Antony.Antony Hooper-29731 271 views 3 comments 0 points Most recent by Vijaya Kumar-70229 Oracle Transactional Business Intelligence Forum
-
How to get roles assigned to BI ReportsSummary How to get the roles assigned to BI Reports Content HiI need to a quick way (SQL or BI report) to get the roles assigned to reports (we have about 200 of them). …new.bi 41 views 0 comments 0 points Most recent by new.bi Oracle Transactional Business Intelligence Forum
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sql Content Hi, Anyone know how to fetch the manager name for the terminated employees? For…NIRMAL KUMAR L 125 views 1 comment 0 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence Forum
-
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard? Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull…Brenda Jacks-49721 171 views 5 comments 0 points Most recent by Sandor Banfi-52443 Oracle Transactional Business Intelligence Forum
-
OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Areakrishiveth 31 views 1 comment 0 points Most recent by krishiveth Oracle Transactional Business Intelligence Forum
-
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI Analysis Content I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less t…Brenda Jacks-49721 92 views 1 comment 0 points Most recent by rashid ramzan-45341 Oracle Transactional Business Intelligence Forum
-
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank details Content how do I create a audit report for employees bank details. This needs to show…Peter Kirwan 42 views 1 comment 1 point Most recent by Ruzwan Akram Oracle Transactional Business Intelligence Forum
-
Return Candidate Name only for Specific CSW Selection steps/statusesSummary How to modify my SQL statement to remove redundancies Content Hi! I've created a report to return all Open Requisitions as well as Filled Requisitions for the pa…Kim Welker 326 views 11 comments 0 points Most recent by Rahul Thomas Oracle Transactional Business Intelligence Forum
-
Help with my SQL CodeSummary Help with my SQL Code Content I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like…Ruzwan Akram 121 views 1 comment 0 points Most recent by Ruzwan Akram Oracle Transactional Business Intelligence Forum
-
SQL IS NULL errorContent Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…Aaron Leggett 91 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence Forum
-
Days on Hold CalculationSummary Need a days on hold formula for Legacy environment Content Hello - does anyone happen to have a days on hold formula for OBI in the legacy recruiting environment…Will Murphy 52 views 2 comments 0 points Most recent by Will Murphy Oracle Transactional Business Intelligence Forum
-
Building a BO subquery in SQLContent Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it..Anish Goswami 242 views 8 comments 0 points Most recent by Kiran Shenvi Oracle Transactional Business Intelligence Forum