In previous releases, if you promoted an Essbase database you had edit the HPS_EXTERNAL_DATASOURCE database table on the target server to reference the correct Essbase application and database in the target environment. You can now reference another Essbase database by modifying its connection. For example, to promote from a development environment that uses a development-dedicatedEssbase database to a production environment with its own Essbase database, reference the production database by changing these connection settings:
Host name
Logon credentials
Application name
Database
Note: | The Essbase database in the target environment must have the same dimensional structure and mappings as that in the source. If it does not, you must remap all dimensions and your measure templates. See Modifying External Data Sources. |