Analytic views provide a fast and efficient way to create analytic queries of data stored in existing database tables and views.Analytic views organize data using a dimensional model. They allow you to easily add aggregations and calculations to data sets and to present data in views that can be queried with relatively simple SQL.Analytic views provide a fast and efficient way to create analytic queries of data stored in existing database tables and views.
Analytic views organize data using a dimensional model. They allow you to easily add aggregations and calculations to data sets
and to present data in views that can be queried with relatively simple SQL.
Attribute dimensions and analytic views typically use star schema dimension tables and fact tables as data sources. For larger data sets, tables in the in-memory column store can offer the best query performance with analytic views. Analytic views can also be used with external tables and remote tables.
You specify the data source with the using_clause in the attribute dimension or analytic view definition. You may specify an alias for the data source.
A database user who has the privileges required for access to the data sources can create analytic view objects. The creator defines the business model, which specifies how the data is queried, and implements the model by creating attribute dimensions, hierarchies, and analytic views.
courtesy: Oracle
Analytical View Presentation and Demo
Low Code BI using Analytical Views