OTBI
Discussion List
-
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 97 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 81 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodSummary Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodContent Hi Experts Please let me know if there is a report for all…Mansur Khalil 44 views 3 comments 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' …Anuradha T 62 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create dashboard prompt using column with custom formulaSummary Analysis has calculated column with bins. How can I create a dashboard prompt using this column?Content I created a column that bins seniority years (seniority u… -
OTBI Custom Dashboard PromptSummary Looking for ideas on Custom Dashboard PromptContent Hello, We want to create a custom dashboard prompt to add to the other list of prompts. We need a prompt for …Tony Puentes 92 views 7 comments 0 points Most recent by Tony Puentes Reporting and Analytics for HCM
-
Usage TrackingSummary OTBI Usage TrackingContent Is Usage Tracking available for OTBI Reports? Something like in 20A for BI Publisher reports? Or even that which is available for OBIE…User_2025-02-05-23-02-10-916 98 views 6 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Summary Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Content Hi Experts, We are looking for a requirement to fetch Hire date change…Harish Kumar Kovi 56 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
Using Subject ID in Transaction AdministrationSummary How do I use Subject ID to join to other Subject Areas to identify employee impacted by transaction by nameContent I would like to create an OTBI report on faile…User_2025-02-04-08-27-17-553 55 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Approved GoalsSummary Need to find dates when Goals were approvedContent Hi, I need to find all Goals that were approved between the 20th - 23rd July but when I look I see there are m…User_2025-02-05-22-44-35-842 25 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Busting OTBI Myths - Trend reportsContent Myth: You can't report trends in OTBI Trend reports can be produced in any subject area which has a "Time" dimension folder (as of 19B 63 out of 78 subject areas…Julian Challenger-Oracle 67 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Transfer ReportingContent Hello everyone, I am trying to get a transfer report built in OTBI. I have the basis of the report built and it is pulling the employees that I am looking for. H…Andy Whalen 62 views 2 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
Rehire Date as a PRESENTATION_COLUMNSummary Rehire Date as a PRESENTATION_COLUMNContent Hi All, My business user complains to me that Rehire date is not a presentation column and is not as easy as adding a…Sriharsha Devraj 52 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payment Reference Number field subject Area in OTBI for PayrollSummary Payment Reference Number field subject Area in OTBI for PayrollContent Hi All, We are trying to create payroll reconciliation report and we are almost completed …
-
Full-Time Equivalent Measure Will Not SuppressSummary When the Full-Time Equivalent measure was pulled into a Benefits report, the FTE is not suppressing, even though the column properties have been set to suppress.…Kei Sato 39 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Identify if comma is present in a fieldSummary How to do that in OTBI?Content Hi, we need to embed the following logic into OTBI report (CASE WHEN hr_loc.location_name like '%,%' then '"'||hr_loc.location_nam…Nicola Petri 15 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
OTBI Bursting ReportSummary Bursting report is not splitting out rows to recipientsContent Hello! I have an OTBI bursting report for absence balances. I've included a column with the user n…Susan Anderson 95 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to create a page in UI and add dashboard into it in release 20BSummary how to create a page in UI and add dashboard into it in release 20BContent Hi, how to create a page in UI and add dashboard into it in release 20B. 20B is very d…User_MC37Q 29 views 2 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Hiding prompt while exporting data from dashboardSummary Hiding prompt while exporting data from dashboardContent Hi Team, Can you please let me know how to hide the dashboard prompt while exporting data to excel. Than…
-
Dashboard with Prompts using LSQLSummary Write analyses for Dashboard with Prompts using LSQLContent Is there a way to write analysis using LSQL(more complex, which would have outer joins etc.) which ca…Jozef Kozak 61 views 6 comments 0 points Most recent by user10465876 Reporting and Analytics for HCM
-
Can we lock the column order in the report outputSummary Can we lock the column order in the report outputContent Hi Team, Can we lock the column order in the dashboard output so that customer will not change the order…
-
Learning - Reporting on RecommendationsSummary Would like to report on who recommended learning items and to whomContent I would like to create a report to show who recommended learning items and to whom. I h…User_2025-01-25-05-06-07-246 57 views 3 comments 0 points Most recent by User_2025-01-25-05-06-07-246 Reporting and Analytics for HCM
-
How to update the link for an embedded reportSummary Links for Embedded reportsContent Hi All, I am attempting to update the link for an embedded report after a recent copy from our production to test environment. …User_2025-02-04-08-51-08-912 36 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll Balance Duplicating with Multiple AssignmentsContent Hi, I am trying to write a report in OTBI to pull Gross Earnings in a specific time period, and I am running into a problem where the amount is duplicating in so…User_2025-02-08-04-27-03-855 100 views 1 comment 1 point Most recent by Anshul_Khandelwal Reporting and Analytics for HCM
-
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…User_2025-02-10-08-27-16-805 33 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 61 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
New Line of data for each variableSummary Just checking options available to prevent multiple lines if data in reportsContent Hi, I think I know the answer to this already but apart from using BI Publish…User_2025-02-05-22-44-35-842 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Ability to add hierarchy fields as Dashboard promptsSummary Unable to add hierarchy fields as Dashboard promptsContent I am trying to add "Hierarchy"."Level 1 Department" from Worker Assignment real time subject area as D…User_2025-02-10-08-27-16-805 30 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide options in cogwheel on embedded DashboardSummary As the title implies, we have a dashboard that we would like to hide some options on.Content Hi all, In the attached picture, we have two dashboards -- the botto…CIT Shane 22 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Reporting on employment contractsSummary New hires are still showing as pending workers in Employment Contracts Real Time subject area.Content I'm trying to write a report that will show all employees w…user9020833 42 views 12 comments 0 points Most recent by user9020833 Reporting and Analytics for HCM