Category 81
Discussion List
-
How to format the date field from time dimensionSummary: How to format the date field from time dimension Content (required): I have column Calendar Month from Time dimension it is showing the output as 2022101.0 for …Raghavendra M 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
12 Month Trailing Trend Chart of AttritionSummary: We're looking for this specific report. Content (required): Unsure of whether there are metrics accessible via OTBI that could be used to create this report Ver…Andrew Craig-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can't see 'Administration' Tab in Catalog?Summary: Content (required): Can't see 'Administration' Tab in Catalog after the last update? any feedback? note: the user has all related (HR Analyst, Admin Roles, and …Walid Hamdy 54 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Positions Filled in less than # daysSummary: Need to track positions filled that took less than/more than 60 days to fill. Content (required): I need to find a way to not only track the # of positions fill…Scott Conaway 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
BI Publisher report formattingSummary: I have a BIP report that I need to export (to FTP eventually) to CSV format but I cannot get the formatting to stay. Content (required): The BIP report needs to…Scott Conaway 22 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
NI thresholds - How to report in OTBISummary: Please can someone confirm if it is possible to report on NI thresholds using OTBI. Alternatively, which table in BIP can we derive the NI thresholds from Conte…
-
Attrition analysis/ dashboardSummary: Hello, I am looking for the valid attrition analysis that will calculate attrition on FTE employees, and perform by time periods, like month or quarter. Thank y…J_Haskell 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Error When open Dashboard by a certain user!Summary: Content (required): I received this error when opening a custom dashboard, noting that the user has access to the report and its Subject Areas The report can be…Walid Hamdy 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Locate Job Requisition Submissions Questionnaire ResponsesSummary: Hi all, I am attempting to write a BI report that will show an applicants response to a specific question asked during the job application submission. Can you p… -
Analysis Female Successors for Critical RolesSummary: I am trying to work out #critical roles: used distinct (Plan Business Unit)- Correctly getting the count #atleast 1 female successor on these critical roles # c…
-
Identifying/Removing Duplicate rowsSummary: I am creating a report that is trying to highlight any blanks or erroneous data in our active workforce. It requires combining the following subject areas: Work…
-
How to display different email address types in separate columnsSummary: We have a requirement to display separate columns for work email address and home email address, one row of data per employee. Content (required): From reading …User_2025-01-29-23-50-34-285 55 views 9 comments 1 point Most recent by Tim Hopkins Reporting and Analytics for HCM -
How can I query uploaded learning content?Summary: Is there an easy way in BIP to query learning content title and file name? In my particular case they have been batch uploaded via REST API, but I don't think t…
-
Ask for table name - who answered the questionnaire, the questions and answersSummary: Ask for table name - who answered the questionnaire, the questions and answers Content (required): Table name for Questionnaire related have found the following… -
ORA-01841: (full) year must be between -4713 and +9999, and not be 0Summary: Encountering an error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 when trying to pull a value from the element's input value. Data type…RenzelkeithCoquia 361 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Number of Candidate Pool Members metric doesn't match with the value showed in UISummary: Content (required): Hello, We would create a simple analysis that extract the Number of Candidate Pool Members inside the different pools. We create the analysi…Giuseppe Iacono 42 views 8 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
How to report on initial absence start date while maintaining current absence start/end date columnsSummary: Hi All, I have a requirement to report on the initial start date of consecutive absences, while also showing the start date and end date of the current absence.…User_2025-02-11-06-38-03-841 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Table name for retrieving representative information assigned to an employee based on AORSummary: I need to write a BI publisher report where I need to fetch the representatives assigned to an employee based on AOR as shown in the screenshot below .Here we c…Nirmal 33 views 2 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM
-
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Summary: Hello Experts, Can you please guide me if you have faced the similar issue while installing BI Publisher Desktop for BIP 11.1.1.9.0 which not working with MS Of… -
Total on the Top of Stacked Vertical BarSummary: Total on the Top of Stacked Vertical Bar Content (required): How to add Totals on top of Stacked Vertical Bar in OTBI, Please see below image, If its possile pl… -
Can't view own record in OTBISummary: I have a custom role where I would like to see my own data, only in OTBI but not to be able to correct it in HCM. Like add absence to my own person. I don't wan…Nicolas Vahman 555 views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Grouping and sum the RUN values of balances using XSLTSummary: Grouping and sum the RUN values of balances using XSLT Content (required): I have a below requirement to group by and sum the RUN values for each balance under …Deekshith Kalluri 31 views 0 comments 0 points Started by Deekshith Kalluri Reporting and Analytics for HCM
-
ORC: Tracking all the End Dates for a RequisitionSummary: Hi, Can we track & report all the end dates for a requisition if Hiring Manger changes the End Date of the Requisition? Any help with details like Tables, Repor…Bhaskar Konar 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Requisitions per Department ReportSummary: Content (required): Hello Guys, We would create a report that show the number of requisitions for Departments and that it also have the functionality to explain…Giuseppe Iacono 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP Report - Department HierarchySummary: Hello, can I create a SQL for department hierarchy out of this sample pattern? Does it work in Oracle BI Publisher? with Org ( id,idparent, name, level , Path) …Hazel De Castro 34 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Please, which subject areas can i use to build a report on personal information data.Summary: We want to build a report on personal information data. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…David Sakeye 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 498 views 5 comments 0 points Most recent by Evan Rathod Reporting and Analytics for HCM -
How to create Pivot table in RTF with Text values?Summary: Hello Experts, Is it possible to create a Pivot table in RTF with Text values? If yes, kindly share the details. Regards, Abhishek Premchandra Content (required…Abhishek Premchandra-Oracle 31 views 4 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
Waived Benefits fields in OTBISummary: I have a report that HR has requested to add if the have waived their benefits elections. Is their a field/ subject area that will store this information? I'm c…RJ Blankenship 21 views 3 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
OTBI-Report-Workforce Management - Person Real Time-Roles RequieredSummary: OTBI-Report-Workforce Management - Person Real Time-Roles Requiered to get employee information Content (required): Hello I need to get some employee and manage…Cesar Saveedra 1 view 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM