OTBI
Discussion List
-
Simple logical sql query fails to load in data modelSummary Simple logical sql query fails to load in data modelContent We were trying to create a data model with Simple query(Name = Any , Data Source = Oracle BI EE, Type…Sreedharan-Oracle 81 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Customize Rating Distribution graphContent Hello, Would like to know using which analysis the graph is generated on this Performance Calibration page. We have a requirement to cutomize this graph and want…Praneeth K-261878 45 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…Kiran Kancherla 22 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
how to schedule an OTBI Agent using SoftDates such as: {$SYSDATE()$}Summary Scheduling an OTBI Analysis to run for previous month using {$SYSDATE()$} and {$SYSDATE()-30$}Content Hi, We'd like to schedule an Agent to run monthly, on the f…BDO Sue Cronin 42 views 5 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. …Mayi218-Oracle 74 views 1 comment 2 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
Latest Assignment ChangeContent Hello, I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've u…User_2025-01-31-00-25-12-234 131 views 8 comments 0 points Most recent by Ahmed AZA Reporting and Analytics for HCM -
Organization Levels, Organization Manager Names, and their Effective DatesSummary Organization Levels, Organization Manager Names, and their Effective DatesContent Hi Experts, Good day! Can you please help and guide or redirect me to resources…Raymund Jerome 10 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Join two different Subject areas - Workforce Learning - Learning Management real time and WorkforceSummary I am facing error when I tried joining two different subject areas (Learning and Person)Content In OTBI, I cannot able to Join two different Subject areas - Work…Prabhu Krishnamoorthy 53 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
21A Enhancement- HR_DOR_REPORTING_LIST_VSummary 21A Enhancement- HR_DOR_REPORTING_LIST_VContent Do you need to update/fix any security roles after this enhancement in 21A? How do you "control this access" with…Andrew_Schmitz 61 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
General Preferences OTBI Subject AreaContent Hello All. I am trying to include Language from General Preferences in an OTBI report, but I am not able to figure out which subject area general preferences are…Antoine Richard 47 views 2 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report to show all future approversContent Hi, Does anyone know of a report or way to query, all future approvers in an approval chain for notifications. For example, next approver is person x, then once …
-
Analysis about own Person ProfileContent Hi, it seems that Worker cannot see information about own Person Profile on analysis (Workforce Profiles - Person Profile Real Time). Can we achieve this by cust…
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 745 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Grouping EthnicitiesSummary Grouping ethnicities after a single row of data has been calculatedContent Hi everyone, Using this post, I was able to successfully get an ethnicity report to re…User_2025-02-11-03-07-51-707 178 views 4 comments 0 points Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM
-
Nationality Head Count AnalysisSummary Nationality Head Count AnalysisContent Hi All, May I know if anybody has done head count analysis based on Nationality . Could you please guide me. If I take fro…User_2025-02-06-09-41-56-955 35 views 4 comments 0 points Most recent by User_2025-02-06-09-41-56-955 Reporting and Analytics for HCM
-
One prompt for multiple views in OTBIContent Hello, I have developed an OTBI analysis which will have two different views (Pivot table & Graph). Can we have a single Prompt for both the views? I do not see …Praneeth K-261878 32 views 6 comments 0 points Most recent by Praneeth K-261878 Reporting and Analytics for HCM
-
Effective Date of Latest Job CodeSummary Pulling Effective Date of Latest Job Code in an analysisContent I have created an analysis using the subject area ‘Compensation – Salary Details Real Time’. I ha…Shelly Feyerherm 102 views 9 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
OTBI - HCM Manager dashboard Session 01 - 11/March/2021Summary OTBI Reporting overviewContent This OTBI working session conducted on March-11-2021 had an overwhelming response of 277 attendees. I hereby attach the resources …Raghavendra Raghunath-Oracle 64 views 0 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Promotion SpeedContent Hi All! Has anyone had luck working on promotion speed ratios out of OTBI? Diving into this in the next week or two and wanted to see if anyone else has worked o…Lauren Owen 27 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a …User_2025-01-28-08-47-04-905 429 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table and Column for Override Average Weekly Earnings field on Maternity LeaveSummary Table and Column for Override Average Weekly Earnings field on Maternity LeaveContent Hi Experts, We have a requirement to fetch the Override Average Weekly Earn…Rajeev Nayan 69 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
Managing privileges for AgentSummary Schedule an AgentContent Hello Everyone, Does anyone know which privilege from the list below removes the access from users to Schedule Agents? Thank you, Alvaro…Alvaro Couto 50 views 6 comments 2 points Most recent by Laura Meine Reporting and Analytics for HCM -
BIP Report Scheduling IssueContent Hi all, I'm currently in the process of scheduling the reports we've built using BIP data models, but we've noticed that all schedules that I've created only sho…
-
OTBI analysis for Performance rating #Content Hello, We have a requirement to develop an OTBI analysis that gives the count of employees for each rating in a particular department. I am using the subject are…Praneeth K-261878 41 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Restrict to run reports for delivered Employee RoleSummary How to restrict with delivered Employee Role to run reports from BIContent Hi Experts, We have noticed that general Employees have access to run reports (like Pa…Rakesh Ankusham 59 views 6 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for HCM
-
OTBI layout performance tile how can i make the square border thicker?Summary OTBI layout performance tile how can i make the square border thicker?Content Hello We have an OTBI with layout of a sum displayed in a ‘performance tile ‘. The …Revital Mefano 35 views 4 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM -
Pivot Report - Have a heading and change value sequenceSummary How to change value sequence and have a label in pivot report?Content I have created an OTBI report with pivot output. On left side is the desired output and on …User_2025-01-25-04-02-13-126 52 views 4 comments 0 points Most recent by E McDonald Reporting and Analytics for HCM
-
OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics, 23 March 2021, 9 a.m PT - SubContent Submit your questions for the OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics session to have them answered during the live event. Post you…mauricio -Oracle 33 views 0 comments 1 point Most recent by mauricio -Oracle Reporting and Analytics for HCM -
OTBI how to round up a number with decimal points to be without the points?Summary OTBI how to round up a number with decimal points to be without the points?Content Hello, In OTBI report, there is a field based on sum of FTE , which may includ…Revital Mefano 474 views 10 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM
-
HEX values for seeded pie chart colorsSummary HEX values for seeded pie chart colorsContent I have built a pie chart for Performance ratings for a Dashboard. The systems default to 3 colors - Yellow, Blue an…User_2025-02-10-08-27-16-805 20 views 2 comments 2 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM