Popular Tags
- OTBI 1,459
- Reporting 1,399
- FDI 1,155
- Fusion AI Data Platform 1,024
- Analysis and Data Visualization 994
- BI Publisher 868
- Analysis 685
- Oracle Fusion Analytics 599
- Administration 556
- OAC 489
- OBIEE 435
- Fusion HCM Analytics 417
- Analytics 411
- Fusion ERP Analytics 393
- BI Publisher Data Models 360
- Security 301
- HCM 270
- Answers 265
- BIP 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 221
- ERP Analytics Content 215
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 81 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 203 views 8 comments 0 points Most recent by Kiran Shenvi Oracle Transactional Business Intelligence Forum
-
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 32 views 0 comments 0 points Started by Murugappan Murugappan Oracle Transactional Business Intelligence Forum
-
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 Forum
-
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…TheoMC 22 views 0 comments 0 points Started by TheoMC 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 Started by Ramesh Nakka 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 Started by new.bi Oracle Transactional Business Intelligence Forum
-
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…
-
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 146 views 13 comments 0 points Most recent by Guillermo Bueno Oracle Analytics Forum
-
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…