OTBI
Discussion List
-
Report no longer workingSummary This report last worked before the April upgrade to 20BContent Hi, This report (see attached XML) no longer works - can anyone check why? There are no filters or…User_2025-02-05-22-44-35-842 23 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Query Data Model securitySummary Example of query or config to allow data models be displayed to all employees without them seeing whole company data.Content Hello all When a more robust report …Pedro Teixeira 40 views 6 comments 1 point Most recent by Pedro Teixeira Reporting and Analytics for HCM -
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 141 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 141 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 42 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 48 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 25 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 57 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 37 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 32 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 45 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 36 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 35 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 31 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 23 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 42 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 29 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 75 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 31 views 2 comments 1 point Most recent by Harish Vummidi 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 41 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 29 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 51 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 53 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 49 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 266 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 85 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 42 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 96 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 50 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM