Query Oracle Analytic Views Using Power BI, Tableau and other BI Tools
Blog: Oracle BPM
Oracle analytic views provide an in-database semantic model with OLAP-like calculation and query semantics. Analytic views are layered over tables (and views) to provide applications with predefined aggregation rules, calculated measures, hierarchical navigations, and rich data presentation metadata. This post describes how applications that use the SELECT .. FROM .. GROUP BY query pattern can query analytic views without those applications having any special knowledge of analytic views.