Popular Tags
- OTBI 1,364
- Reporting 1,352
- Analysis and Data Visualization 898
- FDI 884
- BI Publisher 789
- Analysis 654
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 323
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 213
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 179
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 141
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 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… -
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…
-
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…
-
Filtering different datasets with a common attribute Expression Filter vs Regular Calculation (Case)Current Version: FDI 24.R4.P2 / Oracle HCM Cloud 24D (11.13.24.10.0) Context: For a simple / proof of concept type dashboard, we want to drop in some subject areas and C… -
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… -
Does FDI allow user input exchange rate in Pipeline settings?What do these options represent? Is the last 'User' an option to manually enter the exchange rate? If so, where can this be done?
-
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…
-
How to use OTBI subject areas in Oracle FDI?Hi, I am trying to pull/use OTBI subject areas in Oracle FDI. Is there a way to do so? Thanks, Ruvina
-
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 28 views 2 comments 1 point Most recent by Jagadeesh Somasundaram-Oracle