Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 844
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Fusion HCM Analytics
Ask questions about Oracle Fusion HCM Analytics, the prebuilt cloud native solution for Oracle Cloud HCM. Get answers from human resource professionals on employee attrition, retention, talent acquisition and management, compensation, workforce diversity, and more.
Discussion List
-
Is there a way to get payroll_id/payroll_name associated with an employee in FAW?I can see the setup table: dw_pay_payroll_d in FAW having payroll_id, payroll_name. But, how do we link it with person table: dw_person_d or assignment table: dw_wrkfrc_…
-
How to get UNION_ID for an employee in FAW? It is not present in assignment table:dw_wrkfrc_asg_f.Is there a way to bring UNION_ID for an employee in FAW? Not able to find a suitable PVO to bring the value through data augmentation. Please suggest.
-
Average Age Band By YOYHi All, We have a requirement to develop the average age band in percentage by YOY and we are using below formula and it not working as expected, Please help me if you h…
-
max aggregate returning multiple rowsHello I work in a Windows environment and I am using Oracle HCM Analysis tool to alter a benefits report to only show the latest benefit by date. I am using the 'Benefit…
-
FAW: Can we perform Period Rolling on Ago functions (nested query)Hi, We have a requirement to find Retention rate in HCM Analytics for a client. we have build up the logic for the same but for creating the necessary calculation we req…
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' tableWhat is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data in BICC
-
How to remove setting icon from BI reportWe've created a BI reports and granted all users access to run them. However, an issue arises when users run the reports: there's a settings icon on the right side that …
-
What are the backend tables used in Transaction design studio-View configuration report?Hi, We are trying to get a list of all customizations (HCM Experience Design Studio and Page Composer) from an environment through a BIP report, I know there's a way to …
-
HCM - Talent ProfileHi all, I am working on the Talent Profile, attempting to compile historical performance information for employees. However, I am unable to locate any Time Dimensions th…
-
How to Assign Performance Document to Previous Inactive ManagerI have requirement to assign performance document which are 'In Progress' to previous inactive manager. Can someone help me with any Data Load or Process available in or…
-
In fusion analytics warehouse can we get a report which gives details of all custom reports createdIn fusion analytics warehouse can we get a report which gives details of all custom reports created including report fields, filters etc
-
How do we extend the Key People Group Flexfield in Fusion Analytics?Which entity is available to extend the People group flexfield attributes in order to utilize the key people group flexfield values from workforce assignment subject are…
-
NEW! Oracle Analytics Summit London 2024!NEW! Oracle Analytics Summit London 2024! 🇬🇧 Join the Oracle Analytics product leadership team and the Oracle Analytics Leaders on March 13 for a full day of conversatio…
-
Goal Plan assignmentHi all, We need to create a DV for tracking the performance goals status, per review period and per business unit. It should display how many distinct employees have cre…
-
in FAW implementation videos and documentation FAW ADW Dataguard is not set up.Only ADW backups are taken daily. In that case how is FAW DR implemented ? As its a SaaS service does Oracel automatically restore FAW in a secondary region ? https://vi…
-
How to make read only DFF that has value set ?I have a DFF on a request screen that i want to make it read only but it has value set so when i make it read only the data doesn't show
-
Candidate Source TrackingHCM does not appear to have full UTM functionality available. UTM Medium & UTM Source are the only paramaters that seem to be available in our environment. What options …
-
Facing issue for using the SUBSTR function with negative number in eText TemplateWe have requirement to print the last 4 digits from summed value in eText template. We have used the below code to print the last 4 digits but its not working. please le…
-
Workforce Profiles - Person Profile Real TimeHi everyone, I need some assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person's profi…
-
Logic to find the Next Approver Name for the resignation processWe have a requirement to build a resignation report, in that we need fetch the Current approver and Next approver. We are able to get the Current approver from the table…