Using Location Aliases

A location alias is a descriptor for a data source. A location alias maps an alias name for a database to the location of that database. A location alias is set at the database level and specifies an alias, a server, an application, a database, a user name, and a password. Set the location alias on the database on which the calculation script is run.

After you create a location alias, you can use the alias to refer to that database. If the location of the database changes, edit the location definition accordingly.

You can use location aliases only with the @XREF and @XWRITE functions. With @XREF, you can retrieve a data value from another database to include in a calculation on the current database. In this case, the location alias points to the database from which the value is to be retrieved. With @XWRITE, you can write values to another Essbase database, or to the same database. See the Oracle Essbase Technical Reference.

The following considerations apply when using location aliases in secure (SSL) mode: