Popular Tags
- OTBI 1,407
- Reporting 1,365
- FDI 990
- Analysis and Data Visualization 954
- BI Publisher 821
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 550
- OBIEE 421
- Analytics 348
- OAC 339
- BI Publisher Data Models 335
- Security 273
- Answers 261
- Analyses 253
- Developers 240
- HCM 239
- BIP 233
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 146
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
-
Can you view the SQL behind an FAW visualization?I am quite new to FAW/ADW HCM and have been tasked with creating a new View. I have a few questions please: How can you view/copy the SQL behind an FAW visualization? 2.… -
How to write calculation: Rolling Headcount by Length of Service <=365 Days.I am trying to write a calculation to provide the Rolling Headcount at the end of the period for Team Members with Length of Service -
How to write calculation: Headcount filtered by Length of Service <= 365 DaysI am trying to write a calculation to provide the Headcount at the end of the period for Team Members with Length of Service
-
How does the HCM - Talent Profile Subject Area work?I'm trying to use the FAW subject area HCM - Talent Profile Subject area to create a dashboard on Talent Ratings to identify employees who do and do not have a rating. T… -
FAW Data Validation Source value is showing nullHI Team, I have enabled all the HCM pipeline in FAW but in data validation tab source value is showing null. Please suggest what could be the issue. I have verified the …
-
workbook filter is not working in OAC workbookHi Team, I have enabled the pipelines in FAW/FDI but when we tried to open a workbook then data is appearing but workbook filter is not showing any value. Please let me …
-
FDI Bar Visual not populating as expectedHi I have a workbook which is utilising Workforce Core and an imported dataset of Workplace Health & Safety data. From this I wrote a calculation for Average Cases per D…
-
HCM Security Assignments- Difference with FIN,SCMI noticed that the Security Assignment subject area only shows assignments for FIN and SCM Are HCM assignments handled differently? The current project includes HCM but … -
Getting No Data After Adding Parameters to My Data ModelMy data model was returning many rows of data prior to adding parameters. I added the parameters to the data set created via the Query Builder tool. Here is what I start…
-
Global Absence Type Duration - Fast FormulaHi, We have a requirement that the employees who are applying for leaves must have their leave durations visible in the multiples of 0.5 hours.(0.5, 1 , 1.5,.till 3). i.…
-
Absence Analysis Not Populating with DataWe are trying to create an absences dashboard and started with the prebuilt dashboard. However, the out of box dashboard is populating with 0's or no data found. Where c…
-
Turnover By Country and Enterprise PeriodHi Team, I am writing to address an issue regarding the turnover calculations for multiple countries within the enterprise period. Currently, when I query the turnover f…
-
Export FAW Object ListIs there a way to export the list of objects from the Content Management screen in the Console or is there a table in the database that has this information?
-
How to populate employee start date with current year?I have created a field which is extracting the day and month from an employee's start date and combining with the current year (see below). I am having trouble casting t…
-
For FAW/OAC HCM - Learning subject area how do I get the actual score and actual hours?I'm new to Oracle and FAW/OAC but not new to data or analytics. We're trying to adopt FAW and OAC. We have the area turned on and are getting data on the learning items …
-
Logic behind Workers with Active ProfilesHi, We are validating FAW reports against Fusion HCM and we need to know what exactly oracle is considering for active profile in FA. Please share the logic behind Worke…
-
FAW -- Invalid credential nameHi All, We are running the below sql query in OAC BI publisher and getting 'Invalid credential name'. Please share your input if you have faced similer issue. SQL Query …
-
FAW - BI- Invalid credential nameHi All, We are trying to run the below sql query in OAC BI Publisher using OAX_USER (data Source) getting 'Invalid credential name'. Please share your input if you have …
-
What is the issue of below logic in FAW?I'm using a simple logic in calculation, Please see the below.. C - NUMERATOR DIVERSE PROMOTIONS: cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basi…
-
In FAW dashboard after apply filter returned a general error has occurred.Please see the below error.. Error generating view. Error getting cursor in GenerateHead Error during query processing (SQLExecDirectW). State: HY000. Code: 10058. [NQOD…