Popular Tags
- OTBI 1,454
- Reporting 1,397
- FDI 1,142
- Analysis and Data Visualization 988
- BI Publisher 864
- Analysis 684
- Oracle Fusion Analytics 596
- Administration 556
- OAC 478
- OBIEE 434
- Analytics 409
- BI Publisher Data Models 359
- Security 296
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 217
- ERP Analytics Content 214
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 194
- Report Output 184
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
-
How do I validate the data across different FDI HCM subject Areas ?Visualizations/KPI's Workers with Absences Absence Days Absence Hours Absences Days by Type Absence Days by Legal Employer Absence Details Approved Absences Pending Appr… -
How to optimize dynamic fiscal year-end date calculation logic?I’m using the below expression to derive the enterprise’s fiscal year-end date dynamically based on the current date: TO_DATETIME( CONCAT( TRIM(TRAILING FROM CAST( CASE … -
Week Start day on OTBIHello experts, I created a simple Analysis from Time and Labor and i used the attribute Calendar Week Start Date, but i see that the week start day is Sunday, but for th…
-
Cross subject area Calculation columnsI'm building a learning dashboard using two subject areas: HCM Learning (for course completion) and HCM Workforce (for headcount). I'm struggling to calculate compliance…
-
Compensation Plan NotesIs it possible to report on the Compensation Plan Delivered Note Details?
-
Help With CalculationHello Everyone, I'm hoping you can help me figure out what I'm missing with a calculation I've been trying to build. The Need: We're trying to calculate the average numb…
-
Where to find employee contract dates?Hi, We're building KPI dashboards for HR admins and line managers and want to create overviews of new hires and ending contracts. We're unable to find important employee…
-
Add Filteration to "Existing Time Cards" to filter the Status of Time CardDear Team, We have received a proposal to add a Status filter to "Exisiting Time Card" (Me > Show More > Exisiting Time Cards). Because by using that Employee can filter…
-
Unable to delete the published main branch step in user extension from semantic model extension.We've encountered an issue with the session variable we created in the user extension and merged with the main branch. Unfortunately, it isn't working as expected, and w…
-
Is there a way to hide the drivers license information under person management > person > Document?Is there a way to hide the drivers license information under person management > person > Document? -
Oracle FDI - Resume/Profile Matching with Open RequisitionsFor resume screening based on current open requisitions for Oracle Recruiting Analytics in FDI, Do we have any available subject areas or charts in FDI? like profile or …
-
Oracle FDI – HCM securityHello Everyone, We have a requirement to restrict all access to C-Level executive data (e.g., CEO, CFO, CHRO, etc.) within Oracle Fusion HCM FDI Analytics. This restrict…
-
Locate Offer SalaryHi, For the context, we are using HCM 25A. I'm trying to query the offer salary amount in the job offer. I have checked IRC_OFFERS, and it doesn't contain the informatio…
-
BI Publisher Reports pulling blank and/or timeout errors with no modifications doneWondering if anyone has run in to similar situations. We have custom SQL/BI Publisher Reports that are encountering unexplained issues. For example reports that have bee…
-
How do I get the Public holidays details in FDIOne of my requirement to calculate working days. for that, I need to exclude week ends and public holidays. But, In FDI, I don't know, where to get that public holiday d…
-
Users can't see data or only their informationHi Experts, We are experiencing a very unique issue. Out users can't see data or only their information. We validated that there are no security assignments at user leve…
-
Facts columns are missing in local subject area HCM - Diversity AnalysisI am not able to see fact values under HCM - Diversity Analysis . when I try to add the annualized full time salary, then data is not visible Example 2 : after adding Fa…
-
How to create a date from a period field in OAC Dataflow (function DATE not available)Hello everyone, I’m currently working in the Dataflow menu of Oracle Analytics Cloud (OAC). I’m trying to transform a period field that I derived from dates, in order to…
-
Using data Validation feature, when there is a mismatch of counts how to get the OTBI queryNewly configured Data validation feature and we are successfully able to get Detailed validation and scheduled validations. For some of the metrics when we were doing De…
-
Query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groupsCan someone please help with a Oracle Fusion SQL query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups. I found the attached as a star…