OTBI
Discussion List
-
Adding parameters to a deep linkContent Hi, Does anyone have steps or documentation of adding parameters to a deep link to go into a specific person's page/details from an OTBI report? Deep Link - http…Dishti Malhotra-Oracle 158 views 3 comments 2 points Most recent by Liran Reporting and Analytics for HCM -
Average Time to HireSummary Documentation or Logic of Average Time to HireContent Is there any documentation or means to know how the measure "Average Time to Hire (Days)" is calculated in …Rajesh Jayaram 77 views 1 comment 1 point Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
How to bring different type of manager in analysisSummary To display matrix manager and functional manager in analysisContent In fusion system, as per business requirement, there are two types of manager type, one is Li…User_2025-01-29-18-45-19-617 75 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Duplicate lines in OSHA 300 when an employee transfers to a new job/positionSummary Duplicate lines in OSHA 300 when an employee transfers to a new job/positionContent We are working through some issues where an employee has two rows within the …Andrew_Schmitz 18 views 1 comment 0 points Most recent by Glen Walton-Oracle Reporting and Analytics for HCM -
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g…
-
Add 45 day to Benefit Program Date in OTBI AnalysisSummary Add 45 days to Benefit Program Date in in OTBI Analysis filterContent Hello, I need to add a filter to the OTBI analysis. The filter should add 45 days to the Be…GauravGupta39 25 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Is there a way to track which all analytics/Reports are run by users and via which device (Laptop VsContent Hi Everyone, Is there a way to track which all analytics/Reports are run by users and via which device (Laptop Vs Mobile phones) Please let me know if you have a…Reddykrishna 44 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Dashboard prompts using sql querySummary Need to create dashboard prompts using sql query as the relevant subject areas for prompt data is not availableContent Hi Experts, I have a requirement to have p…Anirudh Udupa 10 views 3 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM
-
Why are some column headers clickable links in my OTBI report? What is the functionality of these liContent Hi, I would like to know why some of the column headers in my OTBI report are clickable links and others are not. I would also like to know the purpose of these …Alex Buckley 30 views 1 comment 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Can anyone give me Logical SQL with UNION ALL sample codeSummary Can anyone give me Logical SQL with UNION ALL sample codeContent Hi All, Can anyone give me Logical SQL with UNION ALL sample code Regards, Rashmi -
Viewing secured views for Oracle delivered reportsContent I am reviewing some of our delivered reports and am noticing what I believe to be an issue with our secured views. Specifically, I noticed that users can see the…Evan Lehrhoff 31 views 3 comments 0 points Most recent by Evan Lehrhoff Reporting and Analytics for HCM
-
How to add bin as prompt?Summary How to add bin as dashboard prompt?Content We have created a column, Position Status, on a position management analysis based of a calculated measure we created,…Aja Nealley 33 views 5 comments 2 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 880 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" SubjectSummary Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" Subject area.Content Hi , I am trying to fetch the data from "Workforc…Dharmendra Jha 18 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Create a ORC Report with Records having hyperlink to ORCSummary Hyperlink to candidate ProfileContent Hi All, I have a requirement where I need to create an ORC report with candidate data. This report should have a hyperlink …Vibha Pandey - Oracle 48 views 4 comments 0 points Most recent by User_GIUF2 Reporting and Analytics for HCM
-
Report of Assignments in a flowContent I was hoping to have a report of assignments within a flow so that we can use that as the basis to check whether people will be paid during the calculate payroll…Sharon Harper 35 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…User_KOLMZ 919 views 7 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Conditional Format - a detail field to a summarized fieldContent I have an analysis report where I list all the active positions and their FTE along with the employees assigned to those positions and their FTE. I want to compa…Annette M 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Training Needs AnalysisContent Anyone can share the Training Needs Analysis samples report developed in Oracle HCM?Chris Ding 153 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Address Audit ReportSummary Looking for a report with employee address changesContent Hi, Does anyone have a report that shows all address changes for an employee? Would want to see before …
-
Folder permissions in OTBIContent Hi there, Does anyone have any documentation to summarise each of the folder permissions in OTBI (Full Control, Modify, Open, Traverse, No Access, Custom) and wh…JosieAppleby 297 views 5 comments 0 points Most recent by JosieAppleby Reporting and Analytics for HCM
-
OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysSummary OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysContent Hi Friends, I have been working on this report and finally get it working now. …Mansur Khalil 91 views 7 comments 2 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Sample OTBI Dashboards and Reports - Supporting VideosSummary 4 videos to explain how to get the most value from the sample contentContent For anyone new to OTBI or familiar with the sample pack of dashboards and reports th…Caroline Gladwin-Oracle 963 views 23 comments 9 points Most recent by Anita Reporting and Analytics for HCM -
Multiple Conditions CASE StatementSummary Build a case statement to include ELSE conditionContent Hi, Please see the attached formula logic. I am trying to build out this formula for multiple locations b…User_2025-01-25-03-46-43-745 271 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a…
-
Filtering Workforce Trend Real Time by item in Worker Assignment Real TimeContent Has anyone had success filtering workforce trend real time data by a data point in Worker Assignment Real Time? I want to report on the make up of our officer po…Lauren Owen 37 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Statement of EarningsSummary Subject area for creating an Analysis in OTBIContent I would like to create an analysis using much of the information from the Statement of Earnings but adding m…Annette M 17 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM
-
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…User_2025-02-10-08-27-16-805 24 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ORC: Employee Referral ReportContent Hello - we would like to report off employee referrals whether an internal employee used the 'Refer a friend' option to invite someone to apply to a req or if th…Shanna Oppenheim 143 views 4 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Department Hierarchy and Department Changes reportingContent I have been working on rolling out a department hierarchy for my company. The hierarchy is complete and working but i am looking at how it interacts with things …User_2025-02-10-15-06-52-222 65 views 4 comments 1 point Most recent by MilanMohanty Reporting and Analytics for HCM