9 Work with Physical Tables, Cubes, and Joins

Learn how to work with objects in the Physical layer of the Oracle BI repository, and describes Oracle Essbase, Hyperion Financial Management, and Oracle OLAP representations in the Physical layer. It also explains other Physical layer concepts like opaque views, hints, row counts, physical layer folders, and how to use the Physical Diagram.

This chapter contains the following topics:

• About Working with the Physical Layer

• Work with the Physical Diagram

• Create Physical Layer Folders

• Work with Physical Tables

• Work with Multidimensional Sources in the Physical Layer

• Work with Essbase Data Sources

• Work with Hyperion Financial Management and Hyperion Planning Data Sources

• Work with Oracle OLAP Data Sources

• Work with Physical Foreign Keys and Joins

• Deploy Opaque Views

• Use Hints in SQL Statements

• Display and Update Row Counts for Physical Tables and Columns