Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,176
- Fusion AI Data Platform 1,030
- Analysis and Data Visualization 1,001
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 605
- Administration 556
- OAC 509
- OBIEE 435
- Fusion HCM Analytics 422
- Analytics 416
- 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
SQL
Discussion List
-
Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?Summary Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment? Content Hi Experts, I hope that most of you who have worked on an On-Premise syst…AshishERPCloud 121 views 5 comments 0 points Most recent by narasimha arekatla Oracle Transactional Business Intelligence Forum -
BI Publisher CSV files or Reading from Content Server sourceSummary Reading files on the Content Server in BI Publisher Content Hello, I'm trying to create a report in BI Publisher that will read an external file as a data source…Rob F 211 views 4 comments 0 points Most recent by user12182418 Oracle Transactional Business Intelligence Forum -
Need inputs to find who created/deleted the folder in Reports and AnalyticsContent Hi All, We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report? We need …Visu 231 views 4 comments 0 points Most recent by Tugce Kucukoner-144150 Oracle Transactional Business Intelligence Forum -
Trailing Spaces in OBIEESummary formatting question Content Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish. I have a report where I need to cr…Joy Hanneman-161050 151 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter? Content I need an Analysis with a filter to pick up dates within the last wee…Tim Welsh 2.4K views 17 comments 0 points Most recent by Kamran Butt-161785 Oracle Transactional Business Intelligence Forum -
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated values Content Hello, I have a need to see only the null values and future dates. I'm…slgott 262 views 2 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence Forum -
Filter for terminations in prior calendar weekSummary I'm creating a termination report and trying to show which terminations were in the calendar week (Sunday-Saturday) prior from the week when the report was run C…Karen B 92 views 3 comments 0 points Most recent by Lavanya Reddy Oracle Transactional Business Intelligence Forum -
Is Orders data available through the OTBI layer in Order Management / SCM?Summary Is Orders data available through the OTBI layer in Order Management / SCM? Content Is Orders data available through the OTBI layer in Order Management / SCM? Rea…Shalindra Singh 61 views 1 comment 0 points Most recent by Shalindra Singh Oracle Transactional Business Intelligence Forum -
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the prompt Content Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repo…Brenda Jacks-49721 291 views 1 comment 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum -
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 171 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 501 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 -
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 421 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 41 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 142 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 262 views 3 comments 0 points Most recent by Vijaya Kumar-70229 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 121 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 142 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