OTBI
Discussion List
-
Need to report on Document Record attachmentsContent can we report on Document Records attachments count? Has anyone done it? Can anyone share a report or any with me? Thank you in advance! Version 21BGala Meyerovich 93 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
What is the Subject Area for Things to Finish (which are displayed on the user home page)?Summary: We have a requirement to show the count and Details of Assigned to Me under Things to Finish (which are displayed on the user home page) in an OTBI dashboard, s…Bhukya Vamsi Naik 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to set up time period for 12 week rolling percentageIn the "Workforce Management - Workforce Trend Real Time" subject area, in the "Workforce Trend" folder, there are the following fields: I need to use these in a calcula…rd17 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Line Manager Element Entries ReportingContent Hello everyone, We have a requirement that our line manager population needs to report on Element Entries (OTBI Report). When we run the report managers are able… -
Missing Work Phone TypeSummary: I'm looking at the subject area mapping, and playing with a few subject areas, but I cannot figure out how to build an analysis to see which employees are missi…
-
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an… -
Recruiting - recruiting real time subject area not giving expecting dataSummary: We built an analysis using Recruiting - recruiting real time subject area while extracting the data we will able to get only Open Phase information However we w… -
how can I get one seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …challa praveen 281 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Add timestamp so hours and minutes information capture while different phase in Job OfferSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How can we pull data in custom report for the field name "Action" on Termination page.Summary: I am trying to generate a custom report and want to know the column name for the field name “Actions” in the Termination page. We do get the data for the other …
-
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…
-
OTBI: Multi Tab Excel Downloadable OTBISummary OTBI: Multi Tab Excel Downloadable OTBIContent Hi All, We have a requirement of creating a single OTBI analysis with multiple layouts. Each Layout should have a … -
Data Lineage on the FAW HCM LearningSummary: Looking for Data Model / Data Lineage for FAW HCM Learning area. That will have the joins/ information relation between the entities. Can anyone help with that.…Moumita Samanta-Oracle 71 views 6 comments 3 points Most recent by Moumita Samanta-Oracle Reporting and Analytics for HCM -
OTBI:Individual Comp: Single row with Award Amount and Frequency in spite of data model constraints1- Below OTBI report has been built using "Compensation - Individual Compensation Real Time". It provides insights into the Awards awarded to an employee and the frequen…Abhishek Dixit-Oracle 61 views 2 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
OTBI created to fetch details of Absence accrual balance is not picking latest dataSummary: Content (required): We have created a custom otbi report which fetches the details of accrual balance. But we observed that the data is not getting updated on d…Veeru15 201 views 5 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
What is the process for adding group totals on an OTBI analysis?Summary: I want to add a group by employee number and to show its total trip distance for all start dates. Content (required): I have created an analysis based on Expens…
-
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
[OTBI] Delete HTML tag when exporting report to csv fileSummary: Delete HTML tag when exporting report to csv file Content (required): In order to delete the HTML tag in the OTBI report, the data format of the desired column …kayoung lee 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can I get mass results for Responses in Assessment?Summary: We assigned our organization (~7,200) a video to watch and asked everyone to answer a feedback question. All that was fine except now I am trying to report on a…Aaron Reynolds 31 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
How to Pull Future Dated InformationSummary: How to Pull Future Dated Information from HCM Content (required): I have created a report in OTBI using the Payroll - Calculation Cards Real Time Subject Area. …User_2025-03-07-06-11-23-192 39 views 4 comments 0 points Most recent by User_2025-03-07-06-11-23-192 Reporting and Analytics for HCM
-
Removal of first two rows in OTBI outputHi Team, When we schedule the OTBI report with excel output, Output contains first line with header and next line is blank. Our actual output starts from third line. How…
-
Reporting on Termination Counts - An analysisSummary This post provides an explanation on the calculation of termination counts in OTBI.Content The post contains a brief synopsis and also a sample analysis xml to c…Raghavendra Raghunath-Oracle 178 views 14 comments 9 points Most recent by Yves Blanc Reporting and Analytics for HCM -
Assignment Event/Workforce Trends - Counting a Termination on the Termination DateContent Hello Experts! I'm using Assignment Event Real time and have noticed that terminations are counted the day after their termination date. I suspect it's counting … -
How to count terminations as effective on termination date itself?Summary Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term actio…James Hoffmann 87 views 8 comments 1 point Most recent by Yves Blanc Reporting and Analytics for HCM
-
Are there any dashboard prompt experts or videos out there?Summary: Trying to create an EDI dashboard cross referencing with the new Learning Subject Area Content (required): I need to access data in three subject areas "Workfor… -
Can we access SOA MDS schema in fusion OBI reportsSummary: How to access SOA MDS schema in fusion OBI reports Content (required): We want to fetch business rules information in Cloud HCM through an OBI report. Is SOA MD…Hitachi ServiceDesk 21 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Page Composer -> How to pass pass parameters to embedded dashboard in Talent Profile pageSummary Bind Parameters to OTBI dashboard promptsContent Hello, Can anyone please help on this scenario? I have built a dashboard in OTBI, embedded that inside Talent Pr…SantoshKumarBhairi 129 views 3 comments 1 point Most recent by Raju Konidala Reporting and Analytics for HCM -
Procurement and Projects Folders are still available after doing Catalog Lockdown steps!Summary: Content (required): Procurement and Projects Folders are still available after doing Catalog Lockdown steps! Version (include the version you are using, if appl…Walid Hamdy 22 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Analysis with parameter not errors from Reports & Analytics but works from BI CatalogueSummary: We have a report which is available for managers but it errors from the Reports and Analytics page but works from the BI Catalogue. The report has a prompt (dat…Ruurd Reuver - Oracle 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM