Oracle Database 11g significantly improved the flexibility of accessing the Oracle
database OLAP Option. Although queries were accessible via SQL in the past, business
users needed to specifically point their queries to OLAP Option cubes. When
deployed in Oracle Database 11g, the OLAP cubes can be used transparently as an
alternative to materialized views since Oracle??™s SQL query rewrite recognizes the cubes.
The materialized view refresh can refresh OLAP cubes as of Oracle Database 11g.
OLAP Option cubes are deployed in what are called analytic workspaces. They can
be created using Oracle Warehouse Builder or using a simplified logical dimensional
modeling tool called the Analytic Workspace Manager (AWM). Both tools provide
interfaces for creation of the cubes and for building maps from relational tables into
the cubes.
Custom OLAP applications can be built using Oracle??™s JDeveloper and business
intelligence beans, although this is much less common than using off-the-shelf tools.
246 | Chapter 10: Oracle Data Warehousing and Business Intelligence
The Java beans provide prebuilt components for manipulating tables, crosstabs, and
graphs and for building queries and calculations similar to the functionality previously
found in Express.
Pages:
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541