Popular Tags
- OTBI 1,492
- Reporting 1,414
- FDI 1,251
- Fusion AI Data Platform 1,049
- Analysis and Data Visualization 1,015
- BI Publisher 888
- Analysis 696
- Oracle Fusion Analytics 627
- OAC 570
- Administration 561
- OBIEE 443
- Fusion HCM Analytics 440
- Analytics 437
- Fusion ERP Analytics 434
- BI Publisher Data Models 366
- Security 311
- HCM 294
- BIP 272
- Oracle Analytics Cloud 271
- Answers 267
- Analyses 257
- Developers 249
- Fusion Data Intelligence 242
- Data Modelling and Datasets 237
- ERP Analytics Content 221
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
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 444 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 109 views 6 comments 0 points Most recent by Prudence K Oracle Transactional Business Intelligence Forum
-
Filter on Last Day of Previous Month (Criteria)Can someone please advise me why I can't use this as a SQL Filter? "Gregorian Calendar"."Date" = TIMESTAMPADD(SQL_TSI_DAY , -(1), TIMESTAMPADD(SQL_TSI_DAY , DAYOFMONTH("…
-
titlebodyDTCC Admin 21 views 0 comments 0 points Most recent by DTCC Admin 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
-
Performance Review Manger and Worker RatingSummary Performance Issue - Please help Content Hi All, I have built "Performance Review Manger and Worker Rating" report which was working fine till yesterday but today…Divya Joy 67 views 3 comments 0 points Most recent by [Deleted User] 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 63 views 1 comment 0 points Most recent by Shalindra Singh Oracle Transactional Business Intelligence Forum
-
OTBI Report Date Format is not holding when exporting to ExcelSummary OTBI Report Date Format is not holding when exporting to Excel Content I have a report and the date format is set to the local time zone. The date is formatted c…Robin Friedberg O'Connor 461 views 5 comments 0 points Most recent by Julian Challenger-Oracle 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 633 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 253 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 293 views 1 comment 0 points Most recent by RichardChan 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 21 views 1 comment 0 points Most recent by RyanPatrick Oracle Transactional Business Intelligence Forum
-
Report not attached in email coming from agentSummary is there a size limit to the file Content We currently have a scheduled agent for a report that comes out as a csv report. However, the report is not shown as an…Kevin Lee Choon 182 views 5 comments 0 points Most recent by Julian Challenger-Oracle Oracle Transactional Business Intelligence Forum
-
Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?Summary Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used? Content Hi, Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is…Aloka Bhattacharya 362 views 5 comments 0 points Most recent by Aloka Bhattacharya 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
-
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 172 views 9 comments 0 points Most recent by User_MC37Q 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 712 views 8 comments 0 points Most recent by Jatinder Tanda Oracle Transactional Business Intelligence Forum
-
OTBI Reports - Disable Excel optionSummary Can we hide 'Excel 2007' option under Export for OTBI reports Content Hello All - We have an issue with downloading OTBI reports to Excel. it doesn't download al…Naveen Bitra 229 views 7 comments 0 points Most recent by Naveen Bitra Oracle Transactional Business Intelligence Forum
-
Restoring a deleted folder in catalogueSummary Accidently deleted a folder. Is there a way to restore the folder? Content Hi I accidently delelted a folder in the fusion OBI catalouge. Is there a way to be ab…Mohit Gupta-45440 1K views 4 comments 0 points Most recent by Mohit Gupta-45440 Oracle Transactional Business Intelligence Forum