OTBI
Discussion List
-
Reqs over TimeContent I am trying to show the changes in # of openings/openings left to fill/Reqs week over week. Does Recruitment module support this point in time reporting? Has som…Riti Malhotra 32 views 1 comment 0 points Most recent by Sudeep Doke Reporting and Analytics for HCM -
How to open Catalog file in OBIEESummary We downloaded a Catalog File and need to upload and use it in OBIEE 12cContent We are working in Oracle Fusion Report and Analytics. We have a Catalog file and n… -
Environment Upgrades and Maintenance for BI ReportingSummary Working in an enviornment that has not been maintained for a while. Reports are not working well.Content Hi everyone. I'm working in an HCM environment that has …Gina Consalvo 23 views 2 comments 0 points Most recent by Gina Consalvo Reporting and Analytics for HCM -
Dashboard Prompt values in format YYYY-MM using TO_DATETIMESummary date formatsContent hello, Looking for some suggestion on date format conversions in dashboard prompt, here is my scenario: One of my dasboard has a month prompt…SantoshKumarBhairi 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Export Geography HierarchySummary How can I export the geography hierarchy?Content Hi, I couldn't find any option to export the full geography hierarchy as we defined in the "manage geography hie…
-
Retrieve top 2 records per employeeSummary Need to figure out a way to determine the top 2 records for an employeeContent Hi All, I am read through some posts but still haven't found a solution for what I…User_2025-02-04-08-51-08-912 39 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Absence Accrual Plan attributes report neededSummary Is it possible to create a report that dumps all of the attributes related to an Accrual Plan?Content In OTBI, using the Subject Area: "Workforce Management - Ac…
-
Absence Report (back in time)Summary Is it possible to report absences as they were back in time?Content Hi, I provided a report to one of our customers yesterday that showed all absence between Jan…User_2025-02-05-22-44-35-842 38 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Performance issue in absence line manager in OTBI reportsSummary Performance issue in absence line manager in OTBI reportsContent Hi Experts, I'm facing performance issue in a simple otbi report, my report has below fields Emp…Pradvin Prabhakar 28 views 5 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM
-
Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeSummary Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeContent Hello guys, Here is our business problem: Some of our co…User_2025-02-05-11-42-08-011 25 views 2 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
Security Matrix - Custom AnalyticsSummary Sharing the Security Matrix Analytics which reports the mappings between rolesContent Hello All, I have seen lot of posts asking for a solution to generate the S…Sricharan Monigari 347 views 16 comments 11 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
job name changeSummary OTBI analysis to show job name historyContent Hi, I've searched the forum and sharing centre for this but can't see anything, so apologies if answered elsewhere.…User_2025-02-08-05-56-00-229 30 views 3 comments 0 points Most recent by User_2025-02-08-05-56-00-229 Reporting and Analytics for HCM
-
Workforce Trend Real Time PerformanceSummary Is there anything I can do to tune the performance of this subject area?Content Hello Experts! I'm starting to use Workforce Trends where we are trying to count …Rob F 35 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Unable to report from subject area 'Workforce Talent Review - Talent Review Tasks Real Time'Summary No results from OTBI sa 'Workforce Talent Review - Talent Review Tasks Real Time'Content Hello, Can anyone please help? I am unable to get any data from the subj…SantoshKumarBhairi 45 views 17 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Conditional formatting on Pivot table - heat mapContent I have created a report to look at the amount of annual leave taken so far in the year by different teams. I am having trouble putting the conditional formatting…User_2025-02-06-11-18-47-896 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Location Transfers during the current yearSummary How to get the location for the first of the year and any changes throughout the yearContent Hi All, I have a requirement to pull in changes to an Employees Work…User_2025-02-04-08-51-08-912 39 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Active Job Titles & Salary RangesSummary pulling in all active job titles with salary rangesContent I have created an analysis using the 'Compensation - Salary Details Real Time'. The purpose of this an…Shelly Feyerherm 74 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to find a report in analytics (Balance Exception Report)Summary How to find an base report in the analytics tool to see if it can be customized.Content Hi All, My users have asked if it is possible to add the Assignment Statu…User_2025-02-04-08-51-08-912 20 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Workstructure and Employee Incumbent Report using Subject AreaSummary Workstructure and Employee Incumbent Report using Subject AreaContent Hi Friends, I am aware it is possible to get Workstruture and Incumbent Details using a cus…AshishERPCloud 33 views 12 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Duplicate LinesSummary What function or formula is best to useContent Hi, I have numerous OTBI Analysis reports that will have 2 or 3 lines per employee because certain columns will co…User_2025-02-05-22-44-35-842 54 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Reporting on benefit plan elections and plan ratesSummary Reporting on benefit plan elections and plan ratesContent Does anyone have a report to share on plan / option elections along with the employee and employer cost…
-
How to limit Nationality in report?Summary Multiple nationalities for some employees - I only want the the main or primary nationalityContent Hi, I've attached the XML - can anyone modify the report so th…User_2025-02-05-22-44-35-842 26 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Address Mapping DocumentContent Hi all - I am working on an address report and have noticed that there are different layouts based on the location. For example, the US has States but the UK doe… -
Payroll Overpayment ReportContent Good Day, Has anyone actually built a Payroll Overpayment Report? i have spoken to internal developers and they haven't and searching on the internet has resulte…CB Trett 51 views 1 comment 1 point Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Reporting on Approval TransactionsSummary Trying to report on pending transactions to pull the data from the notifications onto one report. Struggling to find tables to show Current and Proposed Values a…User_2025-01-23-20-43-34-115 179 views 11 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Position Change Action ReasonSummary Position Change Action ReasonContent What is the record.field that holds the action reason on the position? (See screen shot.) I cannot find it in any of the pos…User_2025-02-04-16-58-40-850 54 views 8 comments 0 points Most recent by User_2025-02-04-16-58-40-850 Reporting and Analytics for HCM
-
Report on Remuneration Managers of Employees using matrix manager from Workforce Management - WorkerContent Hi Experts, I am trying to create an OTBI report listing all employees and their Remuneration Managers using matrix manager from Workforce Management - Worker as…
-
Determine Time in Current and Previous positionsSummary Progression report that shows how long an employee has been in the current position and how long in the previousContent Hi All, I am hoping someone has a solutio…User_2025-02-04-08-51-08-912 167 views 3 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Issue adding OTBI Report to a dashboard through "Link & Image" ObjectContent Hi all, I am adding all of our reports (OTBI & BIP) to a dashboard as links to be easy to find. However, for one OTBI report, I am getting an error: "Selected it…User_2025-02-05-05-51-12-049 58 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Absence based on rolling 12 months from start of monthSummary How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm inContent Hi I would like to report absence on a rolli…