Reports
Discussion List
-
Cross-Subject Area Report with 'Security - Roles and Privileges Real Time'Content We are in search of a report that would require a cross-subject area analysis using Worker Assignment Real Time and Security Roles and Privileges Real Time. I am…User_2025-02-08-03-57-26-191 59 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
schedule a OTBI Report when data is thereContent Hi, I want scheduler to run only when report has data. I have developed OTBI Report. Can you please tell me how I can do it in BI and OTBI. Thanks, VijayUser_2025-02-07-19-03-14-525 28 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Business Unit Headcount vs recognitionContent I am trying to create a pivot table to show headcount of business unit against our recognition values which employees have been awarded. So I can clearerly see a…User_2025-02-06-11-18-47-896 26 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report with null data between tablesContent Hello experts I've managed to make an interaction between 2 tables in OTBI DataModel. Then I need to create a report. The problem is the report does not show the…Pedro Teixeira 21 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Summary Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Content Hi, We have a requirement were we need to hide a Performance Ti… -
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…Pedro Teixeira 332 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Reporting on reversed terminationsContent Hi all, I have searched on this topic but have not found a working example of this report or confirmation that it can be done. Can anyone advise whether it is po… -
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…Jaswant Prajapati 376 views 3 comments 1 point Most recent by Misbahul Khair Reporting and Analytics for HCM -
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r…User_2025-01-25-04-02-13-126 328 views 24 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Unable to access reports and analytics after userid changes in OTBISummary User no longer is able to access reports and analytics. Receives error 'Unable to reconnect (after 3 tries) to BI Presentation Server using the connection Id =BI… -
Unable to Combine 2 Subject Areas throws error.Summary I am trying to combine Compensation salary history and payroll element history Subject area it throws me error. If someone can help out or would appreciate if th…User_2025-02-07-09-10-02-492 57 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Field School Empty in Subject Area “Workforce Profiles – Person Profile Real Time”Content Hello All, We have created the following report “Report Degree” which uses the subject area “Workforce Profiles – Person Profile Real Time” and the following col…Bernard T 67 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Point in Time - Home Address for EmployeesSummary Point in Time - Home Address for EmployeesContent Does anyone know if it is possible to create a report that returns employee's home address as of a specific dat…Kathleen Nguyen 29 views 8 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM -
Non Prod Last refresh (P2T) dateSummary Non Prod Last refresh (P2T) dateContent Hello All, Is there any way we can find the Non Prod environment last refresh (P2T) date by using a query/table or profil… -
Question marks in attributes causing filtering troubleContent Hello Experts, We've encountered a situation where a course has been setup in our learning module with a question mark at the end. We've found that when we try t…Rob F 18 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal pSummary Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal plan, FYI notification get triggered)Content Hi Expert, Query/… -
User behavior and AnalyticsSummary Is there a BI table which captures information on user behaviorsContent Our customer is looking for information on user behavior - which Fusion page is being use…Akash Kiran Jana 33 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
How can I get Job Change Date?Summary Sending data to LMS need to send Date a job changesContent Hello Everyone, I am having a business case where we as a company need to send Job start date and when…User_2025-02-10-15-06-52-222 74 views 4 comments 0 points Most recent by Rahul Bedia Reporting and Analytics for HCM -
Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI repoSummary Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI reportContent Hi I have 2 prompts on my OTBI report. Period Name … -
Reporting HCM Catalog Group and Folder PermissionSummary Creating report to get the list of accounts under Catalog GroupsContent Hi All, I know that we can able to report within OBIEE Reports by creating Data Source. W…User_2025-02-04-07-19-57-588 48 views 2 comments 2 points Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM -
Group By Function ErrorContent Hello, I'm trying to used the ranked last function and group by Person Number to pull the employee's latest assignment, but I keep receiving the below error. I'v…User_2025-01-31-00-25-12-234 46 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Show Field Data in Column instead of in RowsSummary Working on this in OTBIContent Hi All, I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using ra…tiffnyc 35 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard PromptsSummary AsOfDate not working in my customised versionContent Hi, I have been trying to copy and then customise the Line Manager Dashboard to suit our organisation which …User_2025-02-05-22-44-35-842 71 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to Use Result of One Column in Formula for Next ColumnContent Hello there Reporting and Analytics experts. I am hoping one of you can help me out with an analysis I am working on. I am trying to get our FTE reports up and g… -
Recruiting - Reporting on a candidate source when added by a recruiterContent HI experts, I need your help if possible. We haven't been using agency recruiting in ORC because of a system functionality issue so have had to resort to a worka…User_2025-01-25-04-04-47-442 82 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Historic Position, Dept, job detailContent I have opened an idea ticket, but just checking to see if anyone has figured our how to create a assignment history report that brings in the position, job, dept… -
Error in OTBI Analysis Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PContent Hi All, I have a OTBI analysis with Graph. When I move my cursor over the graph I see Hand means it's clickable. When i click I get following error, Can someone …User_2025-02-07-19-03-14-525 241 views 4 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…User_2025-02-07-19-03-14-525 63 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t…
-
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 153 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM