OTBI
Discussion List
-
Using analysis as a sub query - many values for the IN predicate errorSummary Using analysis as a sub query - many values for the IN predicate errorContent Hi, Using OTBI analysis as a sub query for a field for the another analysis . While…Phani S-Oracle 74 views 4 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Briefing BookSummary Customization in content of Briefing BookContent Hello, We have created a Briefing book with combination of different analysis and schedule it. Struggling with b…User_2025-02-05-07-43-29-505 67 views 4 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM -
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 56 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 30 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 84 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 49 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 483 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 50 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 26 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 83 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 59 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 61 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 55 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 27 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 26 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 32 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 1.9K 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 59 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 83 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 202 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 33 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…