Home > About Loading Data into Dim... > About Maintenance Logs
![]() Previous |
![]() Next |
The first time you load data into a cube or cube dimension, OLAP creates several logs. These logs are listed under OLAP Reports in the Reports navigator. They are also stored in tables in the same schema as the analytic workspace:
Build Log: Contains information about what happened during a build. Use this log to determine whether the build produced the results you were expecting, and if not, why not. The log is continually updated whenever a cube or dimension is refreshed. You can query the log at any time to evaluate the progress of the build and to estimate the time to completion. The default table name is CUBE_BUILD_LOG
.
Dimension Compile Log: Contains errors that occur during the validation of the dimension hierarchies when OLAP is aggregating a cube. The default table name is CUBE_DIMENSION_COMPILE
.
Cube Operations Log: Contains messages and debugging information for all OLAP engine events. The default table name is CUBE_OPERATIONS_LOG
.
Rejected Records Log: Identifies any records that were rejected because they did not meet the expected format. The default table name is CUBE_DIMENSION_COMPILE
.
These logs enable you to track the progress of long running processes, then use the results to profile performance characteristics. They provide information to help you diagnose and remedy problems that may occur during development and maintenance of a cube. They also help diagnose performance problems in querying cubes. You can query the tables using any SQL interface.
You can also run the $ORACLE_HOME/olap/admin/utlolaplog.sql script to create the build log with some useful views.