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
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.
