Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- 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 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
-
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 & …
-
Applying filter to report attribute but keep the rank as unfilteredI am creating "Rank" function on a calculated measure. It works fine. But when I filter on a column value the rank changes. Is there a way I can apply filter on an attri…
-
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… -
How to hide a few FDI/FAW reports/dashboards from the out of the box prebuilt contents.Hi Team, We have requirements where business wants to hide a few FDI/FAW reports/dashboards from the out of the box prebuilt contents. Please let us know if we can hide …