OTBI
Discussion List
-
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e…Mithun Abhisheka 94 views 2 comments 0 points Most recent by User_2025-03-07-21-51-04-421 Reporting and Analytics for HCM -
Sub query in Case Statement in OTBISummary: Hello , I would like to know if we can use subquery in case statement using OTBI Reporting subject areas . For Input Value , 'Payout Date 3' , I need to get the…User_C36BE 762 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Combining year and quarter in a date columnSummary: Need help to show both quarter and year in a table Content (required): Hi I'm running a learning completion report and want to show quarter and year in one colu…Jane Warwick 31 views 1 comment 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
New Manager type not showing in OTBISummary: We've added a new manager type in HCM and it's currently not showing in OTBI. I've ran the Refresh Manager Hierarchy and the Transfer the Flex fields to OTBI. I…User_2025-01-31-00-25-12-234 63 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI to fetch vacant and filled positionsSummary: We have a requirement to create an OTBI report which will fetch position details alongwith Employees present in those positions. Besides that, we also want to f…Sovan Mishra-Oracle 1.1K views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we add spaces in between bar on a stacked bar graph in OTBI Analysis OutputSummary: Adding spaces in between bars on a bar graph in OTBI Content (required): On the output of a bar graph, the bars are connected with each other. Can we add extra …Vibha Pandey - Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to see Values BU wise Head countSummary: unable to see Business unit wise Count while select column Head Count and Business Unit Name. Content (required): In subject Areas "Workforce Management - Worke…
-
How to remove unwanted Folders on Catalog?Summary: Content (required): How to remove unwanted Folders on Catalog? Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Fetch Employee level details from comp worksheet and budget details in an OTBI reportSummary: We have a requirement to fetch comp worksheet details (i.e. Manager Recommendation amount based on department VS Budget Amount allocated for the employee manage…User_EJ1U2 45 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.Summary: I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center informat…RJ Blankenship 309 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
"Job Requisition - Posting Structure"."Job Function" and "Current Phase" ProblemSummary: Content (required): Hello Guys, We would report if we create a simple analysis from "Recruiting - Recruiting Real Time" subject area we lost a lot of data than …Giuseppe Iacono 12 views 5 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Turnover Report Filtering 0-2 year TenureSummary: We have a requirement for a report that would have a rolling 3 year calendar that shows the headcount/termination counts for employees that are 0-2 years during…Rob Stahly 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report for ChecklistSummary: OTBI report for Checklist Content (required): Tring to create OTBI report for Checklist for a questionnaire, however, the questions are not reflected nor the re…
-
Checklist not assignedSummary Checklist not assignedContent We have multiple onboarding checklist by country etc and want to report where one of these checklist has not been assigned to a new…Emily Robinson 53 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Analysis from Compensation - Salary details real time returns double the annual salarySummary: While creating analysis from Compensation - Salary details real time, the report returns double the amount of the annual salary for few employees. Have anyone e…Hem 43 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…Visu 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to print sum of Position FTEs by Business Units in OTBISummary:We have a requirement in OTBI to fetch business unit name and Position FTEs. But we have to print the sum of FTEs grouping it by each business unit. We are using…Sovan Mishra-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Database mapping documentsSummary: We've recently moved to 21D but the latest database mapping document we have is REL13_21_C_HCM_OTBI_Database_Mapping_with_ViewObjects can anyone point me in the…User_A80ZS 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Sum Parts of a ColumnSummary: We have a table with the %age of absence per absence name however on the pie chart, I need to sum the ones that are at the lower end of the spectrum. Content (r…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create a report to show both accrual values for an employee and absence value for an employeeSummary: I want to create a report, that shows how much holiday an employee has left on their balance, and in the same report show how many days of absence an employee h…Nicolas Vahman 13 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Assignment Expense InformationSummary Sourcing/Auditing the assignment Expense informationContent Hello, We're trying to audit the Expenses Information stored on the on the Manage Employment screen w… -
What is the Subject Area for the new MCR fields?Summary: Trying to locate the Role_identifer and the Teacher Reference Number. They are both showing in the employment screen but cannot find them in the assignment subj…
-
Ability for an employee to run a report from talent profile page with Badge outputSummary: Ability for an employee to run a report from talent profile page with Badge output Content (required): We are in the process of implementing learning module and… -
Can we report on screening questions responses?Summary: Is there a possibility to report on screening questions in OR? I am not able to find them in the subject area. i.e. the yes or no responses Content (required): …Mitch_123456 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Creating dependent prompt in OTBI analysisSummary Creating dependent prompt in OTBI analysisContent Team, I have created a variabl 1st prompt for "Review Period" with "@{variables.ReviewPeriod}". Now i am trying…User_2025-02-01-03-43-13-079 103 views 12 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
how to Limit the prompt values based on the result of the analysis?Content I'm creating a validation report in OTBI which contains Employment data of contractors. The requirement is to be able to prompt on Business Unit. I want the list…Tom Van Iseghem 121 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
OTBI Prompts-How to restrict the values of other fields based on the values selected in other fieldsSummary: Hello, is it feasible with OTBI prompts to restrict the values of other fields based on the values selected in other fields? Example: AMNS India BU = Department…Hazel De Castro 21 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
HCM User Interface to OTBI Subject Area MappingSummary: Hi all, I am always grateful to the invaluable assistance, insight and support of the customer connect community. I have no idea if this will be of use and this…User_2025-02-11-05-19-35-410 32 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Use of MAX function to get current Tax CodeSummary: I need to tweak a repot which shows all the tax codes under one employee with dates against them, however I just need the current tax code that is applied. Cont…
-
Termination Date less than and greater than 3 months of current dateSummary: I'm trying to work out how to write a formula for a Leavers report that will bring back everyone who has left the department in the last 3 months and projected …