Analytic View Enhancements to SQL and PL/SQL

SQL and PL/SQL enhancements for analytic views are the following:

  • Star views can be created on fact and dimension tables
  • Analytic views are created automatically for queries of the tables and views
  • Level group caches are created and maintained autonomously
  • Query-scoped base measures
  • Support for remote sources
  • Support for aggregate tables
  • Star support for dimension caches

With these enhancements:

  • Star view and star table queries can use the benefits of analytic views without any code changes
  • Front-end tools can use analytic view calculations by inserting a new expression
  • Level group caches can become more efficient over time based on usage patterns

Related Topics