Category 81
Discussion List
-
How can we report on how many Share Colleague Data Access are active?Summary: We are currently trying to establish how many colleague's have an active Share Colleague Data Access of 1 or more and we want to be able to identify how many co…Natalie L Woodland 42 views 3 comments 0 points Most recent by Natalie L Woodland Reporting and Analytics for HCM -
Development Goals Count Scoreboard Employee WiseSummary: Need to display the count of the development goals in various status to the logged in employee in form of a dashboard Content (required): We have a requirement …Ronit Swain 41 views 3 comments 0 points Most recent by Jaydeep More Reporting and Analytics for HCM -
How can I exctract Work Terms Number field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Work Term Number field to update employee managers by HDL. Is it possible to find this fiel…Valerio Curzi 428 views 14 comments 1 point Most recent by Girish Singh-Oracle Reporting and Analytics for HCM -
Add the Not Passed to the Overdue count - Learning OTBISummary: Content (required): Hi there, we have a Top Overdue Count report for Learning. It uses the metric Overdue count. We use a simple filter based on that metric (se…Bobby Jourdan 11 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Prior Job in Promotion ReportSummary: Add prior job to OTBI report. Content (required): I have a promotion OBIT report that works great. I have a request to add in the employee's prior job. How can …Greg Rank 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sample OTBI Dashboards/Reports - RecruitingSummary: Content (required): Are there any recent shared sample packs of dashboards or reports related to ORC Recruiting? Version (include the version you are using, if …Toni Olivier 145 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hi there, I am unable to run a single report for a complete details of an employeeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):_Sanjay_ 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What is the Table that stores Oraganization EFF details.Summary: What is the Table that stores Oraganization EFF details. Content (required): What is the Table that stores Oraganization EFF details. Version (include the versi…User_2025-02-12-17-19-33-738 12 views 2 comments 0 points Most recent by User_2025-02-12-17-19-33-738 Reporting and Analytics for HCM -
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…
-
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…ZenG 28 views 1 comment 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
when we using full name column, we are missing the middle name of employee any another column ?Summary: Hi Team, when we using full name column, we are missing the middle name of employee but when we try to using first name , middle name, last name but it is takin…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
Where is the rate field for hours worked?Summary: Content (required): I have a report that uses the subject area Payroll - Payroll Balances Real Time, but it does not have a pay rate field. Below is an example …
-
candidate profile hdl error?Summary: get a solution for hdl candidate profile data? Content (required): Hi all, while loading candidate profile hdl getting error as "File line couldn't be saved to …
-
BIP Bursting - getting duplicate outputsSummary: I have BIP bursting working and delivering an e-mail to my "Split By" value (managers email) and "Delivery By" value (Person Number) successfully. However, it i…Scott Conaway 108 views 0 comments 0 points Started by Scott Conaway Reporting and Analytics for HCM
-
BI Dashboard filter causing score tiles to not showSummary: We have a dashboard built to summarize the scores of a questionnaire. When we filter, even though there is data, some of the tiles will randomly not show up. If…
-
Hiding Output TAB in Schedule Page of ReportSummary: Hiding Output TAB in Schedule Page of Report Content (required): Can we hide via Personalization or Role Duties and Privileges restriction hide the Output TAB i…C.R.Balaji 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to schedule a BI Publisher report to run on interval of 15 daysSummary: Need to schedule a BI Publisher report to run on interval of 15 days. Content (required): Version (include the version you are using, if applicable): Code Snipp…Abhimanyu Kumar27 22 views 2 comments 0 points Most recent by Abhimanyu Kumar27 Reporting and Analytics for HCM
-
Include/Exclude column based on the ParameterSummary: We have requirement to Include/Exclude the column based on the parameter Content (required): We have a requirement to hide a column in the report output based o…Vasanthakumar Ravi 116 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
Population Counts - Year over YearSummary: I am looking to create an analysis, which will be connected to a dashboard, to report population counts year over year. I have included an example below: August…User_2025-03-07-05-50-05-831 14 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Only issue with one person number of the querySummary: HI Team, for below working fine but coming to one person number not getting the data. below error coming error:Data_das Could u please assist on this.@Mandeep G…AjayKumar Maddipati 52 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Need to get the latest Salary fromSummary: I need to get the latest salary for all employees who have left. Content (required): I am using the Compensation - Salary History Details Real Time subject area…GJ79 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table Prompts Repeating ValuesSummary: Pivot table and data table are linked with a channel so the table will update depending on where in the pivot table the user clicks. However the table prompts a…
-
How to fetch the contract end date of a future contract extension using OTBI?Summary: Hi All, We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract…User_2025-02-11-06-38-03-841 282 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get multiple value from table in Array format in Oracle BISummary: How can get Multiple value for the same data in Array format in one single row Content (required): Get the value in Array format in oracle need sql query Versio…
-
How to change date format in 30-06-2022 to 30-June-2022Summary: Hi Team, we have developed date as of now 30-06-2022 but business wants this format 30-June-2022. to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022 May I know t…AjayKumar Maddipati 22 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Scheduling Dashboard with BIP ReportSummary: Content (required): I am trying to schedule a dashboard which contains a tab with a BIP Report. When I schedule or export the dashboard, all other tabs (that co…Riti Malhotra 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to fetch the data for Calculation card in HCM Payroll Employee Deduction BI reportSummary: Hi all I am not able to get these data from the backend for Element Name, Value, Effective Start date inside the Calculation Card : Benefit and Pension in HCM. …Deepak Bhatt 114 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How do I create an analysis that pulls most of the fields on the Element summary screen?Summary: When creating an analysis, the analysis either drops records or stops returning any records after adding certain fields that may not contain any data. I am curr…BeachDreamer 31 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to create a report for worker and theirs Individual CompensationSummary: Im trying to create a report to follow individual compensations for workers, but using the subject area i couldnt create any report, when combine the worker fou…Lucas B Maciel 12 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM