OTBI
Discussion List
-
How to get dynamic column names in the OTBI analysisSummary How to get dynamic column names in the OTBI analysisContent Hi, We have a requirement were we need to display the column names(labels) dynamically. THis report i…User_MC37Q 150 views 3 comments 3 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Is it possible to enable a dashboard as an InfoletSummary Is it possible to enable a dashboard as an InfoletContent We have a requirement to enable dashboard as a infolet. Tried to add dashboard as an infolet but not ge…User_XT9HW 142 views 2 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Dashboards - ObseleteSummary Dashboard - ObseleteContent Hi, Just want to know the Dashboards going to be obsolete in coming versions and Infolets will take precedence. Regards/Prasanth Vers…DineshApps 45 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Infolets - No ResultsSummary Infolets - No Results MessageContent Hi, We have created an infolet using OTBI report. Whenever there is no data for the report criteria system showing following…DineshApps 53 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Can this report be date drivenContent Hi I have created a report which shows the hierachy but what the team really needs is for it to be date driven so we can see the reporting lines for example a co…User_2025-02-06-11-18-47-896 30 views 3 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM -
CASE statement with IFSummary Need help with a CASE statement where it displays element input value if they have the element, else shows nullContent Hello, We have element set up like below t…User_2025-02-04-15-06-22-759 61 views 6 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Reporting on Rejected DORSummary Requirement to report on rejected DORContent Some of the DORs in our system pass through the Approval cycle. I have checked "Workforce Management - Documents of …User_2025-02-05-23-02-10-916 43 views 6 comments 1 point Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
Customization in Seeded Line Manager Dashboard for Absence pageContent Hi Experts, In the Seeded Line Manager Dashboard, the Absence page has an Absence for Today and Tomorrow analysis which displays absentees for Today and Tomorrow…Jaswant Prajapati 37 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report not showing own itemsSummary An report from timecards does not show own itemsContent We use time and labour to claim overtime as well as to record our flexi. With all our reports in OTBI, th…Dawn Cawston - CPS 50 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Split by genderContent Hi is there a way to split facts within subject areas by gender. i have tried using the filter but it returns all employees and i would like to create an attriti…User_2025-02-06-11-18-47-896 41 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
NI Category Letter in OTBISummary NI Category Letter in OTBIContent I am looking for NI Category Letter in the OTBI subject area 'Payroll - Calculation Card Real Time'. Could anyone please confir…Jay A 43 views 3 comments 0 points Most recent by Henry Winsor-Oracle Reporting and Analytics for HCM -
how we can use gif in flash template through bi publisherSummary how we can use gif in flash template through bi publisherContent how we can use gif in flash template through bi publisherSidhartha Wadhwa 37 views 1 comment 1 point Most recent by Karina Ogata Reporting and Analytics for HCM -
Report to view employees currently on redeploymentSummary How to exclude employees from a redeployment report if they have been successfully redeployed into a new roleContent I need a report that displays all employees …User_2025-02-10-22-27-57-221 28 views 2 comments 0 points Most recent by User_2025-02-10-22-27-57-221 Reporting and Analytics for HCM
-
Dashboard promptsSummary Creating a dashboard prompt using a formula based columnContent Hi We are using below formula to show the actual "Start date" of employees in the reports. IFNULL…Ridma Karunanathan 47 views 2 comments 1 point Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
OTBI: How to format Enrollment Coverage start date in the OTBI prompt to the date format to DD-MON-YContent In the prompt Enrollment Coverage start date how to change the date format to DD-MON-YYYY.? Currently the format of the date prompt is DD-MM-YYYY.User_2025-02-08-08-08-53-292 39 views 2 comments 0 points Most recent by User_2025-02-08-08-08-53-292 Reporting and Analytics for HCM
-
OTBI reports sent via Email are causing performance issuesSummary OTBIContent Hi. I have noticed that most of the OTBI reports I schedule using the agent and send via Email are causing lagging issues when the user tries to open… -
Query on the subject area: Human Capital Management – Transaction Administration Real TimeSummary Query on the subject area: Human Capital Management – Transaction Administration Real TimeContent Hi, Am I correct to say that the subject area 'Human Capital Ma…Karen Waddell 88 views 2 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Preferred Browser for OracleSummary I would like to know what is the preferred browser to use for Oracle applications. Can you provide documentations?User_2025-02-06-07-21-22-662 39 views 2 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM
-
Day Difference excluding weekends in OTBISummary Day Difference excluding weekends in OTBI From Workforce Management - Absence Real TimeContent Hi All, I need to calulate the difference between two dates - Abse…Dharmendra Jha 45 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba…User_2025-02-04-08-51-08-912 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI: How do I use a non fact column in the Column Filter.Summary OTBI: How do I use a non fact column in the Column Filter.Content Hi, I have a requirement where i need to use a non-fact column which is Standard Working Hours …User_MC37Q 56 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Based Dashboard OutputSummary Multiple Employees in different Pages in Dashboard OutputContent Hi All I created a Dashboard for Talent Profile using 10 analysis (Each analysis will bring its …Jagdish Varadraj 58 views 8 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Need to be able to identify all BIP Reports and Analyses that use particular field as filterSummary Need to be able to identify all BIP Reports and Analyses that use particular field as filterContent Does anyone know if there is an Oracle program that will iden…Rich R 52 views 3 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
How to hide data model and edit access for BI ReportsContent Hi Export, We have a requirement to give only view access for BI Report and nothing other than. So we are planning to hide the data model so that a user can not …MohammadAfghanul Khair 295 views 4 comments 0 points Most recent by MohammadAfghanul Khair Reporting and Analytics for HCM -
OTBI: how to achieve UNION ALL operation in OTBISummary OTBI: how to achieve UNION ALL operation in OTBIContent Hi, We need to replicate BIP's UNION ALL operation in OTBI Is it possible? Regards RashmiUser_MC37Q 106 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Trend Headcount by Assignment StatusSummary We require a report that displays headcount for each month for the last year, but it should only count those employees with a specific assignment status.Content …Derrick Campion 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
R13 20A - How to extract BPM approval Configurations task details via SQLSummary Need to extract BPM approval configurationsContent We have a need to extract all the BPM approval configuration task details via SQL. All things BPM related (the…Suganthi Srinivasan 109 views 4 comments 5 points Most recent by Venkatraman G Reporting and Analytics for HCM
-
New Role only seeing their information on any report ran in Reports & AnalyticsSummary PAYADMIN_READONLY_DATA_DATAContent Created a new role in HCM and it only when reports are ran it only shows their information, unless it is a line manager, then …Gabe K 56 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 98 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 83 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM