OTBI
Discussion List
-
Combining columns from different work area/Competency ReportSummary how can i develop a report with columns from two different work areas.Content Competency Assessment Report Sr.No Person Number Person Name Parent Department Depa…Michael Nega Gebrehawariyat 34 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
how to take custom dff of (IRC_OFFERS_DFF) in analyticsSummary how to take custom dff of (IRC_OFFERS_DFF) in analyticsContent how to take custom dff of (IRC_OFFERS_DFF) in analytics need subject criteriaSidhartha Wadhwa 23 views 1 comment 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
D&I reporting - what works for your organisation?Summary D&I reporting - what works for your organisation?Content Hello all - over the years I've helped lots of customers with many diversity reports, but the world is m…Caroline Gladwin-Oracle 81 views 2 comments 1 point Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
Need to limit values in reportSummary Some employees have 2 types of IDContent Hi, I have a attached a basic report that shows the type of External Identifier an employee has namely: * Integration ID…User_2025-02-05-22-44-35-842 27 views 13 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
SQL Needed for DatesSummary Calculating the later of two dates using SQLContent We are creating an OTBI report to figure out when to discard of hard copies of paperwork. To calculate the sh…Rebekah Gilday 52 views 1 comment 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Table for Attachment of Job RequisitionSummary Table for Attachment of Job RequisitionContent Hi Experts, We have a requirement to fetch the attachment uploaded during Job Requisition. is this possible to ext…Rajeev Nayan 33 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM -
HCM Last date a vacant post was filledSummary is there a way to report out when a position was last filled which is currently vacantuser1028626 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to have Pivot in BIP based on a Logical SQL Pivot OTBI Report.Summary An OTBI Report is built based on Pivot View and based on the Logical SQL of that OTBI Report , a BIP Report is built but there the Pivoting is not working as Exp…User_2025-02-08-08-08-53-292 93 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
User Roles and UsageContent Hi, I need to develop BI report to understand User System Usage with username and roles attached Please let me know the tables involved ThanksMohammed Rafi 78 views 8 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Reporting on HCM/EPM using OTBI/BIPSummary Reporting on HCM/EPM using OTBI/BIPContent Hi Team, Our customer is using Cloud HCM and EPM Cloud. Is there a possibility of creating a report by combining the d…MandeepKGupta 56 views 2 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
To have a filter on OTBI analysis that should filter based on 'As-Of-Date' Prompt that is used in OTSummary Currently As-Of-Date' Prompt is there in the OTBI Dashboard and based on that As-Of-Date' Prompt need to have a filter on OTBI Analysis.Content Hi All, Currently…User_2025-02-08-08-08-53-292 79 views 2 comments 0 points Most recent by User_2025-02-08-08-08-53-292 Reporting and Analytics for HCM
-
YTD Turnover or Rolling 12 Months TurnoverSummary Is it possible to do trends over custom periods of timeContent Hello! I'm using workforce Trends and have been very impressed how it calculates turnover for me a… -
Infolets Drilldown Export IssueSummary Not able to export after a drill down on InfoletsContent Hi All, I have created an infolet where I have provided a roster so that when the user clicks on it, it …Vibha Pandey - Oracle 67 views 9 comments 0 points Most recent by User_DB0CL Reporting and Analytics for HCM
-
Customization of Recruit to hire DashboardSummary Customization of Recruit to hire DashboardContent Hi Team, As per business requirements, we are customizing Recruit to hire Dashboard (Seeded Dashboard). We woul…
-
How to Open XML in OBIEESummary I want to open XML format file in OBIEEContent I have an XML extension file and want to open/export in OBIEE Version OBIEE 12c -
Report of changes caused by an actionSummary Need a report of attributes that were changed by an action.Content Hello all, I am trying to pull a report of all the fields/attributes that were changed with an…User_2025-02-04-15-06-22-759 76 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI annual leave analysis displaying incorrect Other AdjustmentsSummary In an annual leave analysis, some of the records are pulling through incorrect value for Other AdjustmentsContent We have created an analysis using the below sub…Anna Kryszak 99 views 2 comments 0 points Most recent by Anna Kryszak Reporting and Analytics for HCM -
Reqs over TimeContent I am trying to show the changes in # of openings/openings left to fill/Reqs week over week. Does Recruitment module support this point in time reporting? Has som…Riti Malhotra 33 views 1 comment 0 points Most recent by Sudeep Doke Reporting and Analytics for HCM
-
How to open Catalog file in OBIEESummary We downloaded a Catalog File and need to upload and use it in OBIEE 12cContent We are working in Oracle Fusion Report and Analytics. We have a Catalog file and n…
-
Environment Upgrades and Maintenance for BI ReportingSummary Working in an enviornment that has not been maintained for a while. Reports are not working well.Content Hi everyone. I'm working in an HCM environment that has …Gina Consalvo 23 views 2 comments 0 points Most recent by Gina Consalvo Reporting and Analytics for HCM -
Dashboard Prompt values in format YYYY-MM using TO_DATETIMESummary date formatsContent hello, Looking for some suggestion on date format conversions in dashboard prompt, here is my scenario: One of my dasboard has a month prompt…SantoshKumarBhairi 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Export Geography HierarchySummary How can I export the geography hierarchy?Content Hi, I couldn't find any option to export the full geography hierarchy as we defined in the "manage geography hie…
-
Retrieve top 2 records per employeeSummary Need to figure out a way to determine the top 2 records for an employeeContent Hi All, I am read through some posts but still haven't found a solution for what I…User_2025-02-04-08-51-08-912 42 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Absence Accrual Plan attributes report neededSummary Is it possible to create a report that dumps all of the attributes related to an Accrual Plan?Content In OTBI, using the Subject Area: "Workforce Management - Ac…
-
Absence Report (back in time)Summary Is it possible to report absences as they were back in time?Content Hi, I provided a report to one of our customers yesterday that showed all absence between Jan…User_2025-02-05-22-44-35-842 39 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Performance issue in absence line manager in OTBI reportsSummary Performance issue in absence line manager in OTBI reportsContent Hi Experts, I'm facing performance issue in a simple otbi report, my report has below fields Emp…Pradvin Prabhakar 28 views 5 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM
-
Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeSummary Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeContent Hello guys, Here is our business problem: Some of our co…User_2025-02-05-11-42-08-011 26 views 2 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
Security Matrix - Custom AnalyticsSummary Sharing the Security Matrix Analytics which reports the mappings between rolesContent Hello All, I have seen lot of posts asking for a solution to generate the S…Sricharan Monigari 339 views 16 comments 11 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
job name changeSummary OTBI analysis to show job name historyContent Hi, I've searched the forum and sharing centre for this but can't see anything, so apologies if answered elsewhere.…User_2025-02-08-05-56-00-229 30 views 3 comments 0 points Most recent by User_2025-02-08-05-56-00-229 Reporting and Analytics for HCM
-
Workforce Trend Real Time PerformanceSummary Is there anything I can do to tune the performance of this subject area?Content Hello Experts! I'm starting to use Workforce Trends where we are trying to count …Rob F 37 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM