Popular Tags
- OTBI 1,434
- Reporting 1,386
- FDI 1,089
- Analysis and Data Visualization 981
- BI Publisher 847
- Analysis 676
- Oracle Fusion Analytics 580
- Administration 555
- OBIEE 432
- OAC 432
- Analytics 395
- BI Publisher Data Models 350
- Security 292
- Answers 264
- HCM 258
- BIP 257
- Analyses 254
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 182
- Fusion Data Intelligence 162
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Fusion Data Intelligence
Ask questions about Oracle Fusion Data Intelligence platform, the next generation of Oracle Fusion Analytics Warehouse built for Oracle Fusion Cloud Applications. Get answers from experts on data pipelines, security, permissions, ready-to-use analytics, data models, prebuilt AI and machine learning (ML) models.
Discussion List
-
Headcount Turnover - How is it calculated?We are seeing conflicting information regarding how Headcount Turnover is calculated. The Subject Area page says this (no reference to "daily"). The excel spreadsheet on… -
Can an Oracle ERP Fusion account get access to selected gv$ viewsThere lacks transparency with how the database is performing and maintained. This requires read only access to selected gv$ views to assist in troubleshooting performanc… -
Creating fixed custom calculations to use in a conditional formatting statement.I'm looking to create a custom calculation that remains consistent across the entire CSV dataset. This calculation should be fixed regardless of the filters applied with…
-
Can we create custom GL metrics based on hierarchy in Fusion Analytics (possible using group featureNeed to create calculated line items (e.g., total revenue, direct materials / total revenue, staff expense / total revenue) using Natural Account hierarchy defined in ER…
-
Add Dimension Alias status is in Queue since more than 24 hoursTeam, Created Dimension Alias using Create button from Fusion > Data Augmentation. Row created as below and semantic model status is in Queued since more than 24 hours a… -
Issue in displaying Name - Description in the Report title of FDI Classic HomeHi Experts, I have a requirement to display Facility name - Description based on Facility description selected in Dashboard prompt. I'm using Facility name & Description…
-
FDI: Support new ADW In-Memory capability?Hi All With ADW now supporting In-Memory: https://blogs.oracle.com/datawarehousing/post/database-inmemory-is-now-available-on-oracle-autonomous-database-serverless Are t… -
GL transaction report via CAA using subledger transaction amounts - rounding differences to GLHi, We're trying to create a GL transaction report which includes the subledger transaction amount when the source is a subledger. The report needs to agree back exactly…
-
Dataset having single record but when added to dataflow shows inflated dollar valueHas anyone faced this issue ? We have data sets (Mode-Live) using LSQL and that does not have any duplicates, in this example we specifically added more filters to deal … -
Failed to retrieve schemas from the 'Local Subject Area' connection during dataset creationHello, on FDI, we have the pipeline that reads from Oracle Fusion HCM. On the OAC of FDI, when I try to create a dataset using the Local Subject Area connection, the err…
-
Aggregation and weighted average?I am a newbie to FAW so seeking for help here. I am trying to display the weighted average price for products but have no idea how to achieve it. In the below table, I w…
-
Schedule the dataset is having issues with Data Access Set to Automatic CachingHello Team, When I am trying to schedule a dataset, its saying No Datasets found with Data Access set to Automatic Caching. In this regard, need your inputs how to overc…
-
Create or Convert to Dataset failedI am in the process of Creating your own metadata dictionary in FDI using this blog. As part of this I need create two data sets and able to create 1 data set w.r.t ADW …
-
Extended Fact (similar to an Extended Dim)?Oracle provides many good subject areas and fact tables in the Autonomous Data Warehouse. If I need to provide additional custom "fields", I can create a custom extended…
-
Is it possible to create parameter that can select multiple values?Hi, I just want to know the possibility of creating something like below in Power BI that I can have the capability to select multiple columns with one parameter. Cause … -
Edit mode vs Presenting mode: why do they show different data?When developing my FDI dashboard all data are up to date but when I switch into presenting mode data are some week old. Why? Do I need to run some process to refresh dat… -
Oracle FDI Reporting ConfigurationsIt is recommended that the Oracle FDI Reporting configurations has to be set prior to executing the data pipelines. But in my recent project (HCM) I noticed that at any …Jagadeesh Somasundaram-Oracle 21 views 2 comments 1 point Most recent by Jagadeesh Somasundaram-Oracle -
ERP/SCM to FAW pipeline transformation logicCustomer wants to know the lineage for every report field from ERP/SCM to FAW. E.g. if all Subject areas and Metrics are flown from ERP/SCM to FAW as it is or are there …
-
Create Presentation Variable in FDI OACHello Experts, Is there a way we can create Presentation variable in FDI use it in OAC DV much like OAC Classic Home. If available.Please let us know on how to create & …
-
Fusion Prod to Dev Clone (Development System Refresh)Hi all, What is the recommended approach to Refresh a FDI Dev environment after a Fusion Prod to DEV clone occurs. We have our ERP Dev environment being cloned monthly f…