OTBI
Discussion List
-
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 17 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 37 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 943 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 150 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 303 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 90 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 987 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 279 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 31 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 141 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 63 views 4 comments 1 point Most recent by MilanMohanty Reporting and Analytics for HCM
-
How can we retrieve a effective date data on All Columns in OTBIContent Hi,I have got one requirment that client wants audit data in OTBI analysis.I have tried as of date but it will work for one columns do anyone have any idea more …
-
Webservice to pull obiee reportSummary Webservice to pull obiee reportContent Hello all, Does anyone know how we can initiate a web service to pull a specific OBIEE report? Or is there a API that can …Nizar Kassam 28 views 2 comments 0 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
Capture job changeContent Hello there. I want to capture only the job change event, but for example if i change only the job in the transfer section, it captures what is selected in the a…User_KXK94 23 views 2 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM
-
Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateSummary Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateContent Hi experts, I have an excel template ( from a benefits extract) in …Aloka Bhattacharya 16 views 1 comment 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Adding Grade Min, Mid, Max to a reportSummary Grade ratesContent I want to add Grade Min, Mid and Max to reports but get an error every time I try to add the Workforce Management - Grade Rate Real Time Subje…Donna Valentine 8 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
User Manual for adding OTBI report to HR dashboardSummary User Manual for adding OTBI report to HR dashboardContent Hi Team, Can any share user manual/White paper for adding a OTBI report to HR dashboard. Appreciate you…Dinesh Neredu 39 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Reports over Payroll DataSummary We experience terrible performance when we run OTBI reports over subject areas such as Payroll Balances Real TimeContent The OTBI reports tool is struggling to p…Raz Baboorian 48 views 4 comments 2 points Most recent by Raz Baboorian Reporting and Analytics for HCM
-
Analytics Dashboard section header and report link font formattingContent Hi All, I have embedded dashboard on homepage, which has report hyperlinks and section header displayed. I have managed to change the background color same as ho…Punam Roy Karmokar 23 views 2 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Need to create a report that will extract data which doesn't have costing options enabled at departmSummary Need to create a report that will extract data which doesn't have costing options enabled at departments, jobs, positionsContent Hello Everyone, We have requirem…Prudhvi Indukuri 20 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using Headcount Values in Reports and DashboardsContent I am trying to use headcount values in reports and dashboards, but the values are not lining up correctly. I know how to load the assignment work measure via HDL…Shannon Lackmeyer 39 views 2 comments 3 points Most recent by Shannon Lackmeyer Reporting and Analytics for HCM -
Job and Grade Rate OTBI ReportContent Hi, I have created job families and different jobs under each job family. Each job has been mapped to a grade, which is in turn mapped to a grade rate. Therefore…User_2025-02-11-02-55-52-410 390 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
In which report Enterprise name along with organization structure is displayedContent Hi Team, Do we have any report which displays Enterprise name alone with org structure details like Enterprise, division and so on. Kind Regards, Rahul -
Help Performance Section info Cannot Coexist with Overall RatingsSummary I get an error when I put section rating and overall Ratings togetherContent Hi All, I created a report that shows Overall Manager Rating but when I try to pulli…Charles Egegbara 36 views 2 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM