The data in an analytic workspace is refreshed by rolling off old data (if desired), loading new data, and calculating aggregate data. Before you can perform these maintainance tasks, you must map the dimensional objects to their relational sources.
For each cube, you can choose one of the following data refresh options:
Materialized views use the automatic refresh subsystem to detect when the summary data is stale, that is, older than the base data. There are several restrictions on using materialized views. However, if your requirements conform to these restrictions, then you do not need to monitor the data or schedule refreshes because Oracle Database does them automatically.
To create materialized views, refer to Creating Materialized Views.
The Maintenance Wizard runs the default cube script when maintaining a cube. The initial default cube script includes load and aggregation steps.
To create additional cube scripts, refer to Creating Cube Scripts.
Copyright © 2003, 2007, Oracle. All rights reserved.