|Oracle9i OLAP User's Guide
Release 2 (220.127.116.11)
Part Number A95295-02
The repository for OLAP metadata is known as the OLAP Catalog. OLAP metadata represents warehouse data as logical cubes, as described in "OLAP Metadata Model".
OLAP metadata must be defined and mapped to any data that will be accessed by the OLAP API. OLAP metadata may also be used by other types of analytical applications.
OLAP metadata maps to dimension tables and fact tables. The dimension tables must be organized in levels. The dimension tables and fact tables may be actual relational tables or they may be views representing data stored in analytic workspaces. A number of different warehouse configurations can be represented by OLAP metadata, as described in "Data Warehouse Requirements".
There are two tools for creating OLAP metadata:
However, the OLAP Catalog metadata views allow you to browse all the metadata in the OLAP Catalog. This includes metadata created by Enterprise Manager and metadata created by the
The OLAP Catalog includes the following:
Whether you create OLAP metadata programmatically or by using Oracle Enterprise Manager, you follow the same logical steps.
To create OLAP metadata: