OTBI
Discussion List
-
Future Dated RecordsSummary Future dated records/Inserted rowsContent I need to build a daily report for when managers/HR has entered a change when there are future dated records that need …User_2025-01-28-04-58-46-119 96 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Performance Management Comments in OTBISummary Performance Management: Competency comments and Overall comments in OTBIContent Hello, I have realized a custom report to extract Performance Management competen…Giuseppe 1234 125 views 3 comments 1 point Most recent by User_2025-01-28-07-43-08-025 Reporting and Analytics for HCM -
Need inputs to fetch the Element Additional DetailsContent Hi All, While creating Element we need to provide required information in the Element additional details. Please suggest in which table (SQL) or Subject areas ho…
-
Turnover Formula AssistanceSummary Building a turnover % by termination typeContent Using a CASE formula I have identified and split out terminations by our company's preferred type, desired and u…User_2025-01-28-08-47-04-905 69 views 3 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Can I use Dashboard Prompt in the individual Column Formula in my analysis?Summary Can I use Dashboard Prompt in the individual Column Formula in my analysis?Content Hi, I have a requirement where I need to use the dashboard prompt(Presentation…User_MC37Q 40 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Creating OTBI report with employee termination detailsContent I need to create a OTBI report to get employee termination details. I used Workforce Management - Work Relationship Real Time subject area but after release 13 c…User_2025-01-28-21-18-43-496 527 views 10 comments 1 point Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Salary Currency field causing error on reports in R13Summary Compensation Reports error out. Determined caused to be related to Salary Currency field.Content I have two Compensation Reports that error out. I determined the…User_2025-01-28-20-43-56-568 39 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(prSummary Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(presentation variable) before using it to compare in Analysis.C…User_MC37Q 90 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptSummary OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptContent Hi, I have a scenario where I need to add 2 dates on to the d…
-
OTBI Analysis, Action Links in OTBISummary Not able to create link through Action Links in OTBI AnalysisContent Hi I am trying to create an analysis in which I am using two subject areas "Workforce Manage…User_MC37Q 86 views 1 comment 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
OBTI Analysis Comparing DatesSummary I am not able to compare dates in analysisContent "Hi, I am trying to perform a query which i think should be easy but i'm suffering from just looking at it for …User_MC37Q 55 views 19 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Setting the As Of DAte in Compensation - Salary Details Real TimeSummary Looking for a list of Subject Areas where a Prompt may NOT be used to set the effective dateContent Hello, I have used the instructions that are attached to effe…Aaron Hager Associated Bank 59 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Delivering OTBI Analysis on a specific day to a specific person's dashboardSummary Delivering OTBI Analysis on a specific day to a specific person's dashboardContent Hi I want to fetch the details of the employees which have the end date of the…User_MC37Q 45 views 1 comment 1 point Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
Display Bin even with zero resultsSummary Is there a way to still include a Bin in the analysis output with zero results?Content Hello, I have an analysis where I am using Bins to count employees by age …Susan Anderson 42 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Summary OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Content Hi, I am getting error "A Drive Table join exceeded the…User_MC37Q 37 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI Analysis: Can I do a Analysis A - Analysis B (Both analysis have headcounts with different filtSummary OTBI Analysis: Can I do a Analysis A - Analysis B (Both analysis have headcounts with different filters)Content HI, OTBI Analysis: Can I do a Analysis A - Analys…User_MC37Q 107 views 5 comments 0 points Most recent by Mark Johnson Reporting and Analytics for HCM
-
Release 13 - 50000 cell limit in BI Answers??Summary Our reports no longer can export the data they need!Content Hi all, Following our upgrade of release 13 there seems to be a limit on 50000 cells exported, we hav…Kevin M Storrie 181 views 33 comments 2 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Date effective OTBI report errorSummary Including Current date as default for presentation variable with PARAM_EFFECTIVE_DATEContent Hi I am trying to create an OTBI report which uses 'Effective_Date' …Mohit Gupta-45440 119 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Possible to embed link to run a report, inside a Dashboard pageSummary Embed link to run a report, inside a Dashboard pageContent We have a request to embed a link in a Manger's Dashboard that will allow them to run a pre-built repo… -
OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format)Summary OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format) should come up.Content Hi, I have a OTBI analysis where I ha…User_MC37Q 56 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Gauge/Dial Chart AssistanceSummary Creating a gauge chart within OTBI with custom thresholdContent I'm looking to build a simple gauge capturing capturing the average number of days it takes our H…User_2025-01-28-08-47-04-905 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Enabling and adding custom reports to the My Team > Goals reporting paneContent I want to enable goal reports for managers and allow the managers to access specific links to analysis and/or dashboards through the reporting pane at "My Team >…Duane Gay-Oracle 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Exceeded Maximum Results Error when adding a promptSummary Any way around this?Content I'm looking to build out a trend report, using the WF Trend Subject area, which will allow the user to select a manager via a prompt …User_2025-01-28-08-47-04-905 56 views 5 comments 0 points Most recent by Timothy Orrange Reporting and Analytics for HCM
-
OTBI: YTD Values in Payroll Balances Subject AreaSummary OTBI: YTD Values in Payroll Balances Subject AreaContent Hi, Is there a way we can display the YTD Balance values from the "Payroll Balances Real Time" Subject A…User_2025-01-22-19-45-49-284 186 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM
-
After upgrade to Rel 13, compensation OTBI report is running into an error.Summary After upgrade to Rel 13, compensation OTBI report is running into an error. - Datatype: 17 is not supportedContent After upgrade to Rel 13, compensation OTBI rep…User_2025-01-25-04-02-13-126 35 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to receive assignmentId from Compensation Page & pull out Legal Employer based on itSummary How to receive assignmentId from Compensation Page & pull out Legal Employer based on itContent Hi guys, we are facing an issue related to compensation page. In …User_2025-01-28-21-18-09-074 40 views 14 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Areas of Responsibility assign to workers- how can we pull data in reports?Content Hello, If someone can share his knowledge regarding how can we pull the data - responsibilities assigned to workers? we want to track the employees's areas of re…User_2025-01-22-19-54-47-882 73 views 4 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Bar Chart SortingSummary Is there a way to sort the horizontal color axis by the measure?Content Is there a trick to getting a chart to sort when adding color to the horizontal axis? I h…User_2025-01-28-08-47-04-905 26 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Filtering Based on Phone TypeSummary Need to show only results for work phone but also want to pull in those who do not have a value.Content I am trying to create a report which will pull various da…User_2025-01-24-00-39-43-470 60 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Drill down to transactional recordSummary OTBI Drill down to transactional recordContent Is there any way we could drill down from an OTBI analysis to the transactional record to take some corrective act…User_2025-01-22-19-27-16-253 247 views 3 comments 0 points Most recent by User_2025-01-30-01-56-27-828 Reporting and Analytics for HCM