How do I upgrade Informatica Hyperion Repository from 7.1.4 to 8.1.1

During the Hyperion upgrade from System 9 to Hyperion 11.1.1.1, there may be a need to upgrade the existing Hyperion DIM repository from 7.1.4 to 8.1.1 so that it can be used with Informatica 8.1.1.

Lets assume that you are setting up the new Hyperion 11.1.1.1 environment with DIM 8.1.1. and now you need to use the old Hyperion DIM repository that exists in System 9 environment.

- Export the DIM Schema from system 9 Database and import it into Target 11.1.1.1 environment
- Create a new Repository Service into Target in Admin Console and associate it with imported schema from System 9
- If you try to start the Repository Service, it will not start as the Repository Version is different from that shipped with Informaitca 8.1.1.
- You need to upgrade the Repository first, before starting it. To upgrade the repository, click on Action -> Upgrade Content in the Admin console for the Repository Service. You need to provide the Repository UserId/PWD Administrator/Administrator to initiate the upgrade process. Once the upgrade is successful, you should be able to start the repository.

Note: Before importing the DIM Schema from System 9 environment, DISABLE the Authentication Module. With Authentication Module turned on in the System 9 environment, you will not be able to associate the Repository Service with the DIM repository database imported from System 9 environment. You can disable the Authentication plug-in using the Repository Admin Console.