OTBI
Discussion List
-
Finding Active Assignments with Inactive ManagersContent I need to find Active Assignments where any of the Matrix Managers are inactive. (though I'd settle for line managers) I could create an analysis of Inactive ass… -
Effective Dated Headcount Report with SalaryContent Attempting to create an effective dated Headcount report with salary details that reports data as of a prompted point in time. Able to create the report to inclu…Jason Linkus 137 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Hierarchy Traversal in BI Data Model ReportContent Please refer to the images attached. Referring to IMAGE1. In column level we want to show business unit in level2(by default on opening the report) from the orga… -
Report showing Employee's Line Manager and Business Unit DirectorContent Hi All, I am struggling to create a report showing an Employee's direct Line Manager and Business Unit Director. When I create it, I get the hierarchy for that e…Aaron Leggett 87 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Job Competency ReportContent Morning all, I'm looking to build a basic report that shows the competencies we have built against each job profile, but I'm struggling to find what subject area…Evan Jenkins 58 views 2 comments 0 points Most recent by Evan Jenkins Reporting and Analytics for HCM -
Date subtraction in eText templateContent Hi All, I am facing issues in date manipulation in the eText Template. Seeded date functions are not working and traditional date subtraction are not returning v…Puja Bharati-27866 84 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Pivot Table - adding a column to total values per sectionSummary adding a column to sum values in each sectionContent We have a goal plan which is sectioned by goal categories. I am creating a report for our goal admins for th…Shelly Feyerherm-2023 71 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI dashboardSummary Can OTBI provide interactive dashboard capability using aggregated dataBindu Vasa 95 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is the field Revoke User Access in work relationship page in any subject area in OTBISummary The field "Revoke User Access" stores option of revoking user access on Termination. We need to pull it in an OTBI report, but we have not been able to find it i…Linda Huang 42 views 3 comments 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
Veteran StatusSummary PER_PEOPLE_LEGISLATIVE_F ;PER_PERSON_LEGISLATIVE_DATA_LEG_DDF'Content Can someone please help on attribute mapping from the application screen(i.e Armed Forces S…Aparajita Jena 120 views 2 comments 0 points Most recent by Aparajita Jena Reporting and Analytics for HCM
-
Amending Graph DesignsContent Morning all I've built a Performance Dashboard (attached), but had a few questions that I haven't yet found answers to: 1. I'd like to change the colours of the …Evan Jenkins 60 views 4 comments 0 points Most recent by Evan Jenkins Reporting and Analytics for HCM
-
"All" value in Graph PromptContent I've built a basic Performance Document summary (see attached) It uses a Column Selector for Division / Department / Business Unit / Location, and I've also adde…Evan Jenkins 61 views 2 comments 0 points Most recent by Evan Jenkins Reporting and Analytics for HCM
-
Budget report for workforce compensationSummary Direct employees is missing from the reportContent Hello, We are building a report to present the total budget for the manager, per country. For some reason the …
-
Reporting PathContent Dear Experts, There are many reports listed below, I found only few of them, for rest of reports path is mentioned in the sheet i downloaded from oracle docs is … -
Why it shows "DATA_DS"?Content I tried to build a data model using query builder option. But it did not show any results except "DATA_DS". I would like know the reason for it. Please find atta…Ayesha Thilakarathna-51043 60 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Element EntriesSummary Is there a way to report on who modified what element entries?Content Hi all - I have searched through existing posts and do not believe I have found anything th… -
Employee's Management Level in the OrganisationSummary Employee's Management Level in the OrganisationContent Hello, Can anyone please help me? I am trying to build a report in OTBI which gives the list of employees …SantoshKumarBhairi 65 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
performance rating overlaySummary Attempting to show comparison to a valueContent Hello All, I am working on a report that will show in real time a line graph of what % of users have what perform…Nicolas Trojack-24006 61 views 0 comments 0 points Started by Nicolas Trojack-24006 Performance Management -
HCM - "Manager Resources Dashboard" - Location of its Objects in BI CatalogSummary HCM - "Manager Resources Dashboard" - Location of its Objects in BI CatalogContent Hello, I would need to include a component 'My Organization' from the seeded '…SantoshKumarBhairi 139 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Encountering Inaccessible Column Error When Running Report as an EmployeeSummary Encountering Inaccessible Column Error When Running Report as an EmployeeContent Hi Experts, We have created a Report on WorkForce Management - Work Relationship…AshishERPCloud 36 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Users doesn't have BI Reports access based custom roles after R12Summary Users doesn't have BI Reports access based custom roles after R12Content Users doesn't have BI Reports access based custom roles after R12. Will be appreciated f… -
Compensation - which table contains the comments ?Content Hello, In the compensation sheet, you can add a column in which the manager can add a comment. I need to extract all the comments with BI Publisher or OTBI. Is a…Amaury Blanc 46 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Sickness Absence & Right to Work DashboardsContent Hello, I'm looking to provide two dashboards to the business based around 1) sickness absence and 2) the status of an employees right to work (nationality/passpo…Linda Stelling-61686 82 views 2 comments 0 points Most recent by Linda Stelling-61686 Reporting and Analytics for HCM
-
OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is usedSummary OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is used as the destination of more than one View LinkContent We are …Naveen Bitra 38 views 6 comments 0 points Most recent by Naveen Bitra Reporting and Analytics for HCM
-
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle)Content This note provides information about Fusion OTBI R12 PB10 (2…User720640-Oracle 42 views 0 comments 0 points Started by User720640-Oracle Reporting and Analytics for HCM -
Error 500 --Internal Server Error - BIP ReportsSummary Error 500 --Internal Server ErrorContent We have created a BIP reports but when we run it we get the following error message. Is there a way to fix it? thank you
-
Talent Profile data of ex-employees?Summary To be able to analyze the quality of talent that have left our companyContent Hi CC Community, We are trying to get Talent Profile data from OTBI. More specifica…Pnguyen-Oracle 50 views 2 comments 0 points Most recent by Pnguyen-Oracle Reporting and Analytics for HCM
-
Tables vs Subject AreaSummary How to quickly find the right Subject Area from a particular tableContent Hello everyone, I have a Disco report based on the following tables. So, we may say the…Alvaro Couto 121 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Number of hires by contract type in OTBI reportSummary I want to use 2 subject areas (contract type) and assi event real time to display number of hires by contractContent Hello, I m not able to join the number of hi…User_I6AXL 35 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Termination report with subquerySummary Looking for a subquery that would eliminate currently active employees form termination reportContent Hello, I am trying to build a termination report for our or…Ewelina Januszewicz 97 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM