Support for Materialized Views

Many of the Oracle OLAP features that are new in this release were added so that analytic workspaces can be deployed as materialized views. Most particularly in the OLAP DML the following statements which have been added and changed that Oracle OLAP uses to insure that it optimally handles OLAP data cells which correspond to relational null facts:

The DEFINE VARIABLE command now has a WITH NULLTRACKING phrase.
Two new functions, NA2 and NAFLAG , return values that Oracle OLAP uses to identify how an OLAP data value corresponds to a relational fact.
The CHGDFN command now includes syntax that adds or removes NA2 bits from a variable.

Typically, these OLAP DML statements are automatically generated during the process of creating a materialized view using the Analytic Workspace Manager; you will not explicitly write DML code that uses these new features. These changes are documented in this manual so that you can understand the automatically-generated DML statements.