Sangam17 has ended
Please note: Agenda and speakers are subject to change.
Back To Schedule
Saturday, December 9 • 14:55 - 15:45
Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2 LIMITED

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Limited Capacity seats available

Session Abstract:

As experienced Oracle DBAs know, building a Data Warehouse is just the beginning of any successful application for performing complex analytics – you’ve also got to build the proper analytic views, fact tables, dimensions, and queries to make sense of the DW’s data. Oracle 12cR2 now provides a simple way to build out just the right objects for an analytics environment using just a few simple commands. Best of all, these new objects can incorporate all the needed measures and calculations so that an application end-user can take advantage of precisely-defined data models without having to construct complex views on their own, thus limiting the chance of producing erroneous analyses through a simple mistake like a missing join or filter.


Session Outline:

Through presentations and demonstrations, this session illustrates how to leverage the latest features of 12cR2 Analytic Views to:

- Build complex hierarchical relationships between data elements

- Enhance analysis techniques for use across multiple dimensions

- Leverage built-in functionality to quickly construct measures and metrics with a simple set of commands


  1. 1.     Introduction to Built-In 12cR2 Analytics Features
  2. 2.     Constructing Hierarchies and Relationships: CREATE HIERARCHY
  3. 3.     Adding Enhanced Dimensions: CREATE ATTRIBUTE DIMENSION
  4. 4.     Building Analytic Views: CREATE ANALYTIC VIEW
  5. 5.     Putting It All Together: Examples of the Power of Analytic Queries
  6. 6.     Conclusions


Objective #1:

The attendee will understand how to build complex hierarchical relationships and dimensions with simple 12cR2 commands.


Objective #2:

The attendee will discover how to quickly create complex analytic measures and metrics without having to build equally-complex queries.


Session Prerequisites:

To gain the most from this presentation, attendees should be familiar with basic data warehousing (DW) and decision support systems (DSS) concepts, including hierarchies, dimensions, fact tables, and materialized views.

avatar for James Czuprynski

James Czuprynski

Senior Enterprise Data Architect, Viscosity North America
Jim Czuprynski has 35+ years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public... Read More →

Saturday December 9, 2017 14:55 - 15:45 IST
Room 1 (Hall 1)