About
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 specifies :
- an alias,
- a server,
- an application,
- a database,
- a user name,
- and a password.
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 function. With this function, 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. See the Oracle Essbase Technical Reference.
Articles Related
Managing Location Aliases
You can manage a location alias for a particular database by using this tools :
| Tool | Topic | Documentation Location |
|---|---|---|
| Essbase - Administration Service (EAS) | Creating Location Aliases Editing or Deleting Location Aliases | Oracle Essbase Administration Services Online Help |
| Essbase - MaxL | create location alias display location alias drop location alias | Oracle Essbase Technical Reference |
| Essbase - EssCmd | CREATELOCATION LISTLOCATIONS DELETELOCATION | Oracle Essbase Technical Reference |
A location alias is set at the database level. Set the location alias on the database on which the Essbase - Calculation Script is run.