OTBI
Discussion List
-
How to adjust default selection in Line manager dashboardSummary Change default selection in Line manager dashboardContent In the Line Manager Dashboard by default one BU is marked. I want to change this to 'All'. I have copie…Wouter.Schaap 71 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM -
Conditional Formatting in a BIP GraphSummary Conditional Formatting in a GraphContent Hi I have the requirement of conditional formatting to graphs in a Report, e.g., if the amount outstanding is less than …Misael Gutiérrez-Oracle 48 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
Dashboard column prompt issueContent Hi , Storing User Person Type in presentation variable and passing to logical sql , the issue is numeric values is getting passed instead of selected value, what…User_7836 55 views 6 comments 1 point Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
Time to First PromotionContent Hi All, We're trying to measure time to first promotion (or the tenure an employee has on average before they're first promoted). Wondered if anyone has had luck…Lauren Owen 53 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI DrillDown reporting questionSummary is there a way where we can display child drilldown report output in the parent otbi report right sideContent Hi Team, I am having one summary OTBI report & one …Pavan Gadepalli 63 views 8 comments 0 points Most recent by Pavan Gadepalli Reporting and Analytics for HCM
-
How do you report in OBI on workers who have not created any goals?Summary Cannot work out how to bring back colleagues who have not even created a goalContent Hello everyone, One of our business requirements is to be able to report on …User_2025-02-04-13-09-16-898 63 views 2 comments 0 points Most recent by User_2025-02-04-13-09-16-898 Reporting and Analytics for HCM -
Performance Head countContent Hi How to use head count in "Workforce Performance - Performance Rating Real Time" Subject area as I count not see head count field ? ThanksUser_7836 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Turnover Calculation in OTBISummary What is the formula for the out of the box turnover calculation in OTBI?Content What is the formula for the out of the box turnover calculation in OTBI? Thanks, …User_2025-02-05-04-33-50-822 131 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to avoid multiple rows in OTBI ReportsSummary how to avoid multiple rows in OTBI ReportsContent Hi Team, we have a requirement to pull "Work E-mail" so i have written case statement with email type code as "…User_2025-02-04-07-00-18-658 111 views 12 comments 0 points Most recent by User_2025-02-04-18-22-33-673 Reporting and Analytics for HCM
-
Report with two different As-Of-Dates to calculate Delta variationsSummary We need to pull two lines for employees, one referring to CURRENT_DATE and the other to the previous monthContent Hi All, we do need to calculate, for Payroll pr…User_2025-01-31-00-30-34-540 28 views 4 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Competencies OTBISummary Cannot view the competencies for position in OTBI reports while the values in the position profileContent Hi , Cannot view the competencies for position in OTBI …Rafik Beshara 71 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Agent mail trigger issueContent Hi, I have created a agent. In 'Delivery Content' tab I have given content as 'Briefing Book' with PDF format , and also configured mail ids in Recipients' tab, …
-
HR can't see all HR Action valuesSummary We have analysis and HR can't see all HR Action values.Content Hi All, In our analysis we see who left the company, why and dates, actions etc. In HR Action we h…User_2025-02-04-18-26-11-309 41 views 2 comments 0 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
HCM Cloud OTBI Workshop at Oracle ParisContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t…Julian Challenger-Oracle 48 views 6 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Agent Deletion errorContent Hi I am getting below error while deleting the agent , please assist on this. ThanksUser_7836 18 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI Conditional Formating - Color Coding Not workingContent Hello everyone, I have created passport details report. This report contains field Passport Expiration Date. I would like to color cells where expiration date is… -
Prompt Filter - Date Format ChangeSummary We can't change filter's Date Format at promptContent Hi All, I added date filter with using Prompt for analysis. In Analysis, I can change date format as I want…User_2025-02-04-18-26-11-309 93 views 12 comments 2 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
As-of-Date Doesn't work anymoreSummary As of date variable in OTBI doesn't workContent Hi, Since the last release, the feature of putting variable in OTBI analysis for effective date doesn't work. The…
-
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…Vibha Pandey - Oracle 33 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Payroll Check Details ReportSummary We have a requirement to pull out Payroll Check Details for an employeeContent Hi, Can anyone help me with a Sample query which will give Payroll Check Details (… -
OTBI Does Not Produce ResultsContent Hi All, I am just running a simple query to get the list of all employees. It's only showing my name, plus as soon as I one more column it does not produce any r…Neha_Takkar 49 views 5 comments 2 points Most recent by Ivy__Valverde Reporting and Analytics for HCM -
EIT - India Nomination InformationContent Hi All, We have a requirement from our business in India regarding their benefits program. We require to report on Extra Information - India Nomination Informati…User_KOLMZ 54 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
19B caused a number of BIP reports to now fail - HY000Content Hello, Following our upgrade to 19B at the weekend a number of custom reports are now no longer working that we had built. I wonder if any reporting experts woul… -
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud ThanksRebecca Smith-27468 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
'Column format - Suppress' do not work in OTBI Direct Database request reportSummary Suppress property in OTBIContent Hi All, I have created a direct database request report where I want to suppress a field 'Year' if the values are repeated. I us…SuryaMuralidharan 67 views 2 comments 0 points Most recent by SuryaMuralidharan Reporting and Analytics for HCM
-
Customizing Seeded Analyses from CatalogSummary Seeded analyses are using custom values that don't match our setupContent Hi Everyone, I understand that with R13 we can no longer modify or remove the seeded re… -
Choosing All options from filter at the TableSummary We have department filter at one Table. We can't choose All.Content Hi All, How can we choose All options from one filter at the table. It allows only declared d…User_2025-02-04-18-26-11-309 33 views 6 comments 1 point Most recent by Timothy Orrange Reporting and Analytics for HCM
-
Employees by Tenure and Age BandSummary Employees by Tenure and Age BandContent Hi I am looking for a report which has the Employees by Tenure and their Age band for the last 4 years. Could you please …Mansur Khalil 73 views 5 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
How to add default value for a particular column in OTBISummary How to add default value for a particular column in OTBIContent I have created a analysis in OTBI. And have added one date column in the Promt and trying to defa…User_2025-02-05-02-11-29-794 104 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM