OTBI
Discussion List
-
Can we get Parent Business Unit Name of business Unit name in Analysis?Summary How to get Parent Business Unit Name of business Unit name in AnalysisContent How to get Parent Business Unit Name of business Unit name in Analysis.My requireme… -
Improving Performance with Hierarchy ColumnsSummary Is there anything to speed up the performance of Hierarchy ColumnsContent Hello, I love the idea of the hierarchy columns. Having an easily expandable hierarchy …Rob F 48 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
License and Certification ReportContent Hello, I was wondering if anyone has created a License and Certification Report with Expiration Dates for employees? I'm trying to pull in the information, but n…User_2025-01-31-00-25-12-234 127 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
URL to LSQL Analysis with ParameterSummary How to prompt on LSQL column so that assignment_id can be passed in URL?Content Hi guys, We have a Logical SQL analysis which we'd like to embed on the app scree…Pavel Kartuz 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get Parent Business Unit Name of business Unit name in AnalysisSummary How to get Parent Business Unit Name of business Unit name in AnalysisContent How to get Parent Business Unit Name of business Unit name in Analysis.My requireme…
-
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi…Yaniv 122 views 6 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Overall Manager Rating Bar Graph - Display All ValuesContent We've drafted a performance related analysis from the Workforce Performance - Performance Rating Real Time subject area to capture overall manager rating distrib…User_2025-01-23-23-27-03-729 47 views 4 comments 0 points Most recent by User_2025-01-23-23-27-03-729 Reporting and Analytics for HCM
-
Need help with the Starting Period Active FTE and the Starting Period FTE in the Trending Subject ArSummary Starting Period Active FTE and the Starting Period FTE in the Trending Subject AreaContent I have some questions about Workforce Management - Workforce Trend Rea…User_2025-01-22-19-28-28-240 39 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Use dashboard parameters in a sub-reportSummary Use dashboard parameters in a sub-reportContent We have a dashboard utilizing an OTBI analysis that requires a sub-report. The sub-report needs the begin/end dat…User_2025-01-31-18-54-11-515 10 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu…User_MC37Q 115 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole…
-
Benefit Double DipSummary Can we tell if someone is double dipping benefit plans?Content Hi - we have been tasked to provide a report that identifies employees who are also dependents of …Prudence K 53 views 4 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Hide Operator (is LIKE (pattern match)) from dashboard promptSummary How to hide operator (is LIKE (pattern match)) appearing on Dashboard PromptContent Hi Experts, I have a requirement in my report to just show the heading and hi…
-
Predefined Filters in OTBI Subject AreasSummary Predefined Filters in OTBI Subject AreasContent I have the spreadsheets that document R13 Fusion Financials OTBI subject areas, the corresponding View Objects an…
-
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I… -
Learning Assessments - Report on ResponsesSummary I would like to report on Learning Assessment responsesContent Can anyone provide any guidance on how to report on Learning Assessment questionnaire responses, s…User_2025-01-22-19-19-20-026 137 views 2 comments 1 point Most recent by User_2025-01-30-19-08-11-304 Learning
-
OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Summary OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Content Hi, I need to know the difference between 'Keep Timestamps' and 'Ke…User_MC37Q 61 views 2 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeSummary Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeContent Hello, We are hitting an issue after last weekend 18C upgrade, while …Suresh Pallapothu 54 views 4 comments 0 points Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
Export Embeded Dashboard to Excel in HCMContent All, Is there a way to export a dashboard that is embedded to page in HCM? The export option seems to be only available when the user is in OTBI...Charles Egegbara 52 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 41 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Users unable to see some report results on an embedded dashboardSummary We have a report on a dashboard with formula and conditional formatting for staff to quickly review their time balances but this is not working correctly.Content…Lee_B 30 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Filter based on selected EmployeeSummary How to pass selected employee Person ID into a filterContent Hi I have a basic Analysis I'd like to place on the Absence self service page (old UI, not the new s…User_2025-01-25-01-23-28-110 49 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report needed for real-time Assets source linesSummary Has anyone created an OTBI report that provides current asset source lines?Content I work with Fusion Assets and am wondering if there is a standard report or if…User_2025-01-28-20-11-21-100 65 views 1 comment 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP