Reports
Discussion List
-
Can a column name be modified but also translated?Some standard colom names are not suitable for our organization but if I change them the name will be fixed. For example if I change the language settings the name of th… -
Attrition and Turnover ReportsSummary: Need to develop an analysis for Attrition and Turnover Content (required): We have a below requirement for Attrition and Turnover Reports, can anyone share the …Raghavendra M 671 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…Izliana 31 views 1 comment 0 points Most recent by Maria Croitoru-Oracle Reporting and Analytics for HCM -
Results to be displayed horizontally instead of vertically in reportsSummary: We have a requirement where the results displayed in reports are vertical but we need to display that column horizontally. Suppose say for example this the resu…Prajwal kumar 81 views 5 comments 0 points Most recent by Prajwal kumar Reporting and Analytics for HCM -
How can I make sure that when the Dashboard is first opened, no data comes in without selecting a paHi, I designed a dashboard for users. It has a detailed dashboard with assignment information of individuals and multiple parameters. What I want is for the parameter sc…Sinem Kara 51 views 9 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check… -
Percentage of documents in various tasks.Summary: Hi Experts, The performance process flow we are using is 1) Set Goals 2) Self evaluation (employee) 3) Manager evaluation 4) Employee final comments 5) Manager … -
How can I edit the pie report I added to the Dashboard screen?The pie report I prepared shows the gender information of the people working in the departments. For example, when I click on the number of women, the page in the screen…Cansel Karasoy 41 views 5 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
How can I show the number of rows returned from the report?I created a dashboard from the analysis report and there are parameters for this report. How can I show how many data is returned in the report depending on the paramete…Barış Ergün 81 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can I make the report not open without selecting Parameters on the Dashboard screen?I have a few reports that I have prepared from analysis and I have created a dashboard from them. And reports work with parameters. When I click Open to Dashboard, repor…Cansel Karasoy 51 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Is it possible to open a detailed report for a tile or graph besides it?Summary: Is it possible to open a detailed report for a tile or graph besides it? When I am using action links in Interaction tab detailed report is getting opened in th…Parul Sah 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…HarishVummidi 101 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…User_2025-01-29-01-27-20-754 213 views 17 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…Dona Das-Oracle 1 view 0 comments 1 point Started by Dona Das-Oracle Reporting and Analytics for HCM -
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi…Shanna Oppenheim 1K views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Terms (Leavers) with Most Recent Performance Score and Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent performance score- the Calculate…Rebekah Gilday 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Errors found FBDI - Import Project Resource AssignmentsSummary: I am receiving these errors while performing the imports by project. Some of these I believe are caused by bad configuration data but not all. I am new to HCM a…Jon Calhoun 21 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle HCM Spreadsheet Data Loader (HSDL) -
Terms (Leavers) with Most Recent Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent box assignment from the Talent A…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Development Goals view of Top 5 for different categories - not overallSummary: HI there, I am reporting on our Development Goals using "Workforce Goals - Goal Status Overview Real Time" As there are so many goals in our system, I want to g…Stephanie McInnes 41 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to give mirror text formatting in rtf templateSummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. If anyone tried this , please help us. Conten…SAKTHI SUNDAR 41 views 1 comment 0 points Most recent by Ankur Miglani Reporting and Analytics for HCM -
Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S…Bobby Jourdan 61 views 9 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 31 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo…Pradeep T U 81 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…Manisha Gupta 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Legal Employer LOV not populating while running EEO ReportsSummary: Hi All, While running the EEO-1 report, I am not able to find any Legal Employer coming in the dropdown. We have 3 LEs in the system and in other actions, I am …Gaurav Rath- PGC 61 views 1 comment 0 points Most recent by Abhishek Tiwari, CPP -Oracle Payroll and Global Payroll Interface (GPI) -
Add 2 Report Measures: Dept Active FTE and Vacancy Rate %Summary: I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept… -
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have …AjayKumar Maddipati 31 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …Brian Todd-Oracle 984 views 2 comments 0 points Most recent by Suhitha K-Oracle Reporting and Analytics for HCM -
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 174 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM