Reports
Discussion List
-
Export Pivot Table with >75k rows (Data Model)Summary Trying to export Pivot but keep hitting row limitContent Hi, I have a pivot view on a report that I need to export out in to Excel. Unfortunately, the list canno…User_2025-02-05-15-09-04-091 34 views 4 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Audit Log on reportsContent Hi Experts, We are having multiple BI publisher and OBIEE reports set up in UAT and production environments. What is the most efficient way to run audit on the r…User_2025-01-30-00-14-06-021 144 views 7 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
What's New in 19.09?Summary ...getting this in under the wire!Content Yes, I know I’m posting this a little later than normal as 19.09 is set to hit Test pods in a few hours but rest easy a… -
Fiscal Year ReportingSummary Reporting from 1st date of fiscal year up until today, and from tomorrow up until last date of fiscal yearContent Hi, I am still very new to OTBI and SQL. What I…User_2025-02-05-10-44-58-756 62 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Benefits Service DateSummary Where do we find the field for benefits service date in OTBI. We are needing to pull that field into many reports but only find other seniority dates.Sarita Schumacher 57 views 6 comments 0 points Most recent by Maria VanderMolen Reporting and Analytics for HCM -
If we can track if the BI report last modified by which userContent Hi, We need to find last modified by on DM and Reports , if we can track if the BI report last modified by which user Regards NidhiNidhi Chhajed 61 views 6 comments 1 point Most recent by Nidhi Chhajed Reporting and Analytics for HCM
-
Oracle Learning Cloud (OLC) OTBI Reports not pulling employee dataSummary Using OLC Subject AreaContent Hi all, I'm trying to create a report in the OLC Subject area. I've been able to pull in the Learning information, but I can't pull…User_2025-01-31-00-25-12-234 37 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extracting a field effective to specific dateContent Hi all. i'm creating an internal mobility and promotions OTBI report based on Assignment Event subject area. i'm filtering all "internal mobility" and "promotion…User_2025-01-30-20-17-38-289 51 views 5 comments 0 points Most recent by User_2025-01-30-20-17-38-289 Reporting and Analytics for HCM
-
FR report with 2 gridsSummary Need to create a FR Report with 2 grids from 2 databaseContent Hi everyone,I'm in a move to cloud and I have some reports from financial reporting that have one …Mayela de la Vega Duque-143698 37 views 3 comments 0 points Most recent by Mayela de la Vega Duque-143698 Planning
-
BI Publisher Handle No Data in RTF TemplateSummary BI Publisher Handle No Data in RTF TemplateContent How to handle no Data in RTF template to show a message in RTF instead to generate the report. The XML has 2 l…Misael Gutiérrez-Oracle 86 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
OTBI Report formattingSummary Trying to move data around to get everything in one row.Content I am trying to make each of the phone types its own column so that everything will appear in one …Brittany Lewis 246 views 29 comments 2 points Most recent by Renuka Nuguru-Oracle Reporting and Analytics for HCM
-
OTBI reporting on expired approvals/transactions not workingSummary The delivered subject areas do not allow for 'expired' status to be reported upon.Content We have recently configured our approvals to expire after 21 days if th…Denise Rae 50 views 7 comments 0 points Most recent by Manivannan Ramar Reporting and Analytics for HCM
-
Goal Status Report - Capture Associates With and Without Goals CreatedContent We are attempting to create a performance goal tracking report that captures associates who have created goals as well as associates who have not created a goal …User_2025-01-23-23-27-03-729 132 views 6 comments 1 point Most recent by User_2025-01-28-05-32-59-092 Reporting and Analytics for HCM
-
Optionally display analysis filter at bottom of reportContent I have the filter appear at the bottom of my analysis. Is there a way for this to optionally show? For example, it appears on the bottom of the report but the us…Annette M 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to count by hierarchy level only the managersSummary Need to create an OTBI analytic which will count from level to level only the manager not the ICsContent Hi all, I was able to create an analytic which shows alr…User_2025-01-23-22-38-50-675 71 views 4 comments 0 points Most recent by User_2025-01-28-20-24-47-566 Reporting and Analytics for HCM
-
Typing members into formula bar returns error (in Reporting Web Studio)Summary Sometimes, entering a member into the formula bar directly returns an "invalid member" error messageContent Sometimes, but not all the times, and I have yet to u…
-
Count FunctionContent Hi Guys, I need to realize a report that bring me the number of course assignment characterized by a specific status, But if i use a simple count on name of empl…Giuseppe Iacono 47 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display condition based counts in OTBI pivot reports?Summary How to display condition based counts in OTBI pivot reports?Content Hello All - Looking for your inputs on this pivot report. I have a condition like this (CASE …User_2025-01-25-04-02-13-126 37 views 2 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
BI Publisher : Edit button on the Search windowSummary How to enable the Edit button on the Search box in BI Publisher reportsContent Hello, Has anyone Know how to enable the edit button on the search dialog in a BI …Eduardo Nava 60 views 2 comments 0 points Most recent by Eduardo Nava Reporting and Analytics for HCM
-
Toggle to include/exclude a column on reportContent I have an analysis that I want to prompt the user to include or exclude the SSN. I would rather do this than to maintain two reports. How would I create a prompt…Annette M 28 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle capability in HRIS teamContent Hi Experts group, Today i have a generic question and not technological. My current organisation installed Oracle HCM Cloud in 2017 October and since then I am w…User_2025-01-30-00-14-06-021 57 views 5 comments 2 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
Embedded analytics in HCM Pages and the new responsive UISummary We have been using embedded OTBI reports in pages for employees and managers in self service but the new UI does not seem to allow for new boxes to be added to e…User_2025-02-04-05-34-39-836 174 views 10 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
How Retained Earnings should be managed in planningContent Hi All, I need a clarification on how to manage retained earnings within a planning application for reporting purposes across different scenarios such as Actual,…User_2025-02-01-07-41-50-723 50 views 6 comments 2 points Most recent by User_2025-02-01-07-41-50-723 Planning
-
How can we exclude the login user from the Headcount in the OTBI AnalysisContent How can we exclude the login user from the Headcount in the OTBI Analysis. We have are requirement, If a manager logs in and execute the report to see the headco…
-
Only able to see Line Mangers in Worker Assignment subject areaSummary When reporting manager's information, I can only see records of Line MangersContent Hi I'm doing a report where I need to pull all the different managers that an…Rogelio H 66 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create QR code in RTF template for OTBISummary Create QR code in RTF template for OTBIContent I am trying to implement a QR code for the employee number I have followed the documentation: https://docs.oracle.…Cesar Tepetla Corte 104 views 6 comments 0 points Most recent by Ognjen Pavlovic, HCM Product Management-Oracle Reporting and Analytics for HCM -
Fields added to custom RTF don't show and fields removed still showContent Hello All, I have customized a seeded RTF where I added DFFs to the RTF template and removed unwanted fields from the RTF. However, when I print the document fro…PriyaPenugonda-SC 41 views 9 comments 0 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM