OTBI
Discussion List
-
Resize a performance tileSummary I would like to arrange about 10 of them next to each other and I need to reduce size of each container.User_2025-02-08-08-49-19-186 33 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Column to be added with option 'Created by' which should give information of Employee Name - While cSummary Column to be added with option 'Created by' which should give information of Employee Name - While creation on new Analysis in reportsContent Hi, While creating …User_2025-01-24-00-17-22-300 34 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Scheduled Process (ESS Jobs)Summary Looking for report on Scheduled Process (ESS Jobs)Content Hello, I'm looking for a report on scheduled processes. Does anyone have such report and would like to …Yves Blanc 83 views 6 comments 0 points Most recent by Avinash Potti Reporting and Analytics for HCM -
Logical SQL Reports and Report HeadingsSummary Logical SQL Reports and Report HeadingsContent Hi, I have created a report using Logical SQL and was wondering if it is possible to include a user friendly Colum…Karen Waddell 32 views 7 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Set PARAM_EFFECTIVE_DATE within a UNIONSummary Combine results of 2 analysis when one has an effective dateContent I have two reports with the same columns and I am combining them with a UNION. However one an…s_b 39 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard VisualSummary Show / Hide certain visual based on a prompt field valueContent We have a requirement to show or hide a graph based on the field value of the prompt. E.g. Legal …User_2025-02-10-17-54-52-878 36 views 4 comments 0 points Most recent by User_2025-02-10-17-54-52-878 Reporting and Analytics for HCM
-
Organization Tree - Filter on active versionsSummary Provides you the process to filter out the inactive organization tree versions by defaultContent Issue: Organization Trees display all the versions in HCM OTBI s…Raghavendra Raghunath-Oracle 114 views 0 comments 1 point Started by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Point in Time Org Chart with open vacanciesContent Hello, Has anyone built a Point in Time Org Chart with open vacancies? Thanks in advance!Dishti Malhotra-Oracle 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report to show records ONLY if there was a change in a particular fieldSummary OTBI report to show records ONLY if there was a change in a particular fieldContent Hello, I need to pull a report on a weekly basis if any employee got their Ma…User_2025-02-04-15-06-22-759 348 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Agent Email Analysis Run As Of Date Derived by SQLSummary Trying to setup existing 'Point in Time' analysis with AsOfDate Parameter as automated agent that uses SQL to derive the last day of the prior month at runtimeCo…James Hoffmann 85 views 13 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
Find courses not completed in a specializationContent Hello, I have created an OTBI report for our specializations in learn, but I cannot get the report to show which courses are still outstanding. In the screen sho…User_2025-02-06-11-18-47-896 49 views 2 comments 2 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
How can I filter on column and not a measures in OTBISummary Filter in a sample column and not a measures how can i do it??????Content Hello, I want to transform a simple column in otbi into a measures to create a filter :…User_I6AXL 50 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Error with Month as a Presentation Variable PromptSummary ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent OTBI Report runs fine in Edit mode and s…
-
Selection Steps/Filters per table in one reportContent Hi all, I'm wondering if it's possible to put different filters or selection steps per table, but within one report. I'm making some headcount reports and want t…User_2025-01-31-00-25-12-234 23 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
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 57 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 23 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Workforce Management - Workforce Trend Real Time pulling current employee typeContent Hello, I'm working on making a headcount report using the Workforce Trend Subject Area, but I've noticed the subject area is pulling the current employee type ra…User_2025-01-31-00-25-12-234 23 views 7 comments 0 points Most recent by Raghavendra Raghunath-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 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to identify loops in the line manager hierarchyContent Hello, Does anyone have a report that they could share that identifies a loop in the line manager hierarchy i.e. an employee lower down in the hierarchy also man…Esther Hess 118 views 8 comments 2 points Most recent by Esther Hess 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 14 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…
-
How to modify existing OTBI analysis built using Logical SQL?Summary I am new to Logical SQL OTBI reports and want to know how to make modifications to an analysis once I created it using logiical? I have to add a new column and p…User_2025-02-05-23-02-13-475 297 views 10 comments 2 points Most recent by User_BUU5W Reporting and Analytics for HCM
-
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 378 views 3 comments 1 point Most recent by Misbahul Khair Reporting and Analytics for HCM
-
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont…Dawn Cawston - CPS 83 views 1 comment 0 points Most recent by SameerJain 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 53 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Converting what pulls through as text to a numberContent I have created a report in OTBI but the 'Displayed Input Value Meaning' is coming through as a text field rather than a number field and ideally I would like to …User_2025-02-06-11-18-47-896 936 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Invalid Payroll Transactions in the SubledgerContent We have been up for a year on Oracle and have had a very rocky go of it. We have about 50k (yep thats right) invalid transactions for 2020 in the subledger from …Rebecca McArthur 30 views 2 comments 0 points Most recent by Rebecca McArthur Reporting and Analytics for HCM