OTBI
Discussion List
-
General BIP Report AssistanceSummary I have a series of questions about a BIP report I am trying to developContent Hi all, I just have a series of questions about BIP reports/Dashboards when embeddi…CIT Shane 70 views 9 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 35 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Recover Deleted Report or FolderSummary How can I recover a deleted report or folder in any environment after deletion?Content Hi all, I would like to know if there is a recover option when a report or…User_2025-02-05-05-51-12-049 86 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM
-
Emergency Contact Details Report - Required Duty/Data RoleContent Hi All, We have created Emergency Contact Details Report from Person Subject Area to support our Business Continouity agenda (attached). We have two custom roles… -
Workforce Management - Position Real Time - Missing Assignment CategorySummary Unable to find Assignment Category field in Position Real Time subject AreaContent When creating a position, we are using 3 fields on the setup - Assignment Cate… -
Need past 8 years historical data based on a effective date-OTBI analysisSummary Need past 8 years historical data(Counts based on their color) based on a effective date-OTBI analysis, We need to show data in a Graphical format attached.Conte…Nithin Channa 53 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Absence Report showing Annual Accrual, Carryover and remaining balanceSummary Require a report that will show the employee absence information for reporting purposesContent Hi All, I need some help in trying to figure out where my numbers …User_2025-02-04-08-51-08-912 512 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Current Performance Document TaskSummary Looking for a report showing only the current document taskContent We are looking for a report, one line per employee, that would list the current step that thei…
-
Is there any way to connect Oracle Fusion OBI from SQL ServerContent H Is there a way to connect to Oracle Fusion OBI server to our local SQL Server? We would like to report on Data in conjunction to our local HRIS system. Thanks,…Nizar Kassam 55 views 8 comments 2 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisSummary How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisContent Hi All, We have a DFF attribute called Beneficial ser…
-
Combining Pay Dates in a ReportSummary Need to combine all Results by Date Paid into one Number by MonthContent Greetings, I have a detailed pivot table that displays the run results by pay period by …Thomas Drzaic 33 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need to display Hire details from last six months in OTBI reportContent Hi All, We have a requirement to display HIRE Employees from last six months in OTBI report. In OTBI analysis we selected "Workforce Management - Worker Assignme…
-
SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBISummary SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBIContent Hi All, Can some one explain to me that how does the below conditions work and what's the in detail meaning…
-
Caution -> Inappropriate Content through re-direct links in Sample OTBI Dashboard (change link for cContent Hello, The seeded 'Sample OTBI Dashboard' (Profiles / Assignment Details and Drill to Person Gallery') has a link which goes to 'inappropriate content'. I guess …SantoshKumarBhairi 88 views 2 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
OTBI Custom Reports - User Interface Language Issues (English vs French)Content Hello, Can anyone please help me with these two questions? 1) created a custom report (based on seeded SubjectAreas) and renamed the columns in English. When Use…SantoshKumarBhairi 65 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Customizing seeded dashboardsSummary Looking for a more efficient way to customize seeded OTBI analysis that are part of the standard dashboardsContent Our customer, like many in the region, do not …Daan Beumer 69 views 9 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
How to fine tune OTBI reportSummary How to fine tune OTBI reportContent Hi All - We created an OTBI report using 2 SA's and embedded it on UI using sandbox for line managers. This fetches assignmen…User_2025-01-25-04-02-13-126 60 views 6 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Changing labels for seeded analyticsSummary Changing graph title labels for seeded analyticsContent Hello We made a copy of the seeded line manager dashboard and are making modifications to fit our require…User_2025-02-10-08-27-16-805 31 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Not able to uncheck hidden option for seeded otbi analysisSummary Not able to uncheck hidden option for seeded otbi analysisContent When I am trying to uncheck hidden option from properties of seeded analysis getting below erro…User_XT9HW 33 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Absence analysis not returning any data from ESSSummary Absence analysis not returning any data from ESS login.Content Hi, We have created custom absence report based on subject Area Workforce Management – Accrual Rea…Devendra Prabhu 40 views 7 comments 0 points Most recent by Devendra Prabhu Reporting and Analytics for HCM
-
Percentage calculation in stacked bar chartSummary Percentage calculation in stacked bar chartContent Hi Team, We have a stacked bar chart and the user would like to have the hover over box also show the percenta…
-
Need Sample Dashboards On Talent Review (Talent Management)Content Hi All, I am Trying to build a dashboard for Talent Review using (OTBI Reports) and in need of sample dashboard for the same. Can you please share catalog file f…
-
OTBI vs BIPContent All - on Julian's OTBI call today, I asked about the benefits of using OTBI vs using BIP. I am aware of when we use BIP instead of OTBI (data not available in OT…Prudence K 2.1K views 18 comments 18 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Cross subject area questionSummary OTBI - Cross subject area join issueContent Hi, I am trying to build an analysis using 2 subject areas Using Benefits - Enrollments Real Time and Workforce Manag…Phani S-Oracle 66 views 4 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
Replace CURRENT_DATE in formula to get previous yearSummary Head count by length of service reportContent We currently have a report called Headcount by Length of Service. I am trying to pull the previous years (2019) dat…Rebekah Gilday 85 views 3 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Oracle BIP Bursting of PDF Output to a 'local' directorySummary Oracle BIP Bursting of PDF Output to a 'local' directoryContent Hello, I was trying to schedule a BIP job to burst the output file type of PDF to a local machine…SantoshKumarBhairi 222 views 3 comments 2 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
Need to Know How Filter Results to Last Two WeeksSummary I have a report in OTBI that I need to filter the results to only show the last two weeksContent Hello everyone, I need some help with filtering my results on a …Andy Whalen 40 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to enable HCM infoletsSummary How to enable HCM infoletsContent Hi, My requirement is to enable infolet and put an OTBI analysis onto it. I navigate to home page clicking on Home icon. Bottom… -
Transaction Approvals - Correlation to HCM OTBI subject areasSummary Transaction Approvals - Correlation to HCM OTBI subject areasContent Hi, The July OTBI Office Hours event (https://cloudcustomerconnect.oracle.com/posts/c06d1ba6…Karen Waddell 50 views 2 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM -
OTBI report to show Line manager direct and indirect reporters and not as per the person security prContent Hello Experts, We are creating a Absence report to for the Line Manager to display their direct and indirect reporters absences. We have a scenario where the lin…HarishVummidi 103 views 2 comments 0 points Most recent by Carlos Cuéllar Flores Reporting and Analytics for HCM