Lot of customers have asked us what should be factors that need to be factored in while deciding on creation of Aggregation tables vs Materialized views.The blog tries to discuss the considerations while deciding between the two
Helpful!
Users should also look at the 'Analytic Views' (AVs) functionality of Oracle database. It simplifies analytical reporting significantly. There is no need to create Summary table or MVs. BI Data Model (including hierarchies, attributes and measures) is pushed inside database.
All data exists at all levels of all dimensions, and no need for SUM..GROUPBY queries.
The new sql syntax (of AVs) simplifies creation of calculations - like Time Series calcs.
All queries are simple SELECT..FROM…WHERE types of queries - with no need for JOINs and aggregation.
OAC DV has a separate data source for 'Analytic Views' in addition to Oracle Autonomous Database.
Even Essbase Federated Partitions (in essbase-cloud) use 'Analytic Views' features of autonomous database - behind the scenes. https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html
There is a livelab at:
https://apexapps.oracle.com/pls/apex/r/dbpm/livelabs/view-workshop?wid=3594
Bud Endress has many videos on YouTube about 'Analytic Views'.
He has also written some blogs about it:
https://blogs.oracle.com/datawarehousing/authors/william-endress
Did
In this session, get an inside look at the OCI Enterprise AI product roadmap, with updates across AI agents, model access, and governance. See OCI Enterprise AI in action through demonstrations of an autonomous order fulfillment agent, the Enterprise AI model playground, and AI guardrails for content moderation, sensitive…
In this session, explore the latest Oracle Fusion Data Intelligence (FDI) roadmap updates across ERP, HCM, SCM, CX, and platform capabilities. Learn how Oracle is expanding analytics coverage with new subject areas, prebuilt content, and deeper operational insights, while advancing AI-enabled workbooks, chat-based…
In this session, learn about the latest Oracle AI Data Platform product roadmap updates and see newly released and planned features in action. Explore visual agent building, multi-agent workflows, knowledge bases, MCP integrations, and more. The session also demonstrates how Codex skills can streamline data engineering and…
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…
Build on the foundational concepts from Part 1 with a deeper look at implementation patterns for extending the FDI semantic model. This session covers common use cases such as modifying subject areas, creating custom subject areas, combining external application models, and supporting custom security requirements. It also…
