Prebuilt KPIs & Extensible Semantic Model
With Fusion Data Intelligence (FDI) — soon to be renamed as Oracle aligns its AI & Data branding — one of the most powerful (and sometimes underused) capabilities remains:
Prebuilt KPIs delivered on top of an extensible semantic layer running on Autonomous Data Warehouse.
🔹 What Makes FDI Different?
Unlike traditional BI implementations where you build everything from scratch, FDI provides:
- Prebuilt subject areas aligned to Fusion Applications
- Hundreds of curated KPIs
- Predefined conformed dimensions
- Enterprise-ready data pipelines
- Embedded AI-driven insights
All deployed on Oracle Autonomous Data Warehouse.
This dramatically reduces implementation time compared to custom OAS/OAC builds.
🔹 The Extensible Semantic Model
Where FDI becomes especially interesting for experienced Oracle Analytics professionals is extensibility.
You can:
- Add custom measures
- Extend dimensions
- Introduce additional fact tables
- Blend external data sources
- Apply row-level security logic
- Create additional subject areas
All while retaining Oracle-delivered updates.
This is crucial for organisations that:
- Have industry-specific KPIs
- Require additional operational data
- Need regulatory or region-specific reporting
- Want to integrate non-Fusion systems
🔹 Performance & Architecture Considerations
FDI runs on Autonomous Data Warehouse, which means:
- Query performance benefits from columnar storage
- Automatic indexing & optimisation
- Partitioning strategies managed automatically
- Elastic scaling for month-end reporting
For analytics teams, this means fewer DBA dependencies and improved concurrency for executive dashboards.
🔹 AI & Insight Integration
FDI also includes:
- Embedded predictive capabilities
- Anomaly detection
- Trend identification
- Narrative insights in dashboards
As Oracle pushes further into AI-native analytics, expect FDI’s AI components to become more tightly integrated with Oracle Analytics Cloud capabilities.
🔹 What to Watch
With the upcoming rebrand, we can likely expect:
- Closer alignment with Oracle’s AI Data Platform messaging
- Expanded AI-driven KPI recommendations
- Stronger integration between FDI and OAC
- Continued subject area expansion
For customers running Fusion Applications, FDI (under its new name) will likely remain Oracle’s strategic analytics layer.
Why This Matters for OAC & OAS Professionals
For consultants and architects:
- FDI reduces custom RPD development
- ADW underpins performance strategy
- Extensions still require strong SQL & modelling skills
- Governance remains critical (especially with custom objects)
If you’re coming from OAS, think of FDI as:
A prebuilt, cloud-native warehouse + semantic model + dashboards — with room to extend.
🛠️ 1. Official Oracle Setup & Admin Guides
✅ General Admin / Setup Docs
🔗 Set Up Oracle Fusion Data Intelligence
This is the main administrator setup page with step-by-step tasks like creating the service instance, SSO setup, data source config, that you’ll use to deploy FDI.
👉 https://docs.oracle.com/en/cloud/saas/analytics/25r2/fawag/oracle-fusion-data-intelligence.html
🔗 Typical Workflow to Administer Oracle Fusion Data Intelligence
A guided workflow for first-time setup that includes:
- Activating subscription
- Signing into OCI
- Adding admin users
- Configuring SSO
- Creating FDI instance
- Assigning users/groups
- Configuring data pipelines & security 🍃
🔗 Administering Oracle Fusion Data Intelligence (25R4 Help Center)
Table of contents for admin tasks, including instance creation, pipeline configs, user and role management, validation, customizations, and more.
📌 OCI Instance Creation
🔗 Create an Oracle Fusion Data Intelligence Instance
Explains how to create standalone or integrated instances of FDI via the Oracle Cloud Infrastructure console.
🔗 Create an Oracle Fusion Data Intelligence Standalone Instance
Step-by-step instructions for standalone instances (e.g., not tied directly to a Fusion Apps instance), including network, auth, and ADW credentials.
🔐 User/sso-related Setup
🔗 Set Up User Access to Oracle Fusion Data Intelligence Using Single Sign-On
Detailed SSO configuration scenarios depending on identity domains and how you federate users between OCI, Oracle Identity Cloud Service (IDCS), and FDI.
📊 Data Pipeline & Reporting Config
🔗 Configure Oracle Fusion Data Intelligence Data
Once the instance is created, this doc covers how pipeline parameters, global settings, data refresh, reporting configurations, and data pipelines for ERP/HCM/SCM subject areas are set up.
👩💻 2. Additional Resources & Tutorials
📘 Oracle Analytics Blog – Setup Example
🔗 Set Up an Integrated FDI Instance with a Fusion App
Oracle Architect blog with example steps (good conceptual walkthrough) for integrated FDI with a Fusion Cloud Apps instance.
🎓 Training / Workshop
🔗 Fusion Data Intelligence (FDI) Implementation Workshop
Oracle University training that covers implementation and configuration basics (note: accessible via Oracle Learn).
🧭 Quick Admin Steps (Summary)
Below is a typical setup path for administrators:
- Activate your FDI subscription in the Oracle Cloud console.
- Configure Single Sign-On (SSO) between OCI and FDI before creating instances (recommended).
- Create the FDI instance (integrated or standalone) via OCI Analytics & AI>Data Intelligence.
- Verify and access the service through the URL and admin console.
- Add admin users & assign roles (via IDCS or OCI IAM).
- Configure data pipelines to pull data from Fusion Cloud apps into the Autonomous Data Warehouse.
- Set up reporting and security roles so appropriate users see the correct subject areas.