Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
Future Dated ActivitiesSummary Show Opportunities with Future Dated Activities tied to them Content I posted this to the Reporting and Analytics for Engagement Cloud forum but I don't have gre…slgott 72 views 3 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence Forum -
Customer hierarchy using BI Analysis (or OTBI)Content Hi All, I need to build a customer hierarchy report using BI Analysis (or OTBI). It should display Party Name, Party Usage and Primary Address. Can anyone help m…Rinku Gautam 286 views 6 comments 0 points Most recent by adelsorbo-Oracle Oracle Transactional Business Intelligence Forum
-
Subtract resulting values of CASE functionSummary Need to subtract two values that are first derived using the CASE function Content I have created two measure columns that use a CASE function. I am trying to su…Stephanie Golly-Oracle 396 views 3 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
How to get and SQL for our own OTBI AnalysisSummary SQL for OTBI Analysis Content Hi All, How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub que…Praveen Kumar-146357 125 views 3 comments 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence Forum
-
New features - BICCC 19A patchSummary Document for new features list in BICCC - 19A patch Content New features has been added to BICCC Application as part of 19A patch, it is very good, but it will b…Senthilrajan V 11 views 0 comments 0 points Most recent by Senthilrajan V Oracle Transactional Business Intelligence Forum
-
Oracle Fusion OTBI Direct Database Query/ReportSummary Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releases Content Creating Reports with Direct Database Query in Oracle Fus…Senthilrajan V 432 views 9 comments 0 points Most recent by Senthilrajan V Oracle Transactional Business Intelligence Forum
-
get greatest of two dates in OTBIContent Hi, I need to find greatest /least of two dates in OTBI using formula how can we do this in OTBI?Parthiban Vaithiyanathan-86705 102 views 6 comments 0 points Most recent by Prudence K Oracle Transactional Business Intelligence Forum
-
Dynamic date variables using 'Between' calendar date promptSummary How do I set dynamic, default server variables on a calendar date that uses 'between' dates? Content Hello, I want to set a default date value on my dashboard da…slgott 72 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
OTBI: OTBI Agent with SFTP DestinationSummary How to Setup OTBI Agent to export report results to SFTP Server Content Hello All, I have a request to export the result output of an OTBI report to an SFTP serv…Fongang 1K views 3 comments 0 points Most recent by User_5NGE4 Oracle Transactional Business Intelligence Forum
-
To Extract Order Header and Line details using OTBISummary looking for Sample query that works to get Header and line details of available orders using OTBI Content Hi, Can someone please provide me working sample query …Shalindra Singh 51 views 0 comments 0 points Most recent by Shalindra Singh Oracle Transactional Business Intelligence Forum
-
Any way to bypass the row LimitationSummary Bypass Row Limitation Content Is there anyway to bypass the row limitation? There are times I need to be able to analyze more than 25,000 rows of data. This is c…Robin Friedberg O'Connor 591 views 11 comments 0 points Most recent by Gustavo Erthal Oracle Transactional Business Intelligence Forum
-
Remove duplicate values in OBIEEContent Hi All, Is it possible to remove duplicate values in OBIEE? In my report, columns A and B have unique values per line for an employee, however, column G is all t…Natalie Andrek-27262 252 views 4 comments 0 points Most recent by RichardChan 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 292 views 1 comment 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
Create a LDAP Data source for OTBISummary Need to be able to access LDAP folders from OTBI Content Hi, We have a need to verify the usernames in EPM to the LDAP account names. This is because we have ins…user13046722 11 views 1 comment 0 points Most recent by Jessie Jones Oracle Transactional Business Intelligence Forum
-
Reporting on Current Payroll Balances for a colleague i.e P60 Rate, Holiday Rates, Court Orders (othSummary Payroll Reports or Fusion pages that display the individual colleagues current Balances Content Hello, Is anybody aware of a method in which we can view a collea…Brad Hughes 24 views 1 comment 0 points Most recent by RyanPatrick Oracle Transactional Business Intelligence Forum
-
Hired Candidates from the Cleared ListContent Dear All Is there a way I can add a subquery in one the columns of the report to indicate a if the cleared candidate has been hired for another position ? Thank …Rafael Cano Vidal 21 views 0 comments 0 points Most recent by Rafael Cano Vidal Oracle Transactional Business Intelligence Forum
-
Terminations ReportContent Hi I am currently trying to create a terminations report. I cannot find the following: - Termination Action - Termination Reason I am using the Workforce Managem…Aaron Leggett 678 views 8 comments 0 points Most recent by Jatinder Tanda 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 55 views 1 comment 0 points Most recent by venkata veeragoni Oracle Transactional Business Intelligence Forum
-
Self-Defined Candidate Facts - Yellow BoxSummary How to create a self-defined candidate facts using UDF Content Hi Experts, Could someone please walk me through how to create a self-defined UDFs with embedded f…Pofu Huang 34 views 3 comments 0 points Most recent by Pofu Huang Oracle Transactional Business Intelligence Forum
-
Prompts OBIEE not working in OTBIContent I have created a simple new analysis in OBIEE for leavers and added a prompt so the user can run the analysis between termination dates. This works fine when ope…David Bean-24463 11 views 1 comment 0 points Most recent by Karthik Vinodkumar-76683 Oracle Transactional Business Intelligence Forum