Creating Materialized Views

You can create materialized views for query rewrite, automatic refresh, or both.

Note: If a cube is enabled with materialized view capabilities, then you cannot execute a cube script for that cube.

To create materialized views:

1. Select a cube in the navigation tree.

2. Display the Materialized View tab.

3. Correct any errors in the definition of the cube that appear on the Refresh and Rewrite subtabs. Analytic Workspace Manager checks the cube for the prerequisites for adding materialized view capabilities.

4. Complete the Materialized View tab.

5. Click Create.

Copyright © 2003, 2007, Oracle. All rights reserved.