The aim of this page is to provide a glossary of common OLAP and data warehousing terms and expressions. Click on a letter to view a separate page containing definitions and definitions for that letter.

A... Active Catalog Additive Aggregation Aggregation Map (aggmap) Allocation Analytic Workspace Analytic Workspace Manager Ancestor Attribute AWXML B... Balanced Hierarchy Base Level Data Base Measure C... Calculated Measure Cell Child Commit Composite Compressed Cube Compression Constraint Advisor Cube Cube Organized MView Cube View Custom Measure Custom Member D... Data Source Data Mart Data warehouse Database Standard Form Decimal Denormalized Derived Measure Descendant Detail Data Dimension Dimension Key Dimension Table Dimension Value Dimension View Drill E... EIF EIFVERSION Embedded total Eversion Export Expression F... Fact Fact Table Formula G... H... Hierarchy I... Import Infile J... Join K... Key L... Leaf Data Level Level-based Hierarchy M... Mapping Materialized View Measure Measure folder Measure view Metadata Model

N... $NATRIGGER NAFill NAspell Non-additive Number O... Object type OLAP OLAP Analytic Engine OLAP API OLAP DML OLAP Page Pool Memory Area OLAP Worksheet OLTP On the fly P... Page Page Source Parent Parent-child Relation Partition Precalculate Precompute Property Q... QDR Qualified Data Reference R... Ragged Hierarchy Refresh Relation Row Source S... Skip Level Hierarchy Snowflake Schema Solved Data Source Sort Sparsity Sparsity Advisor Standard Form Star Schema Status Summary T... Time Dimension Top-level U... Unbalanced Hierarchy Update Update window V... Value based hierarcy Variable W... X... XML_LOAD_LOG Y... Z... Zerorow #... 3NF