OTBI
Discussion List
-
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 232 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST…Achala Munasinghe 94 views 4 comments 0 points Most recent by Achala Munasinghe Reporting and Analytics for HCM -
How security works in case of custom report?Content Hello everyone, When we are using OTBI report it is following the security profile of the user logged in and in case of bip reports we have to use secured tables…User_2025-01-25-06-20-12-259 131 views 4 comments 2 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM -
Tables and Views against OTBI Subject AreasContent Hi, Is there any resource available to refer Tables and Views against OTBI Subject Areas? Because referring OER is quite time consuming. Thanks and Regards AchalaAchala Munasinghe 101 views 3 comments 0 points Most recent by Vinit Kumar-47692 Reporting and Analytics for HCM
-
Absence and assignment details as of an effective dateContent Hi, I'm building an anaylsis in the Absence Real Time Subject Area using fields from the Worker folder and some key information from the Assignment Absence Detai…Louise Proctor-67515 65 views 3 comments 0 points Most recent by Louise Proctor-67515 Reporting and Analytics for HCM -
performance document - get date of transferContent Hello, I am trying to find when a performance document have been transferred to a new manager. Is someone know in with table (bi publisher or otbi) I can get the…User_2025-01-25-01-33-46-269 41 views 4 comments 1 point Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
Limit Prompt Choice List Values by UserSummary I'd like the choice list values for my prompts to be only the values the logged in user should see.Content My dashboard prompts are Business Unit, Department Nam…User_2025-01-25-00-37-41-739 91 views 2 comments 2 points Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM
-
Using Two Subject Matter AreasSummary When I add the additional subject matter area (Workforce Management- Work Relationship) and then add rehire recommendation, I get an error.Content Hello All, I a…User_2025-03-07-21-07-25-805 52 views 4 comments 0 points Most recent by User_2025-03-07-21-07-25-805 Reporting and Analytics for HCM
-
OTBI Report in DashboardContent I need to build a graph for the person headcount for different actions and then embed that graph in the dashboard. I understand that the person having the HR spe…
-
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…User_2025-01-28-08-31-49-398 136 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 106 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…User_2025-01-28-05-39-23-766 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 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…User_2025-01-25-06-20-12-259 507 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…User_2025-01-22-19-28-29-985 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 94 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 40 views 3 comments 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
Compare costs on the same task across projectsSummary We have a standardized work breakdown structure and would like to compare costs for the same task across projects.Content We have a standardized work breakdown s…User_2025-01-25-00-57-09-907 54 views 1 comment 0 points Most recent by Prasanna Reka-OC Reporting and Analytics for ERP
-
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 …User_2025-01-28-05-39-23-766 59 views 4 comments 0 points Most recent by User_2025-01-28-05-39-23-766 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…User_2025-01-28-05-39-23-766 80 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 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…User_2025-01-28-21-18-43-496 138 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
What happened to OTBI Web Query(iqy)Summary What happened to OTBI Web Query(iqy)Content In older releases if we edit analysis and go to advanced tab we used to have option to download Web Query (iqy) for t…Prasanna Reka-OC 43 views 0 comments 0 points Most recent by Prasanna Reka-OC Reporting and Analytics for ERP -
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 64 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 60 views 0 comments 0 points Most recent 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 137 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
showing project reference details in OTBIContent We are trying to union both Project Costing - Actual Costs Real Time and Payables Invoices - Transactions Real Time or Project Costing - Actual Costs Real Time a…Sam Solomun 133 views 9 comments 0 points Most recent by Sam Solomun Reporting and Analytics for ERP