How To Change Shared Services Database Repository in EPM 11

How To Change Shared Services Database Repository in EPM 11 [ID 976279.1]
		Modified 08-FEB-2012     Type HOWTO     Status PUBLISHED

In this Document
  Goal
  Solution
  References

---

Applies to:

Hyperion Essbase - Version: 11.1.1.3.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.
Unix Variable reference
$HYPERION_HOME={location to Hyperion Home installation}

Windows Variable reference
%HYPERION_HOME%={location to Hyperion Home installation}

Goal

How to reconfigure your Shared Services or EPM products database using the configuration tool.

NOTE: This article assumes you want to recreate a new database repository

Solution

For versions 11.1.1.x:

1. Stop Shared Services and other EPM products.
2. Change directory to $HYPERION_HOME/common/config/9.5.0.0 directory.
3. Rename or move the reg.properties file to save it as a backup copy.
4. While still under the config/9.5.0.0 directory change directory to products/foundation/9.5.0.0 (to change database settings for Shared Services.

For other products, change directory to products/{products_name}/9.5.0.0)

5. For Shared Services edit the foundation_1_config.xml file.
6. Within the file find the text "relationalStorageConfiguration.
7. Change the value "Configured" to "Pending" or "Unconfigured". Either is acceptable.
8. Save the xml file.

Windows Example:

C:\Hyperion\common\config\9.5.0.0\product\foundation\9.5.0.0
You will see the following tag in "foundation_1_config.xml" file

<property name="relationalStorageConfiguration">Configured</property>

<----change to------>
<property name="relationalStorageConfiguration">Pending</property>

9. Run the configtool from $HYPERION_HOME\common\config\9.5.0.0 directory and do the database configuration task(s) again. Run the database configuration task for Shared Services first then each additional product if applicable.
For versions 11.1.2.x:

You cannot change a configured Shared Services database directly in EPM System Configurator without removing the file that contains the previously configured database information:

1. Navigate to EPM_ORACLE_INSTANCE/config/foundation/11.1.2.0.
2. Backup/copy the reg.properties file.
3. Delete the reg.properties file.
4. Restart EPM System Configurator.
5. Reconfigure the Shared Services database by selecting "Connect to a previously configured database."