Popular Tags
- OTBI 1,429
- Reporting 1,384
- FDI 1,064
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 409
- Analytics 384
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 224
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 169
- Customizing Reports 156
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
-
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 & …
-
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 …
-
Data Validation userWe are trying to use the Data Validation feature We created a user like described here: Create a User to Validate the Extracted Data But it says insufficient privileges …
-
FDI accounting sequence number fieldIn the FDI general ledger transactions subject area, how can I view the accounting sequence number field?