Reports
Discussion List
-
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…User_2025-02-10-08-27-16-805 32 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo… -
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 60 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
Tables for getting user information under Security consoleSummary Query to get security console User infoContent Hi All, I am developing a BI Publisher report to get the User information that is available under Security console…SuryaMuralidharan 904 views 5 comments 0 points Most recent by Ravi Shinde Reporting and Analytics for HCM -
New Line of data for each variableSummary Just checking options available to prevent multiple lines if data in reportsContent Hi, I think I know the answer to this already but apart from using BI Publish…User_2025-02-05-22-44-35-842 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to initiate HCM BI Publisher Reports from a batch script on a seperate server?Content We are hoping to integrate HCM to a custom EPM implementation using BI Publisher extracts.We are hoping to integrate HCM to a custom EPM implementation using BI …Mike Falconer-160618 39 views 1 comment 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM -
Ability to add hierarchy fields as Dashboard promptsSummary Unable to add hierarchy fields as Dashboard promptsContent I am trying to add "Hierarchy"."Level 1 Department" from Worker Assignment real time subject area as D…User_2025-02-10-08-27-16-805 29 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide options in cogwheel on embedded DashboardSummary As the title implies, we have a dashboard that we would like to hide some options on.Content Hi all, In the attached picture, we have two dashboards -- the botto…CIT Shane 21 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Identify users logged into the applicationSummary Identify users logged into the applicationContent Hi All, does anyone know if there is a report or process that can be run to check which users are logged into t…Shazia 52 views 4 comments 0 points Most recent by User_2025-01-28-18-57-36-641 Reporting and Analytics for HCM -
User Role Historical DataSummary Getting the Historical data of RoleContent Hi, Is it possible to get the historical data of User Role in HCM? We are not using the End_date on the user role, but…User_2025-02-04-07-19-57-588 62 views 5 comments 1 point Most recent by Ravi Shinde Reporting and Analytics for HCM
-
BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCMSummary BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCMContent Hi All, Please find below URL; https://youtu.be/XSt2S3xBBx0 T…
-
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
-
(Under Oracle Review) Data Dictionary for ReportsSummary Create Data Dictionary for ReportsContent We want to have a data dictionary of our reports created Can this be pulled via SQL. 1. Path 2. Report Name 3. Report D…User_2025-02-04-14-57-35-200 49 views 8 comments 1 point Most recent by User720640-Oracle Reporting and Analytics for HCM
-
Creating Charts in BI PublisherSummary Need resources on how to design charts on BI Publisher reportsContent I am needing to create some statistical charts from BI Publisher reports. I have gotten so …Shelly Feyerherm 46 views 2 comments 2 points Most recent by Tom Strudley 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 79 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM
-
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… -
AAP - Disablity Self Disclosure field in OTBI analysisSummary AAP - Disablity Self Disclosure field in OTBI analysisContent Hello, Like many of us, we are getting ready to do our annual AAP reports. For Disability Self Disc…User_2025-02-04-15-06-22-759 44 views 1 comment 0 points Most recent by Raghavendra Raghunath-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 490 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Trying to embed a dashboard on shared My Team PagesSummary Trying to embed a dashboard on shared My Team PagesContent On the Manage my team absence balance page (We have renamed this to Time Off Balances) I have embedded…Matthew DeCilio 44 views 3 comments 1 point Most recent by Matthew DeCilio Reporting and Analytics for HCM
-
Selecting All outputs in ESS Job by default?Summary Selecting All outputs in ESS Job by default?Content Hi All, I have created a report with 6 templates and i have created ESS Job for it. I can able to select all …User_2025-02-06-10-33-36-755 33 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Data Models Best PracticesSummary Are the Best Practices for Building Data Models using Tables vs. ViewsContent Wondering if there are best practice guidelines for building Data Models? For examp…Denise Izzi 54 views 4 comments 0 points Most recent by Valeriy Gorbunov-80491 Reporting and Analytics for HCM
-
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 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 57 views 9 comments 1 point Most recent by SantoshKumarBhairi 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 26 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Need to restrict Moving folders from one folder to another Folder in BISummary Moving BI Folders from one folder to another folderContent Hi Team, We want to restrict Moving the BI folders from one folder to another folder in BI. please sha…
-
Duplicate Values in OTBI ReportSummary Receiving duplicate employee lines due to historical manager changesContent When running a report in Subject area "Worker Assignment Real Time" everything is fin…User_2025-10-31-00-47-29-616 530 views 1 comment 0 points Most recent by User_2025-01-30-17-37-30-647 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…
-
Changing Report Schedule which is running as ExtractSummary Changing Report Schedule which is running as ExtractContent Hi All, I have a report running as an Extract. I want to change schedule of it. Can someone guide me.…User_2025-02-07-19-03-14-525 31 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM