Popular Tags
- OTBI 1,445
- Reporting 1,391
- FDI 1,109
- Analysis and Data Visualization 983
- BI Publisher 851
- Analysis 680
- Oracle Fusion Analytics 583
- Administration 555
- OAC 446
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 354
- Security 292
- HCM 265
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 192
- Report Output 184
- Fusion Data Intelligence 174
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
-
Remove HTML tags the data loaded through HSDL.Hello , We loaded the data for Performance Goal (for Description) in system through HSDL and noticed that the HTML tags like which we used in HSDL file are visible from… -
How can I ensure my BIP report for line managers only returns results of their reporting line?I've built a BIP report and made it available to managers as a link (static URL page entry in My Team) and it works perfectly except it returns results for all employees…
-
Cannot open or schedule a custom BIP report in Oracle Fusion AnalyticsReceive error message after 10 minutes when opening the report or scheduling it, even the parameter is not visible. What is the main reason for this error and how can th…
-
FDI subject - salary basisI am unable to see below KPIs which has been added in HCM – Workforce Rewards – Salary Basis subject area which is referenced in the below blog. Unadjusted Pay Gap Count…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
How to Identify relative column on OTBI side for an FDI ColumnTrying to test latest release updates on Oracle HCM . HCM - Talent Acquisition subject area has these enhancements: New Metrics - New metrics related to openings filled,…
-
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…
-
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…
-
Create infolets with the use of FDI reportsHello, We have been implementing the new reporting tool of FDI and we have been asked if it is possible to create Infolets for the FDI reports in the home page of Oracle…
-
OAC/FDI preview feature "Salary Basis Snapshots" troublewe are on the most recent release in OAC/FDI (25.R3.P1) and enabled the feature "Salary Basis Snapshots". I believe the feature was turned on correctly as I now see the …
-
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…
-
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…