Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Low Code, Low Cost BI with Oracle APEX and Analytic Views

Insum - A Talan Company
4.42K subscribers
<__slot-el>
<__slot-el>
3.9K views 6 years ago
Oracle introduced Analytic Views as part of Oracle DB 12c Release 2. Now we can very easily write complex hierarchical and dimensional queries against existing database tables and views using very simple, straightforward SQL. All complexity is captured in the view definition. Aggregations, joins, computations, etc. are all defined in the Analytic View. When coupled with Oracle Application Express (APEX), Analytic Views provide serious BI report capabilities that can be quickly tailored by the end user as requirements change. Your IT resources no longer need to be the bottleneck. ...more
...more
Low Code, Low Cost BI with Oracle APEX and Analytic Views
38Likes
3,970Views
2018Aug 23
Oracle introduced Analytic Views as part of Oracle DB 12c Release 2. Now we can very easily write complex hierarchical and dimensional queries against existing database tables and views using very simple, straightforward SQL. All complexity is captured in the view definition. Aggregations, joins, computations, etc. are all defined in the Analytic View. When coupled with Oracle Application Express (APEX), Analytic Views provide serious BI report capabilities that can be quickly tailored by the end user as requirements change. Your IT resources no longer need to be the bottleneck.

Follow along using the transcript.

Insum - A Talan Company

4.42K subscribers