Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Segmantic Model
I am confused about the difference between creating a Dataset/Dataflow and building a Semantic Model. Since both can be used to create reports and dashboards, what is the critical difference between them? Could you please provide specific real-world use cases illustrating when I should use a Semantic Model instead of a simple Dataset?
Answers
-
Hi @User_PH7HJ,
Welcome to the Oracle Analytics Community!
Please find below some high level explanation and few Docs / Links which might be useful for better understanding.
Dataflows in Oracle FDI allow users to curate data visually without coding.
Mainly used for: To extract, clean, transform, and blend data from different sources (Oracle Fusion SaaS or external apps).
Key Capabilities:
Join/Blend: Combine data from different sources (e.g., Fusion ERP + Excel file).
Transform: Add calculated columns, aggregate data, or apply machine learning models.
Automation: Can be scheduled to run to keep the dataset updated.Semantic Model (Presentation & Governance Layer):
The Semantic Model (often called RPD in Oracle terminology) is a metadata layer that sits on top of the Autonomous Data Warehouse (ADW).
Mainly used for: To turn raw or transformed data into a business-friendly structure (Subject Areas) that ensures a 'single source of truth'.
Functionality: Defines relationships, hierarchies, and business metrics (Measures) for reporting.
Key Capabilities:
Abstracts Complexity: Hides complex database joins and SQL behind simple, named columns and measures.
Security: Enforces row-level or object-level security.
Hierarchies: Defines drill-down capabilities (e.g., Year > Quarter > Month).Hope this help.
Thank you.
0 -
Hi @User_PH7HJ,
Additionally, please take a look into the following posts / sessions which will be useful for the better understanding.
Fusion Analytics Extensiblity Series: Case study-Data Augmentation (Part 2 of 4) — Oracle
Fusion Analytics Extensiblity Series: Case study-Semantic Model (Part 3 of 4) — Oracle
Hope this help.
Thank you.
0
