OTBI
Discussion List
-
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 73 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 21 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 32 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 51 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 28 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 52 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 180 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 59 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 168 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… -
OTBI date check End-of-timeSummary OTBI date check End-of-timeContent Hi, I am wondering if anyone has tried to check for end of time on a date column in OTBI. I wrote this. But it doesn't work. A…User_2025-02-05-23-02-10-916 37 views 3 comments 0 points Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM
-
How to get count of child nodes in ETEXT templateSummary How to get count of child nodes in ETEXT templateContent Hi experts, how can i get the count of child nodes in etext template, ex : in attached xml i want to dis…Pradvin Prabhakar 125 views 6 comments 1 point Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
FTP OTBI report outputSummary Option to FTP OTBI report outputContent Is there option available to FTP OTBI report output? Pease let us know steps/process to FTP report output. Version 20C
-
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 58 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM
-
Amendment need to an existing reportSummary Multiple NationalitiesContent Hi, How can I modify the attached report so that only the primary nationality is displayed? For context, there are many employees t…User_2025-02-05-22-44-35-842 32 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Benefits report - Users accessing UI vs submitted electionsSummary Users accessed vs submitted electionsContent Would it be possible to build a report that gives number of users that access UI vs submitted elections? Attached sc…User_2025-02-10-08-27-16-805 15 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Prior Salary not showing in reportSummary Prior salary not showingContent Hi, The report attached should show all prior salaries and current salaries - one of our users has said that the Prior salary is …User_2025-02-05-22-44-35-842 40 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Add a Column with a Static Value in OTBISummary Trying to add the same value to all records, i.e. add a dummy column that holds a static fieldContent In OTBI, I need to add a column to a report that doesn't ne…Lisa G. 669 views 5 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Account Segments Report ExampleSummary Account Segments Report ExampleContent Hello all We need to develop a report about Account Segments. We made it by Query and it is bringing the correct informati…Pedro Teixeira 20 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM -
Compensation with manager with access 'limited'Content hello, I have a question, on a compensation plan, if a manager is not eligible to a compensation plan but he manage someone inside the compensation plan, he have…User_2025-01-25-01-33-46-269 63 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Adding days to the Date prompt in OTBISummary Adding days to the Date prompt in OTBIContent Hi Team, I have one requirement to add 6 days to the prompt date and fetch the value based on the new value. +6 or …SM-Oracle 129 views 1 comment 0 points Most recent by Mallikarjuna Maganti Reporting and Analytics for HCM
-
How to enable export functionality in ReportsSummary How to enable export functionality in ReportsContent Hello, We created reports using OTBI and have put them under 'My Dashboards' but we are wondering why we can…Tony Puentes 44 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Performance tile to show a 0 instead of no resultsContent Is it possible for a performance tile to show as a '0' if there are null counts instead of it showing a message saying 'no results'User_2025-02-06-11-18-47-896 48 views 7 comments 1 point Most recent by Rob F Reporting and Analytics for HCM
-
Conditional Formatting in Pivot TableSummary Colour by Absence Type working in Table but not pivotContent Hi I'm trying to show a calendar for this month and next month. The number of days/hours shows corre…