Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- Analysis and Data Visualization 982
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 444
- OBIEE 433
- Analytics 400
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 260
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 191
- Report Output 184
- Fusion Data Intelligence 170
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
-
How to schedule a report in FDI?I want to schedule a report but all I got is this: Why? -
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 22 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 & …