OTBI
Discussion List
-
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 45 views 7 comments 1 point Most recent by Rob F Reporting and Analytics for HCM -
Want to extract Data from Report & analytics by writing SQL QuerySummary Want to extract Data from Report & analytics by writing SQL QueryContent I Want to extract Data from Report & analytics by writing SQL Query. Previously i use ex… -
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 39 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 150 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 48 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 56 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 32 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Not able to view any result from Subject Area Workforce Learning - Learning Content Items Real TimeSummary Not able to view any result from Subject Area Workforce Learning - Learning Content Items Real TimeContent Hi Expert, are you able to get any result from subject… -
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 -
OTBI Analysis - Invoices paid by date paidSummary Want to create an analysis which can be run by payment date of invoiceContent Hello, This is probably a very basic question but I wanted to create an analysis or…User_2025-02-04-19-45-49-438 360 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
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 36 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 45 views 3 comments 0 points Most recent by Henry Winsor-Oracle Reporting and Analytics for HCM -
Supplier Spend ReportSummary Supplier Spend ReportContent Hi, As stated, we would like to ask for your help if there is a standard supplier spend report in Oracle. What we need is the actual…Gene Garcia 570 views 2 comments 0 points Most recent by Kent Sarmiento Reporting and Analytics for ERP -
R13 Please Share an SQL/OTBI to get Customer Detail InformationSummary SQL to get Customer Detail InformationContent Hello : As far as I know there are not any Customer Contact Listing Report avaliable , Hence I was wondering if you…gabriel kinovisques-163562 62 views 3 comments 2 points Most recent by Manwesh Jain-30070 Receivables & Collections -
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 31 views 1 comment 1 point Most recent by Karina Ogata Reporting and Analytics for HCM -
Query for Cost for an itemSummary Query for Cost for an item and navigation to check the cost for an item in the pageContent Which table stores the cost for an item and where we can see the cost …