OTBI
Discussion List
-
sum of 2 columns to be shown in 3rd column in OTBISummary: Hello, We are trying to sum 2 columns data and show it in 3rd column, however, it is not working. candidate-Job Applied + Candidate-Prospect = Total Referred Ca…Shiva Prasad M 114 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Learning Count Using Disability StatusSummary: Using the Workforce Learning - Learning Records Real Time Subject Area to pick up disability (which is using Workforce Management - Person Real Time to count th… -
Length of Time in Job OTBISummary We have a reporting requirement where we need to capture the Length of Time in Job. Is it possible through OTBI?User_2025-01-25-03-18-49-935 99 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 -
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…Neelesh Varma 336 views 4 comments 0 points Most recent by Neelesh Varma Reporting and Analytics for HCM
-
Ability to track the number of times learner retook/reviewed an already completed learning itemSummary: Looking to create a report that gives the number of times a learner has reviewed or retaken an already completed learning item. Is this information recorded, an…KatHugh 41 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle 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 -
GETTING ERROR WHEN USING TWO SUBJECT AREASummary: I HAVE ONE SUBJECT AREA "Procurement - Procure To Pay Real Time'' I SELE CT PO NUMBER , CREATION DATE , CLOSED DATE, AND FROM ANTHOR SUBJECT AREA ''Procurement …
-
Report on total number of direct and indirect reports by managerSummary How can I sum distinct direct and indirect reports by manager?Content Hi - I'm having a hard time figuring out how to sum direct and indirect report total counts…Julia SRI International 446 views 9 comments 0 points Most recent by RamyaK Reporting and Analytics for HCM
-
How do I create a learning category headcount report?Summary: I am having to create new reports for the new Learning Subject Area (Workforce Learning - Learning Records Real Time) due to the Learning Management Subject Are…
-
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and…User_2025-01-25-00-37-41-739 195 views 6 comments 1 point Most recent by Julian Challenger-Oracle 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 -
MonthName function not WorkingSummary MonthName function not WorkingContent Hi All , I am trying to get the Month Name (Jan / Feb / Mar) from a Date entry - Eg -I'm using the following function - Mon…Jo Black 79 views 11 comments 0 points Most recent by Raghavendra_M-Oracle Reporting and Analytics for HCM -
What is the best way to mass assign a Dashboard to a large groupSummary: Only a small handful of employees use the reporting system. I am building several Dashboards for various teams, and was wondering the best way to get those folk…Wesley Morgan 12 views 1 comment 0 points Most recent by Harish Vummidi 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 -
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 52 views 9 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Unable to add Salary Basis Column in my existing Compensation detail ReportSummary: I need to add Salary Basis Column which I am unable to do so in the exisiting report. Subject area I have use is Payroll - Element Entries Real Time Content (re…Jasmine 33 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Percentage of documents in various tasks.Summary: Hi Experts, The performance process flow we are using is 1) Set Goals 2) Self evaluation (employee) 3) Manager evaluation 4) Employee final comments 5) Manager …
-
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
-
How can I show the number of rows returned from the report?I created a dashboard from the analysis report and there are parameters for this report. How can I show how many data is returned in the report depending on the paramete…Barış Ergün 74 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can I make the report not open without selecting Parameters on the Dashboard screen?I have a few reports that I have prepared from analysis and I have created a dashboard from them. And reports work with parameters. When I click Open to Dashboard, repor…Cansel Karasoy 52 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Display Assignment Data as of hire effective dateI have created an analysis that gives me all hires between two dates. However, I noticed the assignment data that is displayed shows current information. How can it be m…
-
Is it possible to open a detailed report for a tile or graph besides it?Summary: Is it possible to open a detailed report for a tile or graph besides it? When I am using action links in Interaction tab detailed report is getting opened in th…Parul Sah 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…Harish Vummidi 106 views 2 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
Report in OTBI to show data as of end of previous monthSummary: Need to show number of openings (from recruiting requisitions) from a specific date (6/1/22) through the last day of the previous month. I created a filter to s…
-
What if i cannot find the Subject Area in the dashboard prompt. Does that mean i cannot create?Summary: Trying to create LSQL coming from Workforce Profile - Person Profile Real Time and Workforce Profile - Model Profile Real Time and will add it to a Dashboard wi…