Importing cube data in Designer

Cube data can be imported using Designer. The process is like that of importing structure.

Importing cube data overwrites the old data in the Infor EPM OLAP model with the new data. Ensure that you perform these operations first on a test installation to be certain the changes are correct, and the cube data is being loaded to the correct areas of the OLAP model. Ensure that you make backups of the OLAP databases before and after the integration imports.

  1. Start Designer.
  2. Connect to the model.
  3. Expand the model.
  4. Expand Configuration.
  5. Click Planning Settings.
  6. Click the Common Settings tab.
  7. Select [Click here to import the data of the Integration import].
  8. From the Source Connection list, select the connection to the depm_integration database. The import facility uses the connection to find all the available cube data tables that can be imported.
  9. Select the cubes to import and click Import.
    Messages are displayed as the dimensions are imported. Any error stops the process and prevents subsequent selected cubes from being imported.