Analytic Views are one of the main features for Business Intelligence introduced with Oracle 12c Release 2. They provide a lot of new possibilities for analytical queries on star schemas. This blog post gives an overview of the new functionality.
Analytic Views: Powerful Oracle 12.2 Feature for Business Intelligence
1