OTBI
Discussion List
-
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 8 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 39 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 32 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 38 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 31 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 37 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 60 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 60 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 119 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 47 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 46 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…
-
Employees with Grade ChangesSummary A report that shows grade changes in last 12 monthsContent Hi How can I set up a report to identify a person who has changed its Grade on the last 12 months? Doe…User_2025-02-05-22-44-35-842 70 views 2 comments 0 points Most recent by User_2025-03-07-20-55-01-859 Reporting and Analytics for HCM
-
Tax Year to Date / Statement of EarningsSummary How can I report on Tax YtD values from SoEContent We have a requirement to build a report in PeopleCloud which is currently an SQR in PeopleSoft. The existing r…User_2025-02-08-05-56-00-229 50 views 4 comments 1 point Most recent by Jon Taylor Reporting and Analytics for HCM
-
Date Prompts with Italian InterfaceSummary Invalid Date format when using a date prompt in ItalianContent Hello! I've recently encountered a new problem and I'm hopeful that someone out there has figured …Rob F 28 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for HCM
-
Pivot Table helpSummary Trying to split two values in pivot tableContent Hi, I am trying to get my pivot table to show the sum of all National & International contracts by Business Unit…User_2025-02-05-22-44-35-842 38 views 3 comments 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Editing Delivered DashboardSummary Trying to edit the delivered Line Manger Dashboard but received error on saveContent Hi, I am trying to edit the delivered Line Manager Dashboard, I want to upda… -
Prompted Bar Graphs for custom fields with case statementsSummary Prompted Bar Graphs for custom fields with case statementsContent We have a bar graph with a couple of custom fields derived using case statements. The fields on…User_2025-02-10-08-27-16-805 25 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report to fetch Tax calculation cards at set up levelSummary Report to fetch Tax calculation cards at set up levelContent Hello Team, Is there any OTBI/BIP report to fetch tax calculation cards at the set up level? I want …Harish Kumar Kovi 76 views 4 comments 0 points Most recent by Thomas Cottrell-Duncan Reporting and Analytics for HCM
-
Data level security on OTBI reportSummary Can we apply data level security on OTBI reportContent Hello Everyone, Can we able to apply a data level security on OTBI report such as applying logic on data e…VarunG 59 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report running for everSummary Existing BIP report is running for ever with recent upgradeContent Hello Everyone, We have report which was running fine without any issues for 5 hours now with …
-
Calculation Help ReportContent Name Weight Numeric Rating * Weight / 100 Competencies 15. 0.45 17. 0.51 Goals 20. 0.6 25. 0.75 30. 0.9 I have a report that spits out like this. The last column…Mike Borghoff 38 views 4 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Ability to enable Percentage of total on a line graphSummary Ability to enable Percentage of total on a line graphContent I am building a line graph and would like to set the data markers as a % of the total value instead …User_2025-02-10-08-27-16-805 15 views 9 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
can we use UDT tables in OTBISummary can we use UDT tables in OTBIContent can we use UDT tables in OTBI?User_MC37Q 178 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Archive UnarchiveSummary Archive Unarchive tasks for OTBI reportsContent With reference to OTBI reports now I can't see the task for Archive & Unarchive as before. can you inform me wher…User_2025-02-10-22-13-59-726 41 views 4 comments 0 points Most recent by User_2025-02-10-22-13-59-726 Reporting and Analytics for HCM