When performing a cube deployment operation in Oracle Essbase Studio, DIMBUILDSTATSINTERVAL specifies the number of records to process before reporting on dimension build progress. Progress information is displayed in the Essbase application console.
Load status information is written to the Essbase log file.
The default value is 20000, meaning that dimension build progress information is updated in the build status window after each 20000 records is processed.
DIMBUILDSTATSINTERVAL [n]n—Required. An integer specifying the number of records to process before updating the dimension build progress information in the Essbase application console.
DIMBUILDSTATSINTERVAL 20000
If there are 50000 records to process in the data source, and DIMBUILDSTATSINTERVAL is defined at 20000, Essbase shows the dimension build progress in the Essbase application console after processing 20000 records, and then 40000 records.