OTBI
Discussion List
-
OTBI date check End-of-timeSummary OTBI date check End-of-timeContent Hi, I am wondering if anyone has tried to check for end of time on a date column in OTBI. I wrote this. But it doesn't work. A…User_2025-02-05-23-02-10-916 35 views 3 comments 0 points Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM -
How to get count of child nodes in ETEXT templateSummary How to get count of child nodes in ETEXT templateContent Hi experts, how can i get the count of child nodes in etext template, ex : in attached xml i want to dis…Pradvin Prabhakar 134 views 6 comments 1 point Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
FTP OTBI report outputSummary Option to FTP OTBI report outputContent Is there option available to FTP OTBI report output? Pease let us know steps/process to FTP report output. Version 20C
-
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 64 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM
-
Amendment need to an existing reportSummary Multiple NationalitiesContent Hi, How can I modify the attached report so that only the primary nationality is displayed? For context, there are many employees t…User_2025-02-05-22-44-35-842 31 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Benefits report - Users accessing UI vs submitted electionsSummary Users accessed vs submitted electionsContent Would it be possible to build a report that gives number of users that access UI vs submitted elections? Attached sc…User_2025-02-10-08-27-16-805 14 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Prior Salary not showing in reportSummary Prior salary not showingContent Hi, The report attached should show all prior salaries and current salaries - one of our users has said that the Prior salary is …User_2025-02-05-22-44-35-842 38 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Account Segments Report ExampleSummary Account Segments Report ExampleContent Hello all We need to develop a report about Account Segments. We made it by Query and it is bringing the correct informati…Pedro Teixeira 20 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM -
Compensation with manager with access 'limited'Content hello, I have a question, on a compensation plan, if a manager is not eligible to a compensation plan but he manage someone inside the compensation plan, he have…User_2025-01-25-01-33-46-269 63 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Adding days to the Date prompt in OTBISummary Adding days to the Date prompt in OTBIContent Hi Team, I have one requirement to add 6 days to the prompt date and fetch the value based on the new value. +6 or …SM-Oracle 132 views 1 comment 0 points Most recent by Mallikarjuna Maganti Reporting and Analytics for HCM
-
How to enable export functionality in ReportsSummary How to enable export functionality in ReportsContent Hello, We created reports using OTBI and have put them under 'My Dashboards' but we are wondering why we can…Tony Puentes 42 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Performance tile to show a 0 instead of no resultsContent Is it possible for a performance tile to show as a '0' if there are null counts instead of it showing a message saying 'no results'User_2025-02-06-11-18-47-896 47 views 7 comments 1 point Most recent by Rob F Reporting and Analytics for HCM
-
Conditional Formatting in Pivot TableSummary Colour by Absence Type working in Table but not pivotContent Hi I'm trying to show a calendar for this month and next month. The number of days/hours shows corre… -
Report no longer workingSummary This report last worked before the April upgrade to 20BContent Hi, This report (see attached XML) no longer works - can anyone check why? There are no filters or…User_2025-02-05-22-44-35-842 23 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Query Data Model securitySummary Example of query or config to allow data models be displayed to all employees without them seeing whole company data.Content Hello all When a more robust report …Pedro Teixeira 41 views 6 comments 1 point Most recent by Pedro Teixeira Reporting and Analytics for HCM
-
How to get dynamic column names in the OTBI analysisSummary How to get dynamic column names in the OTBI analysisContent Hi, We have a requirement were we need to display the column names(labels) dynamically. THis report i…User_MC37Q 140 views 3 comments 3 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Is it possible to enable a dashboard as an InfoletSummary Is it possible to enable a dashboard as an InfoletContent We have a requirement to enable dashboard as a infolet. Tried to add dashboard as an infolet but not ge…User_XT9HW 139 views 2 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Dashboards - ObseleteSummary Dashboard - ObseleteContent Hi, Just want to know the Dashboards going to be obsolete in coming versions and Infolets will take precedence. Regards/Prasanth Vers…DineshApps 41 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Infolets - No ResultsSummary Infolets - No Results MessageContent Hi, We have created an infolet using OTBI report. Whenever there is no data for the report criteria system showing following…DineshApps 49 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Can this report be date drivenContent Hi I have created a report which shows the hierachy but what the team really needs is for it to be date driven so we can see the reporting lines for example a co…User_2025-02-06-11-18-47-896 25 views 3 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
CASE statement with IFSummary Need help with a CASE statement where it displays element input value if they have the element, else shows nullContent Hello, We have element set up like below t…User_2025-02-04-15-06-22-759 57 views 6 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Reporting on Rejected DORSummary Requirement to report on rejected DORContent Some of the DORs in our system pass through the Approval cycle. I have checked "Workforce Management - Documents of …User_2025-02-05-23-02-10-916 35 views 6 comments 1 point Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
Customization in Seeded Line Manager Dashboard for Absence pageContent Hi Experts, In the Seeded Line Manager Dashboard, the Absence page has an Absence for Today and Tomorrow analysis which displays absentees for Today and Tomorrow…Jaswant Prajapati 35 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report not showing own itemsSummary An report from timecards does not show own itemsContent We use time and labour to claim overtime as well as to record our flexi. With all our reports in OTBI, th…Dawn Cawston - CPS 44 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Split by genderContent Hi is there a way to split facts within subject areas by gender. i have tried using the filter but it returns all employees and i would like to create an attriti…User_2025-02-06-11-18-47-896 37 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
NI Category Letter in OTBISummary NI Category Letter in OTBIContent I am looking for NI Category Letter in the OTBI subject area 'Payroll - Calculation Card Real Time'. Could anyone please confir…Jay A 34 views 3 comments 0 points Most recent by Henry Winsor-Oracle Reporting and Analytics for HCM -
how we can use gif in flash template through bi publisherSummary how we can use gif in flash template through bi publisherContent how we can use gif in flash template through bi publisherSidhartha Wadhwa 32 views 1 comment 1 point Most recent by Karina Ogata Reporting and Analytics for HCM -
Report to view employees currently on redeploymentSummary How to exclude employees from a redeployment report if they have been successfully redeployed into a new roleContent I need a report that displays all employees …User_2025-02-10-22-27-57-221 22 views 2 comments 0 points Most recent by User_2025-02-10-22-27-57-221 Reporting and Analytics for HCM
-
Dashboard promptsSummary Creating a dashboard prompt using a formula based columnContent Hi We are using below formula to show the actual "Start date" of employees in the reports. IFNULL…Ridma Karunanathan 41 views 2 comments 1 point Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
OTBI: How to format Enrollment Coverage start date in the OTBI prompt to the date format to DD-MON-YContent In the prompt Enrollment Coverage start date how to change the date format to DD-MON-YYYY.? Currently the format of the date prompt is DD-MM-YYYY.User_2025-02-08-08-08-53-292 29 views 2 comments 0 points Most recent by User_2025-02-08-08-08-53-292 Reporting and Analytics for HCM