Dense Restructures

  To perform a dense restructure, Essbase does the following:

  1. Creates temporary files that are copies of the following files:

    essxxxxx.ind
    essxxxxx.pag
    dbname.otl
    dbname.esm
    dbname.tct

    Each temporary file substitutes either n or u for the last character of the file extension. Temporary file names are:

    essxxxxx.inn
    essxxxxx.pan
    dbname.otn
    dbname.esn
    dbname.tcu
  2. Reads the blocks from the database files copied in step 1, restructures the blocks in memory, and stores them in the new temporary files. This step takes the most time.

  3. Removes the database files that were copied in step 1

  4. Renames the temporary files created in step 1 to the correct file names.