Popular Tags
- OTBI 1,407
- Reporting 1,365
- FDI 990
- Analysis and Data Visualization 953
- BI Publisher 820
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 550
- OBIEE 421
- Analytics 347
- OAC 339
- BI Publisher Data Models 335
- Security 273
- Answers 261
- Analyses 253
- Developers 240
- HCM 239
- BIP 233
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 41 views 1 comment 1 point Most recent by Ruzwan Akram Oracle Transactional Business Intelligence -
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 192 views 11 comments 0 points Most recent by Rahul Thomas Oracle Transactional Business Intelligence
-
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 105 views 1 comment 0 points Most recent by Ruzwan Akram Oracle Transactional Business Intelligence
-
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 71 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence
-
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 41 views 2 comments 0 points Most recent by Will Murphy Oracle Transactional Business Intelligence
-
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 153 views 8 comments 0 points Most recent by Kiran Shenvi Oracle Transactional Business Intelligence
-
MD5 encryption in RTF templateSummary In BI Report output using RTF template, need to to include a URL string which is formed using multiple flex field values and need to encrypt that particular URL …Murugappan Murugappan 31 views 0 comments 0 points Started by Murugappan Murugappan Oracle Transactional Business Intelligence
-
How to build an inventory analysis coupled with time constrained measure?Summary An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measure…Jonathan Chan gmg 1 view 0 comments 0 points Started by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
How to modify the content of a column through a result similar to RPADSummary How to modify the content of a column through a result similar to RPAD - we want to create a report that will need to have a specific lenght per column & wish to…
-
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 21 views 0 comments 0 points Started by Ramesh Nakka Oracle Transactional Business Intelligence
-
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). …
-
How to perform function on a multiple value parameter?I'm trying to perform a function on parameter with multiple inputs oracle BI. It's a LoV parameter where u can select multiple values. It shows invalid number of argumen…
-
Merging two reportsHi everyone, I have two separate reports that I would like to run. Both run fine on their own, but when adding all the columns to one of the reports I get multiple error…User_O3GFE 45 views 6 comments 0 points Most recent by [Deleted User] Oracle Analytics Cloud and Server
-
Pivot resultsHello all, When I try Pivoting the result of one of my queries, OBIEE gives me an error saying there are too many variables. Is there a way to pivot the data i'm queryin…Guillermo Bueno 101 views 13 comments 0 points Most recent by Guillermo Bueno Oracle Analytics Cloud and Server
-
How to modify this complex join in OBIEE Answers?How do I achieve below join condition for one specific report in OBIEE 12c Answers? Select * from A right outer join B on (a.id = b.id and a.entity is not null) I have d…
-
Help with Advanced Editor Raw SQL SyntaxHello all- Thank you for reviewing my Advanced Editor SQL Question. I have two queries that work alone by themselves. I want to add or subtract these numbers together. H…mrmmickle1 71 views 10 comments 0 points Most recent by [Deleted User] Oracle Analytics Cloud and Server