OTBI
Discussion List
-
Line Manager Dashboard PromptsSummary AsOfDate not working in my customised versionContent Hi, I have been trying to copy and then customise the Line Manager Dashboard to suit our organisation which …User_2025-02-05-22-44-35-842 69 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to Use Result of One Column in Formula for Next ColumnContent Hello there Reporting and Analytics experts. I am hoping one of you can help me out with an analysis I am working on. I am trying to get our FTE reports up and g… -
Error while using FILTER/DESCRIPTOR_IDOF in formula with multiple subject areasSummary The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID columnContent I'm trying to summarize Headcount based on Gender, Ethnicity and … -
Report to show latest demographic infoSummary Report to show latest demographic infoContent Trying to report on latest demographic info for a population but duplicate rows are being returned when I only want…Emily Robinson 53 views 2 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
Creating a line graph of headcounts across the past 6 months (for each country)Content Hi, How would one create a line graph of historical headcounts for each country? The date should be on the x-axis and the FTE headcounts on the y-axis, with the …User_6PCL3 23 views 3 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Generating FTE Headcounts for the past 12 months based on each region/business unit - OTBISummary Generating FTE Headcounts for the past 12 months based on each region/business unitContent Hi, How would one generate a time-series plot of the FTE headcounts ac…User_6PCL3 23 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI: is there a restriction in OTBI reports that it can return onlySummary OTBI: is there a restriction in OTBI reports that it can return only Content Hi, Had a question: is there a restriction in OTBI reports that it can return only -
OTBI report to get former and current job title, job code, department, business area for internal hiSummary I would like to create a report that can be run by work relationship start date which will provide information on an internal transfer candidate who moves from o…Amrita Basu 681 views 1 comment 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Error in OTBI Analysis Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PContent Hi All, I have a OTBI analysis with Graph. When I move my cursor over the graph I see Hand means it's clickable. When i click I get following error, Can someone …User_2025-02-07-19-03-14-525 198 views 4 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…User_2025-02-07-19-03-14-525 58 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t…Murugesu.V 40 views 3 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 36 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi…
-
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…User_2025-02-07-19-03-14-525 9 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 40 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Getting Error When Click "Drill to Transaction Detail"Content Hi Experts, When I'm clicking on link "Drill to Transaction Detail" from HeadCount Analysis ( I copied it in my custom Dashbaord) I'm getting following error. Er…User_2025-02-07-19-03-14-525 34 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Is it possible to write a validation query against excel/csv data source in data model?Content I have created 2 data sets using excel and csv as data source. I want to write basic query to validate data from these files. Is it possible to validate excel da…Samir Patro 42 views 4 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of …Rob F 38 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Duplicate Manager Data Integrity ReportSummary Duplicate Manager Data Integrity Report not workingContent Hi All, We have a data integrity report that we would like some help troubleshooting. This report is i…User_2025-02-07-16-42-37-187 32 views 4 comments 0 points Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM
-
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…User_2025-02-05-20-24-10-848 44 views 1 comment 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the …Shelly Feyerherm 61 views 4 comments 1 point Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Combining Fields into one Column / Field in OTBIContent Hi, I'm looking to see if its possible to combine multiple fields / columns into one field / column? I currently have a report that brings back 5 fields / column…
-
Locate First Names that begin with Blank characterSummary Locate First Names that begin with Blank characterContent Can anyone please advise on the proper Function or CASE statement to use in an OTBI Analysis to locate … -
Vacant Position report with Last incumbentSummary Need a vacant position report with last incumbent detailsContent Hi Team I need a vacant position report with last incumbent details in OTBI, can you please let …User_2025-03-07-20-55-01-859 62 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Having problem with Manager Field in OTBISummary Having improper value of Managers in OTBIContent In our system we have two different manager type i.e. functional manager and one is matrix manager. Functional M…Soumya Goswami-Oracle 121 views 7 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM -
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who …SunnyJaiswal 49 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Annual Employee Salary DetailsSummary Annual Employees Salary details ReportContent Is there any OTBI & Standard seeded report available for employee annual salary details.Bilalemail 48 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP…