Global HR
Discussion List
-
Scheduling ReportContent Hi, The OTBI reports works fine when run manually filtering the conditions but when it is scheduled to run (which is created as agent) it picks up all records ig…Mohammed Rafi 36 views 5 comments 3 points Most recent by Rahul Bedia Reporting and Analytics for HCM -
Report OTBI based on role and delegationContent Hi All, Do you know if is it possible to create an OTBI report that extracts all delegations done through the functionality role and delegation? I saw that these…Valeria Longoni 81 views 5 comments 0 points Most recent by Steve_Wright Reporting and Analytics for HCM -
Error while using FILTER/DESCRIPTOR_IDOF in formula with multiple subject areasSummary The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID columnContent I'm trying to summarize Headcount based on Gender, Ethnicity and … -
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna 53 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Error in OTBI Analysis Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PContent Hi All, I have a OTBI analysis with Graph. When I move my cursor over the graph I see Hand means it's clickable. When i click I get following error, Can someone …User_2025-02-07-19-03-14-525 204 views 4 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…User_2025-02-07-19-03-14-525 57 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 38 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Resignation Submitted dateContent Hi All, We had a predefined report which use to give Resignation Submission date along with the Employee last working date. Few days back the report stopped work…Kiran Kancherla 38 views 4 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…User_2025-02-07-19-03-14-525 8 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 39 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of …Rob F 37 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 81 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who …SunnyJaiswal 47 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
When creating a dashboard how to you not show the refresh optionContent I am creating a dashboard and depending on the prompt values some of my reports that are in the dashboard sections don't have any information to display. I have …Mario B 25 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to get historic position and department values on assigment reportSummary My analysis brings in only current names of department and positions when I want the names that the were at the time of the segmentContent When I run my attached…
-
Termination Report using Workforce Management - Work Relationship Real TimeSummary Termination Report using Workforce Management - Work Relationship Real TimeContent Hello - we have been using the archived report attached for a while now, but i…Shanna Oppenheim 59 views 17 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Female ManagersContent Hi All, Looking to Female Managers metric I can see the following logic: IFNULL(((FILTER(FILTER("Worker Assignment"."Head Count" USING (DE…Alvaro Couto 58 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Part Time logicContent Hi All, I've created a custom version of the Line Manager Dashboard in order to fix a few metrics. One of them is the Part Time metric ava…Alvaro Couto 56 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM
-
User access OTBI to view info on OTBI onlyContent Hello Experts. We are in dire need to create a Custom Role that gives access to 1 employee only to OTBI. This user must not be able to view talent document ratin…Pedro Teixeira 99 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
20C-Format does not match with date when scheduling BIPSummary 20C-Format does not match with date when scheduling BIPContent We're getting the attached when users go to schedule any BIP that has a date prompt. They can clic…User_2025-02-04-16-58-40-850 45 views 6 comments 3 points Most recent by Prudence K Reporting and Analytics for HCM
-
Subject Area to determine the Minority/Non Minority Status of a personContent Hi , I want to use a Subject Area which determines the Minority/Non Minority Status of a person. Can anyone please suggest. Thanks, - ManishaManisha Chakraborty 24 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Bank Holiday Time Element EntrySummary Bank Holiday Time Element EntryContent Hi, We are trying to report on Employees who are looking to get their Personal Contribution for Bank Holiday Time worked a…Tim Hopkins 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Roles Requirement to access all employees data using Subject Area "Workforce Management - Worker ****Summary What are the roles and permissions required to be given to a userID so that he can use "Workforce Management - Worker Assignment Real Time" subject area and extr…Dharmendra Shukla 48 views 12 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Analyzing use of reportsSummary Any way to get analysis on who is using what reportsContent Hello, We are trying to assess which of our reports are being used most often by our end users (HR an…Denise Rae 58 views 12 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Is there a Subject Area to View all Address Attributes?Summary I am migrating international employees into our system and want to report on their addresses however, I cannot find some of the fields within the subject area to…HROps17 169 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM – Product Office Hour: OTBI November 2020Content Submit your questions for the HCM – Product Office Hour: OTBI November 2020 session to have them answered during the live event. Post your questions by posting a…Heather Hagedorn- Cloud HCM-Oracle 51 views 10 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to create a Report with trend and costing dff details?Summary How to create a Report with trend and costing dff details?Content Hello , In reports OTBI type , the purpose was to get the cost trend details and also the cost …Revital Mefano 21 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM