Migrating individual cubes or dimensions, Infor EPM 11 to Infor EPM 12
-
In EPM Administration select Dashboards > OLAP > Databases. Select the target database and click the Stop icon.
The database is saved and a metadata.json file is generated. Optionally select Dashboards > OLAP > Save and Backup to make a backup of the database.
- Go to the source database file directory location.
- Create a .zip file for the base structures of the source database. Do not include large cubes or dimensions.
- Import the base structures of the source Infor EPM 11 database to the target Infor EPM 12 database.
- Create a new custom application with OLAP capabilities as a minimum.
- In the EPM Administration application select Dashboards > OLAP > Databases of the new custom application and import the .zip file with the source base structures by replacing the database.
- Run Service Expert, click the Directories tab and locate the target central database file. Make a note of the location.
- In EPM Administration select Dashboards > OLAP > Databases and make a note of the target database Save Version number.
- Repeat steps 2 and 3 for the source database.
- Create a copy of the source OLAP cubes or dimensions files from the directory location that is displayed in the Service Expert.
- Create a .zip file of the copied source OLAP cubes or dimensions files. Do not include the metadata.json file in the .zip file.
- Copy the .zip file and paste it into the target database file storage. Extract the .zip file.
- In EPM Administration select Dashboards > OLAP > Databases. Select the target database and click the Start icon.
- Optionally, check if the database is in a corrupted state. Select Dashboards > OLAP > Databases Troubleshooting. If the database is corrupted, it has a Wrench icon against it. Click the Wrench icon to start repair.
- Optionally, confirm that the OLAP cubes and dimensions are loaded correctly. Select Dashboards > OLAP > Edit Database. Check if all cubes and dimensions are visible.