Create Location Alias

Create on the database a location alias identifying a host name, database, user name, and password. Location aliases provide a shorthand way of referencing login information for other Essbase databases.

Minimum permission required: Database Manager.

Syntax

Use create location alias to create a location alias in the following ways:

Keyword	Description
create location alias	Create a location alias, identifying a remote host name, database, user name, and password. The location alias can be used by the @XREF function as an abbreviated login to a remote database.
create or replace location alias	Create a location alias, replacing any existing location alias of the same name on the same database.
...from <dbs-name>	Specify the name of the current database (the database on which the location alias is being created).
...to <dbs-name>	Specify the name of the remote database to log in to.
...at <host-name>	Specify the remote host name on which the remote database resides.
...as <user-name> identified by <password>	Specify a user name and password with which to log in to the remote database.

Notes

This statement requires the database to be started.
Location aliases created using MaxL must be valid. For information about location aliases, see the Oracle Essbase Database Administrator's Guide.
Location aliases are used by the @XREF function for cross-database calculations.

Example

create location alias EasternDB from Sample.Basic to East.Sales at Easthost as Fiona identified by sunflower;

Creates a location alias called EasternDB on Sample.Basic that represents the following login information:

server = Easthost
application = East
database = Sales
user name = Fiona
password = sunflower