Recreating the OLAP database

After the dimensions have been imported into the Designer database, the changes must be pushed to the OLAP database. You can create the dimensions individually or all at once by recreating the entire OLAP database.

Cube data cannot be imported until the dimension structure that corresponds to that data exists in the OLAP database.

  1. Go to Designer.
  2. Select File > Create Database.
  3. Select the Recreate entire database check box.
  4. Click OK. This process can take several minutes.
    Messages are displayed as the database is being created. At some stages in process there is no response until the stage is complete.

    After the dimension structures are created in the OLAP database, you can load cube data.