OTBI
Discussion List
-
Showing Percentages in a Bar PivotSummary Is there a trick to show percentages on a scroll over of a bar pivot with actual values?Content Hello all, I am using OTBI to develop some reports and the user p…Nicolas Trojack-24006 95 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Add Trimestre prompt in BI publisher depending on assingment tableSummary I want to add a prompt in bi publisher report which is Trimestre and depends on per_all_assignments_m (effective_start_date)Content Hello, How can i define on sq… -
getting odbc error when trying to run dashboard downloaded from Cust ConnectSummary getting error: Failed to load(Odbc driver returned an error (SQLExecDirectW).)Content downloaded analytics some time ago from Customer Connect - "sample OTBI Das…John Sale 70 views 4 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Goals - Not Assigned/Tasked to EmployeesContent Good Day, Is there a way we can pull a list back within an analysis to show all employees that have 'NOT' been given a goal for mid/end of year review from the P…User_2025-01-28-07-12-45-467 78 views 10 comments 0 points Most recent by User_2025-01-29-01-27-20-754 Reporting and Analytics for HCM -
Translate Bi Publisher and OTBI report ?Summary Columns , title and values can be translated in OTBI and BI Publisher reports?Content Hello, Is it possible to translate columns in reports and title and values …User_I6AXL 58 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Competency Rating in PerformanceSummary I need to pull item ratings and item comments a manager entered in the Competency section in a performance documentContent HELP!!!! I need to pull item ratings a…Gala Meyerovich 188 views 2 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
What is the significance of Role Type = ManagerSummary Need to understand why almost every Performance and Goals related subject area uses Role Type = ManagerContent In every Subject Area associated to Performance or…Sivakumaran Muthusamy-Oracle 56 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Slow performance in OTBI AnalysisSummary Slow performance in OTBI AnalysisContent Hello, I have created some Analysis in OTBI. I see that are very slow or they go in time out. The reports have 4 attribu…Giuseppe 1234 223 views 2 comments 0 points Most recent by Giuseppe 1234 Reporting and Analytics for HCM -
Combine Multiple RowsSummary How do I combine multiple rows for a person into one row?Content We have a report that pulls in our terminations for the day. There are some employees that are s…Prudence K 105 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Users cannot run BIP reportsSummary Users cannot run BIP reportsContent Employees with our custom role cannot run a BIP reports, however, I am able to run the same reporting using delivered employe…AbulKhair 63 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
how can i get individual PDRs onto my PDR report?Summary PDRsContent Hi I have created a PDR report which brings back the lines for the last 3 years of every employees PDR (personal development review) using Workforce …User_2025-01-29-02-09-34-137 15 views 0 comments 0 points Most recent by User_2025-01-29-02-09-34-137 Reporting and Analytics for HCM
-
I am having trouble creating a report, please helpSummary Trouble with reportContent Hi, I am having trouble with creating a report to show Headcount on one line and FTE on another line and salary costs by year in a tab…User_2025-01-29-02-09-34-137 56 views 7 comments 0 points Most recent by User_2025-01-29-02-09-34-137 Reporting and Analytics for HCM
-
Dashboards with No Data Analysis ReportsContent GoodDay, i have created numerous amounts of dashboards and analysis reports in R11 and R12. My only query/issue is when you use the prompts to filter down on sai…User_2025-01-28-07-12-45-467 92 views 3 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM
-
How to include the name of the logged-in user generating the report in the header?Content Hi, I need to create the user field that executes the report in the header of these, in what area of the report does it allow me to include this value? Header Ex…Mirtha Antequera Borges 72 views 2 comments 0 points Most recent by Piyush Mohapatra -OC Reporting and Analytics for HCM -
Can Security Roles cause Duplicates in OTBI Analysis?Summary Troubleshooting Duplicates in AnalysisContent I have a user who is running a custom Analysis and getting duplicate and triplicate employee records returned. When…User_2025-01-28-17-24-53-863 75 views 2 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Extract OBI permission of a UserSummary Extract OBI permission of a UserContent Hello, I want to extract all OBI permission and Duty for a user. Is there a delivered functionality to extract this from …Giuseppe 1234 40 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Custom Report Line managerSummary The line manager don't see any data in custom report with person and department ot job dataContent Hello, We have created a few custom analisys for the line mana…Giuseppe 1234 113 views 2 comments 0 points Most recent by Giuseppe 1234 Reporting and Analytics for HCM
-
HR analytics roadmapSummary We would like to leverage all the data we are generating & are looking to create an HR analytics roadmap. Looking for tips suggestionsContent Hi We have just imp…Mohit Gupta-45440 123 views 6 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM -
Report Jam at OHUG OrlandoSummary June 6-8 Salon 18Content THERE ARE STILL A FEW PLACES AVAILABLE IF YOU ARE INTERESTED IN THIS EVENT We will be running the Report Jam at OHUG (June 6-8 at Orland…Julian Challenger-Oracle 34 views 0 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Introducing the BI and Reporting Idea LabSummary Have an idea that could take Oracle Business Intelligence from good to great?Content We are pleased to announce the launch of the Idea Lab for Business Intellige…Bernice Lam - Inactive 55 views 1 comment 0 points Most recent by User_2025-01-25-01-46-39-933 Reporting and Analytics for HCM -
OTBI - Dividing two numbers results ZeroContent Hi, We have a requirement to find the percentage of headcounts. In OTBI dividing two values results Zero. For Example 50/100 results 0 but whereas 100/50 results…Surendar Babu S D 47 views 8 comments 2 points Most recent by Surendar Babu S D Reporting and Analytics for HCM
-
OTBI report with person details, competency name, profile name, profile status code, position code,Content what is the most feasible way to pull data which contains employee details with competency and profile name? I had tried using subject area Workforce Performance…User_2025-01-27-23-54-00-342 147 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Release 11 HCM OTBI Subject Area descriptionsSummary List of Release 11 HCM OTBI Subject AreasContent This spreadsheet provides the list of subject areas with descriptions, business questions answered by these subj…Raghavendra Raghunath-Oracle 280 views 5 comments 6 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
degrees informations of profiles in tables fusion ?Summary I want to create a report using information of degrees of profiles in bi publisherContent Hello, Someone know please where can I found the information of degrees…User_I6AXL 74 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI - Report to see transactions approved which were initiated by Line Manager in MSSSummary OTBI - Report to see transactions approved which were initiated by Line Manager in MSSContent HR need to have visibility of when the following transactions have …Ruzwan Akram 121 views 6 comments 0 points Most recent by User_2025-01-28-07-47-26-775 Reporting and Analytics for HCM
-
R11 HCM OTBI Subject Area Mapping to Fusion HCM Database TablesSummary Release 11 HCM OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 478 views 8 comments 10 points Most recent by User720640-Oracle Reporting and Analytics for HCM -
Report Jam at OHUG OrlandoSummary June 6-8 Salon 18Content We will be running the Report Jam at OHUG (June 6-8 at Orlando) for the third year in a row. If you have a report you'd like us to build…Julian Challenger-Oracle 33 views 0 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dasboard Prompt not workingSummary Dashboard prompt not working as required. The report does not get filtered based on prompt inputsContent Hi I have created a dashboard containing an analysis fro…Mohit Gupta-45440 144 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Management ReportSummary Performance Management Report for ManagerContent Hello, I want to create a report for Manager and insert it into my Organization tab of Performance Management. I…Giuseppe 1234 178 views 6 comments 0 points Most recent by Radhika Thiagarajan Reporting and Analytics for HCM
-
Report on Development Plan from Performance FormsSummary I'm trying to report on the development plan section of the performance forms. Or removed extra rows from a report exported to excel.Content Has anyone attempted…User_2025-01-25-00-37-41-739 58 views 1 comment 0 points Most recent by Radhika Thiagarajan Reporting and Analytics for HCM