Global HR
Discussion List
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly… -
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 292 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM -
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a…
-
How to create .txt files using burstingSummary: Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria Content (required): We are having issue in gen…Arathi Devi H 300 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa…Cansel Karasoy 32 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Query to extract the last update author for document record fieldsSummary: Hello experts, please, could you share the query to execute in order to find the author of the last update on document record fields? Thanks in advance for your…Valerio Curzi 13 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 287 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 92 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…Jithin Mathews 41 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C…
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 42 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
BI Publisher - Filter Action NameSummary: I have a SQL query that was created by our vendor. I am still a beginner in using SQL so I am seeking assistance in how to filter the report to pull certain act…
-
Query About Column Names for Source Tracking.Summary: I am creating one BI report in which I need to pull application source and application source details. In which table i can find it? I have checked in IRC_SOURC…Rajib_Samanta 71 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Facing issue unable to override Willing to relocate filed by using HDLSummary: We cannot override existing field that is "Willing to relocate " while updating existing field through HDL it is creating one more record. Navigation: Directory…User_2025-07-18-06-45-42-477 33 views 2 comments 0 points Most recent by MandeepGupta HCM Data Loader (HDL)
-
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature …Amy Wilson 44 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I fix some columns in the Analysis report?Hi I created a report from analysis and set it to Fixed headers with scrolling content. But I have too many columns in my report, so I need to freeze 3-4 columns. How is…Cansel Karasoy 42 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Manage IBAN with REST APISummary: Content (required): Hello everyone, We are having issues using the REST API to add an IBAN for a waiting employee/worker. In particular, we have developed a cal…
-
How many WorkEmails can we add to a filter while creating a Filter in Alert ComposerSummary: Trying to add work Email Id's to an expression using 'OR' operator. Has anyone used it before and know how many emails can we use in one batch. Content (require…
-
Looking for table for salary change action and reasonSummary: Looking for table for salary change action and reason Content (required): Which table holds the salary change reason and action? This is not the same table whic…Parag Hiremath 1.3K views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Filter based on custom values in promptSummary: How to filter analysis based on custom values in prompt? Content (required): I have a variable prompt which has custom values like ALL, Female, Ethnicity etc. i…Raghavendra M 41 views 4 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
Unable to hide prior incumbent details in position FTE reportSummary: Unable to hide prior incumbent details in position FTE report Content (required): Unable to hide prior incumbent details in position FTE report. Following scree…Manoj.Gupta 91 views 6 comments 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to Capture a Work at Home Flag Change in a report?Summary: Content (required): Hello Experts, We need to report on instances when employee's Work at Home flag changes from 'no' to 'yes' and from 'yes' to 'no'. Does anyo…Natalie Andrek 33 views 2 comments 0 points Most recent by Natalie Andrek Reporting and Analytics for HCM -
Calculation Cards TRUSummary: I would need to get the value of TRU in Calculation Card. I am unable to find the table name. If anyone could help on this, would be really great. Screenshot At…
-
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 589 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…Izlianas 32 views 1 comment 0 points Most recent by Maria Croitoru-Oracle Reporting and Analytics for HCM -
Adding a Page / Tab to Front End AnalyticsHello, Apologies if this is the wrong place to ask but I'm building several infolets to be used and was wondering if anyone knew if it was possible at all to add an extr…
-
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…
-
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 43 views 5 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM