Reporting and Analytics for HCM
Discussion List
-
How to transpose Rows to Column in OTBI Compensation Detail ReportSummary: you can use a pivot table and have salary basis as column and value in the metric section, you should apply aggregation rule like min/max on the metric values. … -
Error While opening OTBI ReportSummary: Error While opening OTBI Report Content (required): Hi Everyone, While opening the OTBI report, it throws me following error. As per the document Doc ID 2083725…
-
Report on total number of direct and indirect reports by managerSummary How can I sum distinct direct and indirect reports by manager?Content Hi - I'm having a hard time figuring out how to sum direct and indirect report total counts…
-
How do I create a learning category headcount report?Summary: I am having to create new reports for the new Learning Subject Area (Workforce Learning - Learning Records Real Time) due to the Learning Management Subject Are…
-
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and… -
Unable to hide prior incumbent details in position FTE reportSummary: Unable to hide prior incumbent details in position FTE report Content (required): Unable to hide prior incumbent details in position FTE report. Following scree… -
Payroll - Element Entries Real Time - zero results when adding person numberSummary Zero results when from including different fields from same subject areaContent I hope this is one of those obvious "doh" moments. Subject Area: Payroll - Elemen… -
Different Learning Metrics - Existing dashboard resource?Summary: Content (required): Hi there at the end of the year we need a number of learning reports. I have a few organised but I was wondering if there is any resource re… -
BI Publisher RTF Template - Repeating GroupSummary: Team, we have a requirement to print the timecard details For each employee the header should be same and the Last Row Should Be Repeated. It would be really he…
-
MonthName function not WorkingSummary MonthName function not WorkingContent Hi All , I am trying to get the Month Name (Jan / Feb / Mar) from a Date entry - Eg -I'm using the following function - Mon… -
How to display MTD, QTD in payroll register report for latest processSummary: How to display MTD, QTD in payroll register report for latest process Content (required): As of now payroll register report displaying only Run and YTD values. …
-
What is the best way to mass assign a Dashboard to a large groupSummary: Only a small handful of employees use the reporting system. I am building several Dashboards for various teams, and was wondering the best way to get those folk…
-
How to Capture a Work at Home Flag Change in a report?Summary: Content (required): Hello Experts, We need to report on instances when employee's Work at Home flag changes from 'no' to 'yes' and from 'yes' to 'no'. Does anyo… -
Calculation Cards TRUSummary: I would need to get the value of TRU in Calculation Card. I am unable to find the table name. If anyone could help on this, would be really great. Screenshot At…
-
Exception: The job attached to employee must have an EEO job category.Summary: Hi All, I am getting this in the EEO1 exception report . Any idea why its throwing this error? I have made sure that all the jobs that are used have the EEO cat… -
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…
-
Birthday reportSummary Birthday report worked exampleContent Hi there I have a requirement to create a birthday report, that can run two weeks before the employee birthday month. This … -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…
-
Can a column name be modified but also translated?Some standard colom names are not suitable for our organization but if I change them the name will be fixed. For example if I change the language settings the name of th…
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Attrition and Turnover ReportsSummary: Need to develop an analysis for Attrition and Turnover Content (required): We have a below requirement for Attrition and Turnover Reports, can anyone share the … -
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…
-
Adding a Page / Tab to Front End AnalyticsHello, Apologies if this is the wrong place to ask but I'm building several infolets to be used and was wondering if anyone knew if it was possible at all to add an extr…
-
Results to be displayed horizontally instead of vertically in reportsSummary: We have a requirement where the results displayed in reports are vertical but we need to display that column horizontally. Suppose say for example this the resu…
-
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Job Profile AuditsHi , I have a requirement to pull the changes made to Job profiles/Job details. Is there any way if it can be retrieved from Audit report, If yes, how can i achieve it. …
-
How can I make sure that when the Dashboard is first opened, no data comes in without selecting a paHi, I designed a dashboard for users. It has a detailed dashboard with assignment information of individuals and multiple parameters. What I want is for the parameter sc…
-
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check…
-
Unable to add Salary Basis Column in my existing Compensation detail ReportSummary: I need to add Salary Basis Column which I am unable to do so in the exisiting report. Subject area I have use is Payroll - Element Entries Real Time Content (re…
-
Guys, Do you know the table name that stores the where clause on Manage Value Sets page? Thanks VenSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):