Reporting and Analytics for HCM
Discussion List
-
BI - CASE statementContent Wondering how we can use the CASE statement in the WHERE clause. I keep getting error 'Missing Keyword' and I dont see anything wrong with my CASE statement. It … -
OTBI - Set the column heading label for multiple columnsContent Hi, I want to SET the columns heading label same as the Folder heading label by default for all the columns. I know you can do manually one column at a time manu…
-
Salary Change AuditSummary Is there a way to run a report to find out who entered a salary change in Manager Salary and when?Content Is there a way to run a report to find out who entered … -
Data Model Report in FusionContent Hi, How to create Promotion data model report based on promotion employees regards, nivaetha -
Is Performance Goal Action Taken available for reporting in OTBI / BI Answers?Summary Need to report Goal Action Taken in BI AnswersContent In the subject area Workforce Goals - Goal Status Overview Real TIme, is Action Taken available for reporti…
-
Using interactions to Navigate into ModulesSummary Helping users navigate to relevant screens from analysisContent Hi, I'm trying to come up with creative ways to integrate the analysis into the Core HR modules. … -
Making a page to host a dashboardSummary I would like to be able to make a page that looks and feels just like the Manager DashboardContent Hello Everyone, I have a question in regards to setting up new… -
Having issue with OTBI Analysis report created using logical sqlContent Hi, We have created an OTBI ANALYSIS REPORT which is based on a logical sql and when we run it we are getting the below strange error msg: Result field position:…
-
Report doubling my values.Summary I have a report which should count every employee as 1, but for some reason counts them as 2.Content Hi, I have a traffic light report which counts employees who…
-
Report Jam at OHUG Orlando (June 6-8)Content Sign up to guarentee some in-depth 1:1 report building using Oracle Transactional Business Intelligence (OTBI) for HCM, Taleo Enterprise Reporting or Taleo Learn… -
Report Jam is back at OHUG OrlandoContent We will be running the Report Jam at OHUG (June 6-8 at Orlando) for the third year in a row. If you have a report you'd like us to build or you want to know more…
-
Remove expired dates from an end date report.Summary End dates of before the current date are appearing on my report.Content Hi, I have produced a report on end dates, such as fixed term and probation end dates. Th…
-
Line Manager ReportingSummary Cascading reports across the organisation but security set to direct reportsContent Hey We're using R10 and have a vast number of OTBI and BI Publisher reports i…
-
Reporting on prior incumbents of positions.Content Is there a table that stores the data on position incumbency? I have requests to show the incumbency history for a list of positions. The information is listed a…
-
Changes in Hours / Grade / Salary / Organisation / Business Units etcContent Hello, We are looking for a way to create an analytical report or maybe even a dashboard that can show when "Historically" an employee has changed one of these f… -
A How-To Article on Creating a Pipe Delimited Report from a Subject Area in Oracle HCM CloudSummary Demonstrates How to Create a Pipe Delimited Report from a Subject Area in Oracle HCM CloudContent For those of you who have a little bit of idea about OTBI (Orac… -
Unable to pick latest salary details for a person using subject area "Compensation - Salary HistoryContent Hello All, I am having a trouble in pulling out the latest salary details for a person using "Compensation - Salary History Details Real Time" Subject area. I ca…
-
Reporting on Working Pattern/ Work Schedules aswell as current assignment information in a single reSummary Possiblity of generating a report Including Working patterns/Work and Assignment information within an Analysis/ReportContent Hello, We are currently struggling … -
OTBI report to pull out Position/Department Historical data with effective dates.Content Hello All, I have a requirement to pull out all the data related to Position/Department from the day of creation. I have tried to pull out the data using the sub…
-
Manager Name using OTBI Report for a Termination Person using the Workforce Management Worker AssignContent Is is possible to get the manager name for the terminated person using the Workforce Management-Worker Assignment Event Real Time Subject Area. Currently the rep…
-
Comments of manager for annual performance interview information in BI publisherSummary Where can I find the comments of the manager for the annual performance interview in PI publisher (fusion tables)Content Hello, Someone know where can I find in … -
How quickly does data move from HCM Cloud application to OBI Subject Areas?Summary How quickly does data move from HCM Cloud application to OBI Answers Subject Areas?Content Hi all, How quickly does data move from HCM Cloud application to OBI A…
-
Location of Performance Document Manager for BIP in Release 11Summary I would like to know the location of Performance Document Manager for BIP reportContent I have a BIP report where the user, manager's name, and the last complete…
-
Performance Rating report of Overall Manager ScoreSummary Why do I need to say which section it is in to report it correctly?Content Below is my XML i had to specify the Overall Section otherwise I got completely differ…
-
HR Action is not picking correctlyContent In the OTBI, I am creating a report to list all the terminated employees along with the HR action. Though I am using max(effective_start_date) "Workforce Managem…
-
HOw to migrate reports from one env to anotherSummary HOw to migrate reports from one env to anotherContent Hi WHat is the best way to migrate reports from one environment to another? Thanks Saurav -
Creating a simple Address report for a Business Unit/Legal EmployerSummary Trying to create an OTBI reportContent Hi, I am trying to create a simple address report i.e employee name, person number and address fields (including 'Address …
-
Retention DashboardsSummary Looking to develop Retention DashboardsContent Hello Community, We are in the process of adjusting our current analytics to focus on retention vs. turnover. I wa…
-
BICS integration with fusion HCMSummary HR analytics with fusion HCM other than OTBIContent We are on peoplesoft 9.1 with OBIA +BICS as our HR analytics platform. We are replacing peoplesoft with fusio…
-
Reporting on Salary as of the beginning of yearSummary I need to create a report that displays an employees salary as of the beginning of the year.Content Hi I need to create a report on what an employees current sal…