Building OLAP Catalog

Abstract

The Oracle OLAP option of Oracle Database 10g Enterprise Edition provides advanced analytic features to help us to summarize, analyze and calculate data faster than standard SQL. In this article I discussed about the CWM2, a set of PL/SQL packages which are using to create the OLAP Catalog metadata for an analytic workspace. BI Beans applications query OLAP Catalog metadata.

Keywords

• star schema
• dimensions
• cubes
• hierarchies
• levels
• attributes
• OLAP catalog
• SQL