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