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
-
Running into a problem using Pivot tables in Release 12Summary Running into a problem using Pivot tables in Release 12 Content We upgraded to Release 12 on September 25, 2017. Prior to the upgrade, I was able to create pivot…Robin Friedberg O'Connor 72 views 2 comments 0 points Most recent by Sudheer amilineni Oracle Transactional Business Intelligence Forum -
Scheduler IssuesSummary Experiencing intermittent errors with scheduled reports Content Is anyone else experiencing any issues with scheduled reports? In the last 24 hours, a couple of …Andy French 163 views 7 comments 0 points Most recent by Sakshi Batra-39119 Oracle Transactional Business Intelligence Forum
-
Length function issueSummary Please use CHAR_LENGTH instead of LENGTH Content In OBI, there is an issue with the LENGTH function where it causes the report to take up multiple times the norm…Stephane Cote-Oracle 21 views 0 comments 0 points Most recent by Stephane Cote-Oracle Oracle Transactional Business Intelligence Forum
-
Data model with parameter with "Select all"Summary Data model with parameter with "Select all" Content Hi, we created a data model based on several analisys and we want to add a parameter which filters by Employe…Giuseppe 1234 1.4K views 10 comments 0 points Most recent by Nirmal-64675 Oracle Transactional Business Intelligence Forum
-
Time in role reportSummary I need to create a time in role report Content I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Empl…Peter Kirwan 73 views 2 comments 0 points Most recent by Clyde Ramcharan-61521 Oracle Transactional Business Intelligence Forum
-
Bursting ReportSummary A report on Probation which bursts out to Line Managers Content is there any example reports which look at Probation Period? Also sample reports for Bursting?Peter Kirwan 53 views 1 comment 0 points Most recent by Sowdhaminya Murugan Oracle Transactional Business Intelligence Forum
-
Access Denied for user to path..Summary Access Denied for user to path.. Content Hi, I'm a super user and have high level of security, but in the Report when I select Admin View and look at specific us…AbulKhair 507 views 1 comment 0 points Most recent by Rick Brobbel 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 141 views 5 comments 0 points Most recent by Sandor Banfi-52443 Oracle Transactional Business Intelligence Forum
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all data Content Any suggestions on how to get the subtotals added to this report? Example below, want totals f…Michelle Slobig Rotsolk 332 views 1 comment 0 points Most recent by Manoj Madhavan Oracle Transactional Business Intelligence Forum
-
Missing Name Infomration in Subject AreaSummary Cannot find field for Preferred Name, Employee Salutation, etc Content I cannot find the following fields in the worker or any other subject area. Preferred Name…Thomas Drzaic 183 views 4 comments 0 points Most recent by AbulKhair Oracle Transactional Business Intelligence Forum
-
Conditional FormattingSummary Conitional Formatting is not working properly Content I have created a report to help our teams identify at risk background checks. The report uses OBI condition…Tristan Hindes-55332 52 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
InitCap without EvaluateSummary Trying to arrive at "normal" case for names without Evaluate function Content Names in our system are entered inconsistently and the goal is to be consistent wit…Rob F 63 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…Aaron Leggett 12 views 0 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum
-
How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12? Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/una…Gala Meyerovich 96 views 4 comments 0 points Most recent by Gala Meyerovich Oracle Transactional Business Intelligence Forum
-
Embedded Reporting/BI PublisherSummary audit report using offer fields Content Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for th…Alice Kim, SPHR-SCP 107 views 5 comments 0 points Most recent by Alice Kim, SPHR-SCP Oracle Transactional Business Intelligence Forum
-
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variable Content Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI anal…Giuseppe 1234 321 views 2 comments 0 points Most recent by RichardChan 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
-
Two Pivot Tables with Different ValuesContent Hi I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type co…Aaron Leggett 31 views 0 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum
-
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI Analysis Content I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less t…Brenda Jacks-49721 91 views 1 comment 0 points Most recent by rashid ramzan-45341 Oracle Transactional Business Intelligence Forum
-
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 42 views 1 comment 1 point Most recent by Ruzwan Akram Oracle Transactional Business Intelligence Forum