Description
From Oracle Database 12.2, one of the biggest news in the Data Warehousing / Analytics area was the introduction of the Analytic Views, that as per Oracle's definition are Metadata objects that enable the user to quickly and easily create complex hierarchical and dimensional queries on data in database tables and views.
OAC can connect to oracle data source and visualize data of "analytics view" type directly.
Use Case and Business Need
The wave of self-service BI tools like Tableau or OAC provided products capable of querying almost any kind of data sources in a visual and intuitive way directly in the end user hands. An easy and direct access to data is a good thing for end user but, as stated above, requires knowledge of the data model, joins and aggregation methods.
The self-service tools can slightly simplify the process by providing some hints based on column names, types or values but the cruel reality is that the end-user has to build the necessary knowledge of the data source before providing correct results.
This is why we've seen several times self-service BI tools being "attached" to OBIEE: get corporate official data from the unique source of truth and mash them up with information coming from external sources like personal Excel files or output of Big Data processes.
If OAC can read "analytics view" type directly from Oracle Database, it will really help business users to analytics data from Oracle database.
Original Idea Number: f85392da65
